Excel 2007 does not take more than 255 datapoints

[adamsk]

I have this dataseries with all the weeks for the last 6 years which comes up to 312 week datapoints.

Unfortunately, when I want to chart a graph it only takes 255 points.
How can I get Excel 2007 to take more points in the line chart?

Thanks

 

[David Biddulph]

You should be able to have 32000 points in a data series in 2007 (as for
2003)

From
http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033#Charting:

"Data series in one chart 255
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"
--
David Biddulph

I have this dataseries with all the weeks for the last 6 years which comes
up to 312 week datapoints.

Unfortunately, when I want to chart a graph it only takes 255 points.
How can I get Excel 2007 to take more points in the line chart?

Thanks

 

[Jon Peltier]

Have you perhaps made a chart with 255 one-point series? That is probably
the limit you are encountering.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


I have this dataseries with all the weeks for the last 6 years which comes
up to 312 week datapoints.

Unfortunately, when I want to chart a graph it only takes 255 points.
How can I get Excel 2007 to take more points in the line chart?

Thanks