Customizing charts for different stakeholders.

[PAL]

I have a worksheet with a lot of data on it (many rows and columns). I am
able to create charts with no problem. Is there a way to make a chart, that
allows you to select which data you would like to use in the chart, ie. a
specific row. Feedback is that users like the chart, but would like to break
the data up, essentially customizing for each stakeholder without creating a
new chart each time.

I am envisioning a Pivot Table like drop down list to select which data.

 

[Del Cotter]

I have a worksheet with a lot of data on it (many rows and columns). I am
able to create charts with no problem. Is there a way to make a chart, that
allows you to select which data you would like to use in the chart, ie. a
specific row. Feedback is that users like the chart, but would like to break
the data up, essentially customizing for each stakeholder without creating a
new chart each time.

I am envisioning a Pivot Table like drop down list to select which data.

Would this article help?

http://www.
juiceanalytics.com/writing/2007/05/why-make-100-charts-when-one-will-do/

(apologies if the URL line-wraps)

 

[PAL]

This is a great tip. If you have 3 graphs side by side, I wonder if there is
a way to have a single control bar moving all three?

Thanks again.