How to make a chart with a big range of data?

  • Thread starter Thread starter Kroko
  • Start date Start date
K

Kroko

Hi
I'm trying to make a chart selecting the whole column as
data to plot on the chart. But it doesn't work .. I have
many rows with data (about 250) and it's going to be
more .. How do I make this chart only once, without
having to extend the chart source every time I add more
data?

Thanks a lot.
Kroko
 
Hi Kroko,

Selecting the whole column exceeds the limits of a chart.
From the help:
Data points in a data series for 2-D charts 32,000
Data points in a data series for 3-D charts 4,000
Data points for all data series in one chart 256,000

If your 250 rows is going to change then you need to use dynamic ranges
as the source of your chart.
Jon Peltier has a collection of examples,
http://peltiertech.com/Excel/Charts/Dynamics.html

As does Tushar Mehta,
http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

Cheers
Andy
 
Back
Top