Excel Bar Chart with Vertical Line - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 6
Bart
Thank you Lynda. Very interesting video. I must say I had some difficulties understanding the figures (and that's in the end the objective of a graph is not it?). I this case, in order to compare the % spending within a group I would just go for the stacked collumn graph. Since the total number of customers and their budget is different per group, it is dangerous to calculate an average percentage. For example in the first graph (actually the table), it assumes that the average proportion of the expenditures is 16%. But since the groups are different this is not the case. Keep the good work!! Greetings, Bart
reply
Thank you Lynda. Very interesting video. I must say I had some difficulties understanding the figures (and that's in the end the objective of a graph is not it?). I this case, in order to compare the % spending within a group I would just go for the stacked collumn graph. Since the total number of customers and their budget is different per group, it is dangerous to calculate an average percentage. For example in the first graph (actually the table), it assumes that the average proportion of the expenditures is 16%. But since the groups are different this is not the case. Keep the good work!! Greetings, Bart
reply
Wayne
Hi Mynda.. what a great trick.. very clever use of Trendline. My first thought was to use Error Bars to draw the line, but of course they would be horizontal in this case.. didn't think of a Trendline.. excellent! Thanks also for providing the sample workbook download. They are super useful to follow along and reinforce the concept. Thanks again for all the great resources offered by MOTH.. very much appreciated. Thumbs up!
reply
Hi Mynda.. what a great trick.. very clever use of Trendline. My first thought was to use Error Bars to draw the line, but of course they would be horizontal in this case.. didn't think of a Trendline.. excellent! Thanks also for providing the sample workbook download. They are super useful to follow along and reinforce the concept. Thanks again for all the great resources offered by MOTH.. very much appreciated. Thumbs up!
reply
itech
Thank you for the video Mynda. I tried it on my own before watching the video, and tried using the error bar the vertical line. Couldn't figure it out, but using your trendline idea was very easy. Thank you for sharing.
reply
Thank you for the video Mynda. I tried it on my own before watching the video, and tried using the error bar the vertical line. Couldn't figure it out, but using your trendline idea was very easy. Thank you for sharing.
reply
Juan
What a great tutorial, Mynda, congratulations, you always push the boundaries of Excel capabilities! The video is very useful to understand visually all the steps. Thank you very much, your tutorials are awesome!! :)
reply
What a great tutorial, Mynda, congratulations, you always push the boundaries of Excel capabilities! The video is very useful to understand visually all the steps. Thank you very much, your tutorials are awesome!! :)
reply
Douglas
Nice video! Question: after you created the very first chart, could you then set that first chart as a custom chart template and then set each additional chart to that template style?
reply
Nice video! Question: after you created the very first chart, could you then set that first chart as a custom chart template and then set each additional chart to that template style?
reply
Klaus
such a good presentation and - for English non- native listeners so hard to follow. If you would stop for 2 seconds after each phrase, and speak a bit slower, that would work ...
reply
such a good presentation and - for English non- native listeners so hard to follow. If you would stop for 2 seconds after each phrase, and speak a bit slower, that would work ...
reply
Add a review, comment
Other channel videos
9:58
20:34
17:2