Only Label Specific Dates in Excel Chart Axis - Reduce clutter and look more professional! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Jim
Thanks for the shout-out, Mynda. Truth be told, it's not really my idea, but the application of clever techniques you've taught to realize greater functionality from Excel. I doubt that I would have conceived of the idea of using labels on invisible data points as proxies for axis labels. That's all you! Another great tutorial: a quality production that is perfectly paced, expertly explained, & illustrated well. Thanks!
reply
Thanks for the shout-out, Mynda. Truth be told, it's not really my idea, but the application of clever techniques you've taught to realize greater functionality from Excel. I doubt that I would have conceived of the idea of using labels on invisible data points as proxies for axis labels. That's all you! Another great tutorial: a quality production that is perfectly paced, expertly explained, & illustrated well. Thanks!
reply
itech
I realize I don't know enough about charting, because I would choose the wrong chart. For example I would pick the line chart, which I think is used to show trends over time. Both line and scatter seemed to have the option to link values to cells, to get label specific dates, or am I wrong? Either way, thank you for the video. I love the resources you provide and I am learning a lot from you.
reply
I realize I don't know enough about charting, because I would choose the wrong chart. For example I would pick the line chart, which I think is used to show trends over time. Both line and scatter seemed to have the option to link values to cells, to get label specific dates, or am I wrong? Either way, thank you for the video. I love the resources you provide and I am learning a lot from you.
reply
Women
Thanks this was super helpful. I didn't know that you could change the numbers in the vertical axis to match the dates..... can't tell you how much time I have spent puttering around with this :) Well, now I know.
reply
Thanks this was super helpful. I didn't know that you could change the numbers in the vertical axis to match the dates..... can't tell you how much time I have spent puttering around with this :) Well, now I know.
reply
Wayne
Hi Mynda.. great technique there. Seeing you implement it makes me think of many other possibilities using the same logic. Thanks for sharing this great tip (and thanks Jim Fitch also). Thumbs up!!
reply
Hi Mynda.. great technique there. Seeing you implement it makes me think of many other possibilities using the same logic. Thanks for sharing this great tip (and thanks Jim Fitch also). Thumbs up!!
reply
Jalindar
I have problem to connect timeline to two pivot chart or graph.after connect of timeline to graph one graph working fine but second take multiple dat.Please help it is much need to me .
reply
I have problem to connect timeline to two pivot chart or graph.after connect of timeline to graph one graph working fine but second take multiple dat.Please help it is much need to me .
reply
Faysal
thanks for sharing your amazing trick. it's so much helpful. many thinks you are sharing which at least I don't have any idea. learning many new things from your videos. thanks again.
reply
thanks for sharing your amazing trick. it's so much helpful. many thinks you are sharing which at least I don't have any idea. learning many new things from your videos. thanks again.
reply
darryl
Hi Mynda!Great Tutorial, Didn't Realise You Could Type A Normal Date Instead Of The Serial Number In The Axis Options For Scatter Charts...Thank You :)
reply
Hi Mynda!Great Tutorial, Didn't Realise You Could Type A Normal Date Instead Of The Serial Number In The Axis Options For Scatter Charts...Thank You :)
reply
Hans
Great solution, I have been struggling to get something similar done but never got it working, thanks for sharing and showing how it's done. Thanks Mynda
reply
Great solution, I have been struggling to get something similar done but never got it working, thanks for sharing and showing how it's done. Thanks Mynda
reply
Rachyl
This worked perfectly for me...except when I tried to change the minimum value on my vertical axis, the date labels disappeared. Any ideas why??
reply
This worked perfectly for me...except when I tried to change the minimum value on my vertical axis, the date labels disappeared. Any ideas why??
reply
craig
So there needs to be a lower bound observation? Do you know how to just make it to where the last date on horizontal time series is what I want?
reply
So there needs to be a lower bound observation? Do you know how to just make it to where the last date on horizontal time series is what I want?
reply
Add a review, comment
Other channel videos
