Creating Excel Panel Charts

Thanks! Share it with your friends!


The more I get into Excel Dashboards the more excited I get.  This is a great video that I hope will give you some ideas and techniques to present lots of data on a number of Excel Charts.  This video is a little longer than the ones I usually post but it is well worth 15 – 20 minutes of your time.

The video looks at a large table of sales data from a number of US states.  If you put all the states on a graph at the same time then there is no way you can see any trends or information for 50 lines at the same time.

The solution that this video shows is actually very simple but is has a number of steps.  First of all we make a smaller grid to show only 5 states.  Next we then fill this grid with a selection of the data in the main grid using VLOOKUP command.  Finally we make a number of charts and link them to each row on our smaller grid.  Then finally you can make a vertical scroll bar to change the data in the small grid – and is by magic the data in the smaller grid updates and so do the charts.  Neat.



duncan says:

I liked this video and am about to apply it to my own work. A question for you: when you prepared the charts you made all but one data set in each chart invisible rather than deleting them … I tend to delete in similar situations …

I hope that’s clear.

eric says:

I solved the problem, thanks.
The video is good for me, thanks for sharing.

Write a comment


Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.