Hello All,
I have 221442 rows of data in excel spreadsheet but I cannot create a graph. Excel pops up a message that the maximum number of data points you can use in a data series for a 2-D chart is 32,000. But I want to visualize the all data points on same graph. Is there a way to plot the large number of data sets ?
Thank you.
Hi,
Unfortunately, I haven't heard of a solution for this yet. what I tried once was to create multiple charts with data sets with limit of 32K, and then use the same scale parameters for Y axis for all of them and try to join them. You'll endup in problems if the last data set for the the previous chart is significantly different that that of the first data row in the following chart. The lines wouldn't connect nicely.
I cannot find that data set so I cannot try this method, but maybe you could:
From MR EXCEL
Ron
Knowledge is knowing that a tomato and pepper are fruits. Wisdom is knowing whether to put these in a fruit salad
Kindly
[1] Use code tags. Place "[code]" before the first line of code and "[/code"]" after the last line of code. Exclude quotation marks
[2] Mark your post [SOLVED] if it has been answered satisfactorily by editing your original post in advanced mode.
[3] Thank (using the little scale) those that provided useful help; its nice and its very well appreciated
Thank you ron2k_1. I will try this method and will give u update.
Hi,
Perhaps an upgrade to 2010 Excel? See http://peltiertech.com/WordPress/cha...in-excel-2010/
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
If you are plotting a xy-scatter you can use 2 data series.
But I don't see how you can find that many points useful.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks