Fourteen Charts in One

November 19th, 2004 | Categories: Charts | Tags:
-->

Adam Squire has posted a creative way of displaying fourteen different charts in one. It uses one chart object and a data validation dropdown list to change the data in the chart(you’ll need to download the workbook).

If you have ever found yourself with a ridiculous amount of charts in a workbook, this could possibly be a valuable example.

fourteeninone

Can't get the tutorial to work for you? Need help with your code?
Get answers right away at our AE Excel Support Forums!
Leave a comment | Trackback
  1. Jon Peltier
    November 19th, 2004 at 21:09
    Reply | Quote | #1

    Nice. I’ve used combo boxes from the Forms menu and from the Controls Toolbox to allow a user to select what they want in the chart. I never thought of Data Validation.

    Thanks for the link.

  2. ross
    November 25th, 2004 at 05:50
    Reply | Quote | #2

    me to, in a work book i have now there are about 40 charts reformed on the one chart sheet. U think i’m going to stop using the chart sheet, i cant see any advantage in it.