Change Chart data based on column selected

[Dave69rock]

Hi
I have a data table with lots of column headers
Is it possible to have just one Chart to display my percentage results just for the column i've selected.

Please see the the attached sheet

I don't want to have 30+ charts if i can just change the name in a cell and have one chart.

Dave

[teylyn]

Hi, can you please post a smaller work book? I'm on a data plan and will not open big files.

Without looking at your spreadsheet, you should look at using a range name for the series you want to chart and have the range defined dynamically.

Check out Jon Peltier's pages about dynamic charts to get some more ideas.

http://peltiertech.com/Excel/Charts/Dynamics.html

HTH

[Dave69rock]

hi

Please find attached

Dave

[teylyn]

How about this?

All explanations are in the file ...

[Dave69rock]

Hi

This is fantastic just what i'm looking for

Many thanks

Dave