Hi Alan.. great chart trick.. love the use of multi data series to get different effects like this. Your explanation was clear and concise. I was able to build my own version immediately after viewing the tutorial. Thanks and Thumbs up!
Hi Alan, Do you have a Basic Chart and Graph tutorial? I have never done one before and need to know it for my Business Course I am doing online. I only ask because you explain things so well.
Hi Tracey, I have one on creating Radar charts and one on a Step chart. I don't have videos on the basics of common charts such as column, line and pie though. I have lessons for these on my Ultimate Excel course - Beginner to Expert.
WARNING: The gap width does not work when you have a date column (say, you're taking daily/weekly/monthly measures) where the values are entered as a date (e.g. 3/10/2023 or whatever your date format is)...then the gap width=0 setting in the series no longer "floods the area"; as a result you don't get a solid range bar across (only separated bars with gaps)...I think it should be considered a bug in Excel unless someone has a good reason why date differerence should forcibly cause a gap between bars. If you want a workaround, change the date values to a different format or label them as text. Hope it helps.
Hey, Wondering if anyone can help me : How do I change the order of the X axis. My X axis has the values inverted. I want it to display left to right from cell 28 to cell 6 , but he is displaying from cell 6 to cell 28. How can I invert ?
I've been looking exactly for this. Thank you very much. I think this video is worth many likes🙃
Glad it was helpful!
Same with me. Thank you. ☺
Hi Alan.. great chart trick.. love the use of multi data series to get different effects like this. Your explanation was clear and concise. I was able to build my own version immediately after viewing the tutorial. Thanks and Thumbs up!
Thank you Wayne.
Thank you for the tutorial, it is clear and simple to understand and has been a big help! 👍
Great to hear. Thanks!
Thanks a lot sir this video was absolutely helpful, I had no idea how to apply a target range in my graph. Really appreciate it 👌👌👌👍👍👍👍
You're very welcome.
Simple, Short and clear. Thank you very much for the work presented. Really appreciate
You're welcome, Sepehr.
thank you so much this video was very helpful
Glad it was helpful! 😀
thank you so much. just what I was looking for.
Great! 👍
Another great idea, very well explained, thanks Alan
Thank you Glenn.
Thanks for well description :)
You're very welcome 👍
Awesome! It helped me a lot! Thanks!
Fantastic 👍 Thank you, Eduardo.
Thanks for sharing! Cool combo tricks! 🔥🔥
Thank you 😊 👍
Great video. Thank you
Thank you Jeromy.
Respect for you sir
Thanks to shearing this useful video
You're very welcome.
Hi Alan, Do you have a Basic Chart and Graph tutorial? I have never done one before and need to know it for my Business Course I am doing online. I only ask because you explain things so well.
Hi Tracey, I have one on creating Radar charts and one on a Step chart. I don't have videos on the basics of common charts such as column, line and pie though.
I have lessons for these on my Ultimate Excel course - Beginner to Expert.
Thank you Alan, l will check it out, l am so happy to have found your channel 🤗
Thank you Tracey. I hope you find what you need. You can contact me for help directly through the course also.
very useful....keep it up👍
Thank you 😊
It is useful!
Glad to hear that!
Bravo... thanks for sharing
You're welcome Haider.
Thank you for the tutorial, but i have a few ranges not one !
WARNING: The gap width does not work when you have a date column (say, you're taking daily/weekly/monthly measures) where the values are entered as a date (e.g. 3/10/2023 or whatever your date format is)...then the gap width=0 setting in the series no longer "floods the area"; as a result you don't get a solid range bar across (only separated bars with gaps)...I think it should be considered a bug in Excel unless someone has a good reason why date differerence should forcibly cause a gap between bars. If you want a workaround, change the date values to a different format or label them as text. Hope it helps.
Hey,
Wondering if anyone can help me :
How do I change the order of the X axis. My X axis has the values inverted.
I want it to display left to right from cell 28 to cell 6 , but he is displaying from cell 6 to cell 28. How can I invert ?
Double click the axis to open the options. In the Axis Options there is a check box to put the categories in reverse order
@@Computergaga Thank you very much for the help and the video.
No worries.
how to do the same in google sheets
Don't know. Probably very similar but don't use it enough.