Charting Data over 256 Columns

[Guest]

How can I chart data consisting of over 500 columns into one chart line,
since Excel's limit per worksheet is 256 columns? I put the data into two
worksheets. But when I select nonadjacent cells for data range input into
the Chart Wizard, I get two chart lines for the data, one on top of the
other, instead of one continuous chart line for all the data.

 

[Jon Peltier]

Many charting difficulties can be alleviated by more thoughtful arrangement
of the data. Put the data into columns instead of rows, and you'll be able
to get 32000 points per series.

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