Selecting data for charts by criteria

  • Thread starter Thread starter tja26
  • Start date Start date
T

tja26

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
 
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/Excel/Charts/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,

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
 
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
 
Back
Top