I've been looking for this same answer for months. I had attempted to try something very similar, having a separate line chart and overlaying it, but couldn't work out how. Thanks so much - it's only a tiny thing for my own little business, but makes me feel a little more professional
Espectacular, you saved my day. I was trying with intermediate tables.. but I was losing all the dynamic look and feel obtained from a Pivot Chart. Thanks a lot! Muchísimas gracias!
Hey Eric, this is great, simple and easy, here is my next challenge for you, this does not work if I go from months to quarters, to get a more aggregated view right? the line does not get adjusted ... do you have any suggestion ? - thank you VERY MUCH !!!
I know! That's why I made the video, couldn't believe there wasn't a better way that was already on the internet, but, many a Googles later, I never found one.
Hi Eric, thank you so much for this great video. I learned a lot from your video. But i do have a question, when i change my Slicer to get selected data, the Axes range line and bar graph not syncing like you did in the video. Can you help advise on this issue? Do i need to change the minimum and maximum every time i changed my slicer for selected data i want?
Thanks for sharing this cool technique! Got another question about the data labels for the stacked bars. For your stacked bars there would be too many data labels displayed if you turned on data labels, which is going to be uneasy to read Is it possible to only show the data labels for like…top5 value for each stacked bars for each day? Been searching for workaround but found nothing…… Thanks in advance
This is awesome Eric! I have been trying to display total onto stacked dynamic bar charts with no success until now. I was wondering if you know how I can link the two pivot tables so that i can expand or collapse the period for the values? I would like to be able to drill down from Months to weeks to days which i used to be able to do by using the expand & collapse field buttons but they only drive one chart and i can't work out how to link them. Any ideas?
I had wondered the same thing a number of times but never needed it bad enough to research or invent a solution. One good trick is that you can create timelines and slicers and connect multiple pivot charts to the same timelines and slicers. But that doesn't solve the problem exactly and I'm not quite sure how to have them both expand and collapse. I bet there's a way to write a macro to achieve that but that would take some doing.
Hi Eric, thanks for this tutorial! Awesome! However, when I applied this technique, axis range of line bar is not syncing the same with axis range from the column chart. Can you help me?
By grandtotal line doesn't respond to the timeline, it doesn't change dynamically if I change the timeline . My time line is connected to all the pivitos ,can someone help please.
Very underrated Video! I've been searching for hours! Thank you so much Eric.
This is a very clever approach to the issue, I was looking for a solution online and this helped me out. Thank you!
Aside from learning how to add a Grand Total Line I also learned a lot of new things. Thanks a lot.
You're welcome!
This is an example on how to solve difficult problems with a simple and smart solution. thanks for sharing
This is very helpful! I've been searching for an hour to find a way to add the grand total to my pivot stack graph. Thank You!
I've been looking for this same answer for months. I had attempted to try something very similar, having a separate line chart and overlaying it, but couldn't work out how.
Thanks so much - it's only a tiny thing for my own little business, but makes me feel a little more professional
thank you so much!
Your video was incredibly helpful as I attempted to build my first dashboard. Thank you!
You're welcome!
Espectacular, you saved my day. I was trying with intermediate tables.. but I was losing all the dynamic look and feel obtained from a Pivot Chart. Thanks a lot! Muchísimas gracias!
Amazing! Thank you
Excellent video!
great, thank you so much!
Very helpful hack. Thanks, Eric!
Very grateful for this. Thank you Eric! Thumbs up big time!
Very smart!
Thank you so much! Loved doing this!
great ! been looking for ages !
You're a genius, Bro! Thanks a lot!!
Haha thanks! Glad it helped.
Very simple and elegant solution.
Yes!!! I have been searching for weeks! And its comprehensive
Super helpful! Thank you!!!
this is really useful... cool stuff
Innovative solution. Well done
Amazing video, very helpful!!
Fantastic work around. Thanks Eric
You're welcome! Glad it works for you.
Very helpful.😄👍
BRILLIANT!!!
Hey Eric, this is great, simple and easy, here is my next challenge for you, this does not work if I go from months to quarters, to get a more aggregated view right? the line does not get adjusted ... do you have any suggestion ? - thank you VERY MUCH !!!
Well done! This was very helpful.
Thanks for posting, great solution.
I started to do this, then googled for an answer that wasn't so daft (there must be a smarter way to do this), and here we are...
I know! That's why I made the video, couldn't believe there wasn't a better way that was already on the internet, but, many a Googles later, I never found one.
Superb workaround! thank you!
It´s helps a lot Thank for this video Eric.
Glad you liked it Ryan!
Thanks a lot great ....
Thank you very much. It is really useful for me.
You're welcome Anh! Glad it helped.
Great job Eric. Obrigado!!
thalerson augusto mortari de nada!
Hi Eric, thank you so much for this great video. I learned a lot from your video.
But i do have a question, when i change my Slicer to get selected data, the Axes range line and bar graph not syncing like you did in the video. Can you help advise on this issue?
Do i need to change the minimum and maximum every time i changed my slicer for selected data i want?
Thanks for sharing this cool technique!
Got another question about the data labels for the stacked bars.
For your stacked bars there would be too many data labels displayed if you turned on data labels, which is going to be uneasy to read
Is it possible to only show the data labels for like…top5 value for each stacked bars for each day?
Been searching for workaround but found nothing……
Thanks in advance
Very Impressive! I'm very curious how you extracted data in that format from QBO if you wouldn't mind sharing
Happy to share. Contact me via PlotPath.com and I'll get back to you.
This is awesome Eric! I have been trying to display total onto stacked dynamic bar charts with no success until now.
I was wondering if you know how I can link the two pivot tables so that i can expand or collapse the period for the values? I would like to be able to drill down from Months to weeks to days which i used to be able to do by using the expand & collapse field buttons but they only drive one chart and i can't work out how to link them. Any ideas?
I had wondered the same thing a number of times but never needed it bad enough to research or invent a solution. One good trick is that you can create timelines and slicers and connect multiple pivot charts to the same timelines and slicers. But that doesn't solve the problem exactly and I'm not quite sure how to have them both expand and collapse. I bet there's a way to write a macro to achieve that but that would take some doing.
Hi Eric, thanks for this tutorial! Awesome! However, when I applied this technique, axis range of line bar is not syncing the same with axis range from the column chart. Can you help me?
Hi Rose Anne, the trick there is to edit the axis minimums and maximums on each graph. Change them from "auto" and make them the same for each graph.
@@eweynand I finally made it. God bless you and your generosity!
By grandtotal line doesn't respond to the timeline, it doesn't change dynamically if I change the timeline . My time line is connected to all the pivitos ,can someone help please.
You can send me your file and I'll try