Charting more than 255 bits of data

[Guest]

Is there a way to chart more than 255 bits of data; which is Excel's limit?
If yes, is there a limit to that amount of data?

Thanks.

 

[Jon Peltier]

That's the limit to the number of series in a chart. Each series can hold up
to 32000 points, subject to a maximum of 256000 points in the chart.

I suspect you have 255 series each with one point. Could you select the data
all at once and make a single series with 255 points?

- Jon

 

[Guest]

Thank you for your quick reply. I don't understand what you mean by series.
What I need to do is chart Sugar prices for a 10 year period and then show
when my clients prdictions were correct. Each year is 365 days/points.

Is there a way to do this?

Thanks

 

[Del Cotter]

Thank you for your quick reply. I don't understand what you mean by series.
What I need to do is chart Sugar prices for a 10 year period and then show
when my clients prdictions were correct. Each year is 365 days/points.

You are currently using the Chart Wizard to create your graph. When you
get to the bit where it says "Series in:" and offers you a choice of
"Rows" or "Columns", change the choice you are currently making, as it
is the wrong one.

 

[Jon Peltier]

A series is one or more points plotted together.

I guess you want to arrange your data into two columns: Date and Price.
Select the data and make a line or scatter chart.

- Jon

 

[Del Cotter]

Thank you for your quick reply. I don't understand what you mean by series.
What I need to do is chart Sugar prices for a 10 year period and then show
when my clients prdictions were correct. Each year is 365 days/points.

Are you trying to type your years into 10 rows of 365 columns each?
Because there are only 255 columns in versions of Excel earlier than
2007, and that's all you get.

Type your bits of information in 10 columns of 365 rows each instead.
There are 65,536 rows, so you won't run out.

 

[David Biddulph]

If you mean the number of series in one chart, 255 is your limit.
You can have 32000 points in one series, and 256000 points in one chart.

http://office.microsoft.com/en-us/excel/HP100738491033.aspx?pid=CH101030621033#Charting
for 2007
http://office.microsoft.com/en-us/excel/HP051992911033.aspx for 2003