Selecting data for charts by criteria

Tim -

If it's an external database, I guess you'd rerun your query to capture
new data, and your query would filter the data.

If it's an Excel database, use dynamic range names to make dynamic
charts (http://www.geocities.com/jonpeltier/.../Dynamics.html),
and use an Autofilter in the worksheet to show only the desired data.
Charts by default only plot visible cells. Hold the Shift key and click
on the chart to select the chart object, then press Ctrl-1 (numeral one)
to format it. On the Properties tab, select Move but don't size with
cells, or else the chart will change size as you hide and show rows.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

tja26 wrote:

Hi there,

I am in control of a large database of information and I want to be
able to automatically make my charts update to include new data that is
added. I am using a regular excel spreadsheet. I would also like to
be able to select which data is used for a chart depending on a
criteria such as, 0 = value = 10.

Any help is appreciated.

Thanks

Tim Archer



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Sharon -

I suggested the filter so the charted data would change when the filter
changed. Excel does this by default. To change it, select the chart,
select Options from the Tools menu, click on the Chart tab, and uncheck
the Plot Visible Cells Only box.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

sharon wrote:
Jon,

I did exactly what you said about changing the properties of the chart
and it didn't work. As I hide and show rows using the filter the data
changes on the chart. How can I stop the chart from changing?

Sharon



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/