Charting Data over 256 Columns

T

Tommy Z.

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.
 
J

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/
_______
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two columns followed by single page-width column on same page 0
Multiple columns over a chart 0
Bar Chart with Data Elements 1
simple chart 0
Chart SERIES OFFSET 5
Live data capture and charting speed 0
Two columns : Continuous two columns vs Parallel two Column 1
Creating a Search using a combo box and then creating a report. 4

Top