how to Plot 62,000 data point in excel


Posted by Nguyen D.v on August 08, 2001 3:38 PM

I have tried to plot 62,000 data point (rows) range and Excel only plotted about 32,000 data point (rows). Any one knows how to get around to plot all 62,000 data points, please?

Posted by Mark W. on August 08, 2001 3:48 PM

If you check the Excel Help topic for "Charting
specifications" you'll see that the...

"Maximum number of data points in a data series
[is] 32,000 for 2-D charts [and] 4,000 for 3-D
charts"

Are you creating an XY (Scatter) chart?

Posted by AB on August 09, 2001 6:35 AM

Here I go again!

OK, I'll prequalify this comment with, "This is an unconventional and hacky approach."

But...

If you plot the first 32k on one chart and then plot the second 30k on a second chart you can overlay one chart on top of the other.

Some day I'll have to build that chart overlay addin that I keep theatening.

Good Luck!
AaronThe Excel Logic Page

Posted by Mark W. on August 09, 2001 6:54 AM

Re: Here I go again!

Yeah, I'd already thought of that one... That's
why I inquired if it was an X-Y chart. This
approach works best with X-Y.

: I have tried to plot 62,000 data point (rows) range and Excel only plotted about 32,000 data point (rows). Any one knows how to get around to plot all 62,000 data points, please?

Posted by Eric on August 09, 2001 7:01 AM

Two series in an X-Y format

Hi,
I'm not sure what kind of graph you are trying to make, so this may not be a workable solution for you. I took 62K data points and tried to graph them as an X-Y, sure enough same problem as you. So I split the 62K into two columns (31Ka and 31kb), and they both plotted, however they plotted over the same X range (the row #s). So Excel CAN plot that many points, just not in one series. So make two more columns, one for X values of 31Ka (31Kax), and one for X values of 31Kb (31Kbx). 31Kax should have the same values as the row numbers and 31Kbx should have the same values as the row numbers PLUS the value of the last cell in 31Kax. Then select only 31Ka and 31Kax, start the graph wizard, tell it to do an X-Y, hit "next", hit the "series" tab, hit "add series" and select 31Kb for "y values" and 31kbx for "x values". This should give you contiguous plotting of the two series. You can go in and custom format colors etc to make them look more similar.
Hope this helps

Posted by AB on August 09, 2001 7:04 AM

Re: Two series in an X-Y format

Good idea!The Excel Logic Page: Hi, I'm not sure what kind of graph you are trying to make, so this may not be a workable solution for you. I took 62K data points and tried to graph them as an X-Y, sure enough same problem as you. So I split the 62K into two columns (31Ka and 31kb), and they both plotted, however they plotted over the same X range (the row #s). So Excel CAN plot that many points, just not in one series. So make two more columns, one for X values of 31Ka (31Kax), and one for X values of 31Kb (31Kbx). 31Kax should have the same values as the row numbers and 31Kbx should have the same values as the row numbers PLUS the value of the last cell in 31Kax. Then select only 31Ka and 31Kax, start the graph wizard, tell it to do an X-Y, hit "next", hit the "series" tab, hit "add series" and select 31Kb for "y values" and 31kbx for "x values". This should give you contiguous plotting of the two series. You can go in and custom format colors etc to make them look more similar. Hope this helps : I have tried to plot 62,000 data point (rows) range and Excel only plotted about 32,000 data point (rows). Any one knows how to get around to plot all 62,000 data points, please?



Posted by Mark W. on August 09, 2001 7:06 AM

Ditto!