Yes, the great uncle Sam.. :)) very informative, not sure why I spent more than 10 minutes of my life on this and I'm still smiling (maybe thinking of how creative people can be)
Hi all, I believe the 2nd solution is adding half a circle's area to the completed ring to both ends (so a full circle) which changes the visual proportions. Better would be if the whole of the circular disk was inside the completed ring, with the circumference tangent to it. This may not be much of a problem if the completed percentage is high enough, but it does skew the visual info the graph is communicating. Also, if the completed percentage is small, like 1% or even 5%, this will certainly give the wrong picture to the audience. It will start to become apparent. In the case of small percentages, we risk the radious of the circle being to large to depict them. As such with this method we can show up to a certain minimum of completed percentage. I just saw this and i don't have the time to create and test it (02:50, here in the UK and i have to be in the office in 5 hours...) but if i had to guess i'd say it shows a full circular disk even at 0%. A better way to implement something like this would be to have ellipses at the end of the ring, where the a,b parameters would be dynamically linked to the completion percentage, with possibly an upper bound, to avoid extremes. The equation of an eclipse is (x^2/a^2) + (y^2/b^2) = r^2. a,b and r are given in squares for symmetry. For a=b we get a circle (the above equation becomes x^2 + y^2 = r^2*a^2 (or *b^2), which is basicaly x^2 + y^2 = R^2 (just a new r, as a,b are parameters). Can you please check what happens for 0% or 1% ? I feel the first solution is correct.
It would have been nice to see the results of both methods at 99%, 98%, ..., etc. And then see at which % point does each method not have overlapping pixels.
I agree, but given the series are provided through a calculation i feel like we can simply subtract the radius of the scatter plot markers to account for the difference. 1 important thing though will be that one needs to add the removed radius back to the doughnut when the input value = 100% Otherwise my solution will give you a slight area where the grey is still showing although the percentage is 100%. I'll be using my adaptation of Sams solution here. Great work, thanks for sharing both! :)
I didnt understand the sin & cos function, but one thing I know is that I used this method of creating the doughnut chart at my work, and this changed my life. Thank you Leila.
Kudos to Sam! I must humbly admit I would not have come up with this solution. But then again, I can't think of a situation where I would go through the trouble of making round edges!
Hi Leila, I think I'm writing a bit late and other people might already have picked up on the issues with the second version. 1) the markers and the textbox don't resize automatically . So, don't bother to size the circle until the very end. 2) the formula calculating x and y are not stable either. They are affected by the size of the circle diameter. I extended the axis from -1.15/1.15 to -1.25/1.25 to have more leeway and then adjsted the circle to centre the markers. Perhaps, an expert mathematician could provide a dynamic formula? However, it's a very cool trick 😄 Looking forward to seeing you at the next Excel gathering in January.
Just wanted to let you know this post is amazing, and your library of topics makes you a genius in my non-mathematical mind :) And I echo many of the appreciative comments made below. Thanks much for your efforts!
Sam's nice tweak solution is to - Add Start and End points as Filled Circles at a calculate points (Simple Trigonometry) - Fix the graph so the circles are plotted at expected points - Define the scale of each axis Personally i prefer the simpler solution but i am fascinated with the math.
The second method got me thinking, I really wanted to understand the mathematical concept behind it. So, I created a video and uploaded it on my channel explaining that, the method I used is slightly different than the one explained here, but it has the same output. I would really appreciate your feedback on that if possible. By the way, I’m a big fan of your content, I have been watching your videos since a very very long time, I learned a lot from you and now I’m teaching Excel online and offline. So Thanks again for your great content and effort. All the best to come!!
I LOVE EXCEL. BUT AS I STARTED TO ATTEND THESE LECTURES. I REALLY EXPERIENCED A DIFFERENT AND NEW KNOWLEDGE BASE ASPECTS OF EXCEL. I AM THANKFUL TO MAM LEILA GHRANI
Now I understand why did we need to learn the sin, cos and tan functions in schools. So that one day we will stumble upon this video in this amazing channel.
for real. While this solution is brilliant it is more aptly an example of how horrendously behind Microsoft is in employing such a simple shape feature to their doughnut chart. This should be a one click solution for 'rounded edges' in the chart format page.
Really great solutions, both of them. Nevertheless , in order to become a little bit unpopular, Sam's one, to my opinion is not mathematically correct: As the center of the circles are put on the edges of the non-circle version, the resulting semi-circles reach into the area of the (1 - progress) part, such making the progress part optically larger than it really is ;-).
Wow!!! I love an aesthetically pleasing spreadsheet and I love technicality driving this but I could never see myself putting all this work into a progress donut. It's still very cool and I love when ideas are turned into challenges and then turned into solutions. THIS is a great example of obfuscation or as I like to say, there is complexity behind the simplicity.
That’s very cool! I’ve recently been using a donut chart and pie chart on different axis for velocity of improvement, but this does look really cool, I’m going to give it a go today!
Hi Leila! Brilliant as usual and kudos to Sam for the wonderful idea. I will use it in my reports and presentations. Looking forward to meeting you in Slovenia Excel Olympics! I hope I will get few mins of talk time with you. I am all set for Slovenia trip from Dubai. Take Care!
Your excel tutorials are my go to when I am stuck up. Thank you so much for guiding me in my quest for better excel knowledge. I already have taken up your VBA course in udemy. :) Once again Thank you so much.
Awesome stuff, Leila. I'll try your method. Immediately thought that it can be used for Dashboards or to visualize metrics. Is it possible to have the color be dynamic? I mean, let's say if the number is below 70%, The progress bar would be Red. And then if greater than or equal to 70% but less than 90%, it would be Yellow or Amber. If greater than of equal to 90%, it would be Green.
Hello @ Leila Gharani. I am so grateful for your tutorials. Thank you so much for sharing your Excel wisdom with us. I've followed your instructions very carefully to get the same results. I am very close but it seems that my the Sin/Cos points are slightly off - looks like they are off by one/two pixels. I've tried to adjust the graph's size but I can't find a size where the end points (in Sam's example) are totally aligned with the rest of the progress bar. Do you have any suggestions? Thx!
Hi Leila.. great video and techniques! I like both.. yours for the relative simplicity of setup.. and it looks great, even though not perfectly rounded at the caps.. and Sam's because of the clever way he designed the solution using trigonometry and the perfectly rounded caps are certainly visually appealing.. no denying that fact. The analyst in me wants to understand all the math behind Sam's version, but I'd probably go to your version first to get work out the door since it is easier and quicker to set up and maintain. Thanks for showing both approaches. Always something new and interesting coming from you and your channel. Thumbs up!! PS - On your version, if you make the point width of the remainder the same as the percentage complete.. say 14 point each.. it looks pretty good too. The color differential makes the percentage complete stand out pretty well, as is. As you said.. either or.. depending on personal preference :))
@Alex Ooi Hi Alex.. thanks for your feedback. Been fooling around with this a bit.. re-learning my high school trig which was about 100 years ago.. haha!! Now I remember how to plot points on a circle, convert degrees to radians for cartesian coordinates, use SIN(), COS() and RADIANS() functions in EXCEL. All good learning. I like Leila's method for the clever but simple setup.. can crank that one out quickly and it looks good. I like Sam's method for the cool use of trig and clever plotting of the points at the stationary and leading edges of the variable doughnut part.. but.. it takes a little longer to set up and getting it perfect can take some trial and error. Both great methods.. all good stuff to learn and exercise the brain cells. Thumbs up!!
This was so helpful! I did everything step by step, everything is working as great, but every time a value changes in my spreadsheet, there's always a 'Excel found a problem with one or more formulas in the worksheet..' message. I re-entered the values and formula but am still getting the message. Will keep working on it. Otherwise everything has been working great. It's just the message that keeps popping up
The trouble with rounded edges is the ambiguity as to where to read them - at the farthest point, the middle, or somewhere else. It is less impt here but still imprecise for the "reader" if he/she/they don't know how you programmed it.
This is so great. Thank you. I'm having a problem with the donut chart. When I follow the same steps, I get the blue color showing with the edges underneath the grey instead of on top of them. Anyone have any idea on how to fix this?
This is Mohamed Basith with u.. Mrs. Leila I tried both your and Sam's model of making the charts.... Your model is quite easier and reliable for wide range of percentage changes.... ( I have one correction for your method - For fill option solid line and color changing and you change the grey dougnut thickness as 7 & blue as 13. But during my try i use the blue color as 13 as per your advise and i try to adopt the grey color will almost equal to the thickness of the blue so i use thickness 10 for grey it looks pretty much same as sam's chart.) However, sam's method is quite intresting while looking the video but it will not be practical for the diverse users sheets...(which means sam's -1.15 & 1.15 axis range will no more applicable for all the excel sheets. hence it will applicable only for sam's excel sheet) rest is fine. Hope anticipate many useful videos like these session to enhance the power and efficiency of the excel software... Thank you both....
Great. but there is a little missing. That is when you explain the point number one (x of 0, and y of 1) you point the zero on the bottom of the circle but actually it is on the center of circle. I think it goanna be helping for us to understand next the formula which calculating the coordinates of the point number two.
Thank you Leila for sharing such a useful tips. It helps to work for efficiently without compromising the presentation style of the chart. However, I noticed that I have 1 issue, the text box that inserted into the doughnut chart and also the end point marker size doesn't seem to lock to the chart ratio. If we enlarge the chart, we have to manually adjust them. Is there anyway we can automate this task?
Hey, this is in no way related to the video, and maybe it's a bit too specific of a topic that may not interest a lot of your viewers, but I have an Excel that has a custom SQL that references an external Oracle SQL. I would like to have the SQL reference a pair of cells within the excel so I can have the users enter date & time values and have that serve as variables in the SQL. I don't think I've seen anything like this on your page so I doubt that it'll be something you would cover but I figured it would be worth asking. Thanks for the videos!
You can do this using parameters in your connection window and question marks in your SQL query. Should be plenty of videos around showing how to do it.
Wow... nothing wrong with using math in life but just to get a simple chart with rounded edges there has to be an easier way! I'd go with Leila's method and be satisfied that it's round enough lol, but honestly bravo for integrating sin/cos and pi into a chart!
![How to Instantly Improve Your Excel Charts [Watch This!]](http://i.ytimg.com/vi/TqBYfMxVTc4/mqdefault.jpg)
Grab the file I used in the video from here 👉 pages.xelplus.com/progress-circle-chart-file
I could live a thousand life times and I never would have come up with Sam's solution. I'll never use this method but it's cool knowing it exists. ;-)
It's always good to have something up your sleeve just in case :)
Agree. My poor brain was hurting
😂😂😂. I was thinking the same too
Yes, the great uncle Sam.. :)) very informative, not sure why I spent more than 10 minutes of my life on this and I'm still smiling (maybe thinking of how creative people can be)
That's impressive use of cos and sin functions.
finally jeje
Hi Leila, I like yours for its simplicity and Sam’s for its aesthetic. In the end both are impactful to show progress. Thank you for sharing!
You are very welcome. Glad you like our little circle chart fun :)
Sine, Cosine? You mean there's actually a practical use for this????? I should have paid more attention in school.
That's exactly what I thought 🤭
Anywhere you see things are moving in a circle, you can use trigonometric functions to solve problems easily.
Lol
The world is full of circles.
Ha, really if they only had have told it me at school! They do not tell it us in all countries! 😄😄
Hi all,
I believe the 2nd solution is adding half a circle's area to the completed ring to both ends (so a full circle) which changes the visual proportions. Better would be if the whole of the circular disk was inside the completed ring, with the circumference tangent to it.
This may not be much of a problem if the completed percentage is high enough, but it does skew the visual info the graph is communicating.
Also, if the completed percentage is small, like 1% or even 5%, this will certainly give the wrong picture to the audience. It will start to become apparent.
In the case of small percentages, we risk the radious of the circle being to large to depict them. As such with this method we can show up to a certain minimum of completed percentage. I just saw this and i don't have the time to create and test it (02:50, here in the UK and i have to be in the office in 5 hours...) but if i had to guess i'd say it shows a full circular disk even at 0%.
A better way to implement something like this would be to have ellipses at the end of the ring, where the a,b parameters would be dynamically linked to the completion percentage, with possibly an upper bound, to avoid extremes.
The equation of an eclipse is (x^2/a^2) + (y^2/b^2) = r^2.
a,b and r are given in squares for symmetry.
For a=b we get a circle (the above equation becomes x^2 + y^2 = r^2*a^2 (or *b^2), which is basicaly x^2 + y^2 = R^2 (just a new r, as a,b are parameters).
Can you please check what happens for 0% or 1% ?
I feel the first solution is correct.
It would have been nice to see the results of both methods at 99%, 98%, ..., etc. And then see at which % point does each method not have overlapping pixels.
I agree, but given the series are provided through a calculation i feel like we can simply subtract the radius of the scatter plot markers to account for the difference.
1 important thing though will be that one needs to add the removed radius back to the doughnut when the input value = 100%
Otherwise my solution will give you a slight area where the grey is still showing although the percentage is 100%.
I'll be using my adaptation of Sams solution here. Great work, thanks for sharing both! :)
Beautiful Charts, Leila!!! Thanks, Teammate!
Thank you Teammate Mike!
I didnt understand the sin & cos function, but one thing I know is that I used this method of creating the doughnut chart at my work, and this changed my life.
Thank you Leila.
Hi Leila,
Is there a more elegant/simpler way of doing Part II now that we are four years later?
The first method gets the job done; the second method is simply brilliant!
That was amazing both solutions, and sam's was simply...brilliant
Kudos to Sam! I must humbly admit I would not have come up with this solution. But then again, I can't think of a situation where I would go through the trouble of making round edges!
Sam's is really a genius solution :)
Hi Leila, I think I'm writing a bit late and other people might already have picked up on the issues with the second version.
1) the markers and the textbox don't resize automatically . So, don't bother to size the circle until the very end.
2) the formula calculating x and y are not stable either. They are affected by the size of the circle diameter. I extended the axis from -1.15/1.15 to -1.25/1.25 to have more leeway and then adjsted the circle to centre the markers. Perhaps, an expert mathematician could provide a dynamic formula?
However, it's a very cool trick 😄 Looking forward to seeing you at the next Excel gathering in January.
Microsoft developers should see this!
Yes it will be much more convenient than going through all this
I would never think of using sin and cos functions. This is great. Thank you for sharing!!!!!
Same here. Sam's version is genius!
Just wanted to let you know this post is amazing, and your library of topics makes you a genius in my non-mathematical mind :) And I echo many of the appreciative comments made below. Thanks much for your efforts!
This tutorial really helps me very much, I've learned new ideas and knowledge by following the lesson. thank you.
You're very welcome!
Sam's nice tweak solution is to
- Add Start and End points as Filled Circles at a calculate points (Simple Trigonometry)
- Fix the graph so the circles are plotted at expected points
- Define the scale of each axis
Personally i prefer the simpler solution but i am fascinated with the math.
Me too. I would've never been able to come up with such a solution.
Your videos are always creative and innovative ☺👍
using the PI function is genius!
The second method got me thinking, I really wanted to understand the mathematical concept behind it. So, I created a video and uploaded it on my channel explaining that, the method I used is slightly different than the one explained here, but it has the same output. I would really appreciate your feedback on that if possible.
By the way, I’m a big fan of your content, I have been watching your videos since a very very long time, I learned a lot from you and now I’m teaching Excel online and offline. So Thanks again for your great content and effort.
All the best to come!!
What an elegant solution!!
Glad you like it!
We are very much grateful Leila. God richly bless you
Wow you are taking excel to different level
Simply awesome. This adds flavor to visualizations in Excel like an infographic. 🤓
I LOVE EXCEL. BUT AS I STARTED TO ATTEND THESE LECTURES. I REALLY EXPERIENCED A DIFFERENT AND NEW KNOWLEDGE BASE ASPECTS OF EXCEL.
I AM THANKFUL TO MAM LEILA GHRANI
Tu es très fortes et éloquente dans la communication, Merci beaucoup
Now I understand why did we need to learn the sin, cos and tan functions in schools. So that one day we will stumble upon this video in this amazing channel.
😊
nice tutorial. good job. thanks
Happy teachers day Leila. You are my favorite teacher. Video is excellent. I like Sams version.
Thank you! Sam's version is genius.
Beautiful Leila. Great charts too!
Your version is just fine for most of the cases!! 👍 Thx a lot!!!
Omg.. this is so crazy… 😨😨😨😨😨 didn’t know such complexity behind it
Thank you so much ... I'm using it now in my project status report
Hi Leila
All your video are remarkably nice and worth trying .
Thanks a lot.
I'm happy to hear that.
Version 1 is just cool. Thanks Leila
How long has Excel been around? I'd have thought they would built this in by now as a line style or something.
for real. While this solution is brilliant it is more aptly an example of how horrendously behind Microsoft is in employing such a simple shape feature to their doughnut chart. This should be a one click solution for 'rounded edges' in the chart format page.
They're both excellent
I love 😍 excel because of you, your work is incredible thank you so much
Really great solutions, both of them. Nevertheless , in order to become a little bit unpopular, Sam's one, to my opinion is not mathematically correct: As the center of the circles are put on the edges of the non-circle version, the resulting semi-circles reach into the area of the (1 - progress) part, such making the progress part optically larger than it really is ;-).
Wow!!! I love an aesthetically pleasing spreadsheet and I love technicality driving this but I could never see myself putting all this work into a progress donut. It's still very cool and I love when ideas are turned into challenges and then turned into solutions. THIS is a great example of obfuscation or as I like to say, there is complexity behind the simplicity.
Haha, maybe we went a bit overboard. But it was a fun challenge :)
It all depends on how many times one plans to reuse it.
Thanks for your hard work to bring for us a very useful functions , really it help us to create professional reports & dashboards
Thank you. Your videos are always awesome and great help for me
Both versions are very creative - nice!!
Second one is amazing...too good and professional version. Bang on
Well done, as always Leila. Keep 'em coming!
I'll try my best :)
Taking the edge off ! Mind blown
Sam is the clear Winner here :) Loved both versions, though complex the Sams' is better, Thanks for Sharing Leila
Agreed, Sam's version is amazing :)
That’s very cool! I’ve recently been using a donut chart and pie chart on different axis for velocity of improvement, but this does look really cool, I’m going to give it a go today!
That's great. Let us know how it went.
Leila You are great !
amazing Leila, thank you very much, both ideas are great
Hi Leila! Brilliant as usual and kudos to Sam for the wonderful idea.
I will use it in my reports and presentations. Looking forward to meeting you in Slovenia Excel Olympics! I hope I will get few mins of talk time with you. I am all set for Slovenia trip from Dubai.
Take Care!
That's great! Looking forward to seeing you there.
@@LeilaGharani Thank you and I am very eager to meet you! I hope you will note my name :)
You are great Leila!
really cool. smart job Sam!
Sam's was sick! I almost spit out the water I am drinking when I saw the rounded edges after the setup! Sin/cos!!!! Ftw!
😂
Crazy idea. Thanks a lot 👍
Most welcome 😊
Thank you for making me look smart!
😁
Your excel tutorials are my go to when I am stuck up. Thank you so much for guiding me in my quest for better excel knowledge. I already have taken up your VBA course in udemy. :) Once again Thank you so much.
That's great to hear! Thank you for your support.
great video
thanks a lot Leila, i am really improve my experience with your videos
Thanks Leila "excel QUEEN"
I'm glad to hear that :)
Great work
Awesome stuff, Leila. I'll try your method. Immediately thought that it can be used for Dashboards or to visualize metrics.
Is it possible to have the color be dynamic? I mean, let's say if the number is below 70%, The progress bar would be Red. And then if greater than or equal to 70% but less than 90%, it would be Yellow or Amber. If greater than of equal to 90%, it would be Green.
Would conditional formatting solve this question?
my favourite solution is yours 🙂
Hello @
Leila Gharani. I am so grateful for your tutorials. Thank you so much for sharing your Excel wisdom with us. I've followed your instructions very carefully to get the same results. I am very close but it seems that my the Sin/Cos points are slightly off - looks like they are off by one/two pixels. I've tried to adjust the graph's size but I can't find a size where the end points (in Sam's example) are totally aligned with the rest of the progress bar. Do you have any suggestions? Thx!
Hats off to SAM !!!
So true!
Hi Leila.. great video and techniques! I like both.. yours for the relative simplicity of setup.. and it looks great, even though not perfectly rounded at the caps.. and Sam's because of the clever way he designed the solution using trigonometry and the perfectly rounded caps are certainly visually appealing.. no denying that fact. The analyst in me wants to understand all the math behind Sam's version, but I'd probably go to your version first to get work out the door since it is easier and quicker to set up and maintain. Thanks for showing both approaches. Always something new and interesting coming from you and your channel. Thumbs up!!
PS - On your version, if you make the point width of the remainder the same as the percentage complete.. say 14 point each.. it looks pretty good too. The color differential makes the percentage complete stand out pretty well, as is. As you said.. either or.. depending on personal preference :))
Thank you Wayne for your feedback. When I saw Sam’s version I was so impressed :)
@Alex Ooi Hi Alex.. thanks for your feedback. Been fooling around with this a bit.. re-learning my high school trig which was about 100 years ago.. haha!! Now I remember how to plot points on a circle, convert degrees to radians for cartesian coordinates, use SIN(), COS() and RADIANS() functions in EXCEL. All good learning. I like Leila's method for the clever but simple setup.. can crank that one out quickly and it looks good. I like Sam's method for the cool use of trig and clever plotting of the points at the stationary and leading edges of the variable doughnut part.. but.. it takes a little longer to set up and getting it perfect can take some trial and error. Both great methods.. all good stuff to learn and exercise the brain cells. Thumbs up!!
This was so helpful! I did everything step by step, everything is working as great, but every time a value changes in my spreadsheet, there's always a 'Excel found a problem with one or more formulas in the worksheet..' message. I re-entered the values and formula but am still getting the message. Will keep working on it. Otherwise everything has been working great. It's just the message that keeps popping up
Madam your explain is awesome please we want more about FUNCTION
Thank you!
Great video and explanation!
The trouble with rounded edges is the ambiguity as to where to read them - at the farthest point, the middle, or somewhere else. It is less impt here but still imprecise for the "reader" if he/she/they don't know how you programmed it.
Very elegant chart :-), thank you for this Leila.
My pleasure Nico. Glad you like it.
Thank you for the video, and to Sam for the solution V2, it's really impressed.
Our pleasure :)
Eu concordo. Parabens Sam - magical !
You are my teacher
Amazing.
I was searching something like this.
Thank you leila.
Glad you found something here. Hope it helps.
Simply genius
nothing to say ..... you are the best i mean it
To you have a session on how to create a progress pie to populate in a 2nd excel sheet once information is enter from the 1st sheet
Good work Sam, that's the good one👌
Thank You so Much Beautiful Leila...
FAVORITE EXCEL VIDEO! THANKS
Glad you like it Damian.
Just found your channel. Very useful.
This is so great. Thank you. I'm having a problem with the donut chart. When I follow the same steps, I get the blue color showing with the edges underneath the grey instead of on top of them. Anyone have any idea on how to fix this?
This is Mohamed Basith with u..
Mrs. Leila I tried both your and Sam's model of making the charts....
Your model is quite easier and reliable for wide range of percentage changes.... ( I have one correction for your method - For fill option solid line and color changing and you change the grey dougnut thickness as 7 & blue as 13. But during my try i use the blue color as 13 as per your advise and i try to adopt the grey color will almost equal to the thickness of the blue so i use thickness 10 for grey it looks pretty much same as sam's chart.)
However, sam's method is quite intresting while looking the video but it will not be practical for the diverse users sheets...(which means sam's -1.15 & 1.15 axis range will no more applicable for all the excel sheets. hence it will applicable only for sam's excel sheet) rest is fine.
Hope anticipate many useful videos like these session to enhance the power and efficiency of the excel software...
Thank you both....
Hi Mam, I want cell update in invoice automatically, cell value were enter update on another dataset or sheet by added new row.
Wow! Sam's option is a super hardcore! I'm gonna try that at my file at work!
It sure is Mark. Let us know how it went.
Also supper effective, Sam passes thru walls with ease. Thank you for the video also Leila
Great. but there is a little missing. That is when you explain the point number one (x of 0, and y of 1) you point the zero on the bottom of the circle but actually it is on the center of circle. I think it goanna be helping for us to understand next the formula which calculating the coordinates of the point number two.
Legendary stuff, will go with Sam's option
Thank you Leila for sharing such a useful tips. It helps to work for efficiently without compromising the presentation style of the chart. However, I noticed that I have 1 issue, the text box that inserted into the doughnut chart and also the end point marker size doesn't seem to lock to the chart ratio. If we enlarge the chart, we have to manually adjust them. Is there anyway we can automate this task?
Damn Sam…. Brilliant!
Very Nice
Very interesting.
Awesome technic,
Amazing! thank you very much.
Hey, this is in no way related to the video, and maybe it's a bit too specific of a topic that may not interest a lot of your viewers, but I have an Excel that has a custom SQL that references an external Oracle SQL. I would like to have the SQL reference a pair of cells within the excel so I can have the users enter date & time values and have that serve as variables in the SQL. I don't think I've seen anything like this on your page so I doubt that it'll be something you would cover but I figured it would be worth asking. Thanks for the videos!
You can do this using parameters in your connection window and question marks in your SQL query. Should be plenty of videos around showing how to do it.
Wow... nothing wrong with using math in life but just to get a simple chart with rounded edges there has to be an easier way! I'd go with Leila's method and be satisfied that it's round enough lol, but honestly bravo for integrating sin/cos and pi into a chart!
Haha, yes it's taking it to another level.
Wow it’s great video. Thank you very much.
Great example!!!
Thanks s lot and love you mam
So helpful. Thank you.
Awesome