View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Charting more than 255 bits of data

On Mon, 21 May 2007, in microsoft.public.excel.charting,
PVakerling said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.