Charting Hidden / Grouped Columns

[simarui]

I have several years worth of monthly data that I would like to keep hidden so it is printer friendly but I also want to have a chart of all that data... Is this possible? Only idea I have is to basically recreate the data sheet but I don't really like that solution since it adds steps to the process and increases the file size...

thoughts?

[Andy Pope]

On the Select Data dialog is a button to for Hidden or Empty cells.

You can then change it so hidden cells are charted

[simarui]

brilliance... I love it when things are exactly as simple as they should be... though I kinda hate it when I spend several hours looking for them first lol.

Thanks!