Hello, I have around 400k rows for which I am creating a Pivot Table that includes two Columns
Time Value
There are 400k+ rows of these
When i go to create a Chart, 'Clustered Column', it only displays for 55k+ rows. Any idea How i can get to display all 400k rows?
Assuming your profile is correct and you are using Excel 2003, older versions of Excel had much lower limits in the number of data points they could show in a chart. My version (2007) is limited to 32k points per data series up to a total of 256k points per chart. I believe 2003 has similar limitations. The only way to get it to show all 400k points will be to upgrade to a newer version of Excel or find a 3rd party charting app that is not limited as much as Excel 2003.
Originally Posted by shg
Another possible option - if your data is date related, use monthly averages. Otherwise find some way to consolidate your data...no way will 400k data points be of any use in any visual representation.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks