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.

On Fri, 4 Jan 2008, in microsoft.public.excel.charting,
PAL said:

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)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

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.


"Del Cotter" wrote:

On Fri, 4 Jan 2008, in microsoft.public.excel.charting,
PAL said:

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)

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.