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

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
 
G

Guest

I have just asked a very similar question, I will monitor
your answers also.

bobf
 
A

Andy Pope

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
 
Top