I'm using excel 2010 32 bit on win7 64bit.

I can't create pivot chart that exceeds the 65536 rows.

when creating a regular chart, there is no problem showing over 100,000 rows.

when looking at excel 2010 pivot chart limitation document, I can see that it's only limited by thesystem memory. in my case no more than 300MB where used by excel.

When I'm creating a pivot chart, excel only show "the number of rows I have (~100K) -65K" first rows.

please advise,

Regards,

David

You are right, excel will calculate/read the record with Ram, so hard wave is aslo a factor. 32bit software only could use 2GB ram, you'd better use 64bit Excel, it can use 64GB ram.

KR

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

Regards,

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

Hi,

I have checked to see of the 32bit version is the problem (though excel 32bit doesn't exceed the 600MB memory)

I have used excel 2010 64bit version and got the same results. can't exceed the 65536 rows woth Pivot Chart.

I can exceed this limit in a regular graph.

I'm desperate, I have  tried everything.

please help

I'm assuming from your phrasing that you have an on-sheet pivot table that shows more than the 65K rows, and the corresponding pivot chart is being limited. Two random thoughts;

First, what file format are you using? If your pivottable shows more than 65K rows (xlsx, xlsm) then it probably isn't a legacy format issue

Second, where is the data being populated from? There are some formulas (and IIRC, VBA arrays?) that are still limited to 65K rows. For example, are you using PowerPivot and pulling a chart right off the powerpivot data? Are you creating a pivottable off an OLAP data source, then feeding that into a chart? Are you using any VBA arrays or worksheet formulas along the way to create data sets?

• Edited by Keith Ruck 16 hours 2 minutes ago

I'm assuming from your phrasing that you have an on-sheet pivot table that shows more than the 65K rows, and the corresponding pivot chart is being limited. Two random thoughts;

First, what file format are you using? If your pivottable shows more than 65K rows (xlsx, xlsm) then it probably isn't a legacy format issue

Second, where is the data being populated from? There are some formulas (and IIRC, VBA arrays?) that are still limited to 65K rows. For example, are you using PowerPivot and pulling a chart right off the powerpivot data? Are you creating a pivottable off an OLAP data source, then feeding that into a chart? Are you using any VBA arrays or worksheet formulas along the way to create data sets?

• Edited by Keith Ruck Wednesday, February 11, 2015 7:50 PM
• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, February 16, 2015 6:22 AM
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, March 09, 2015 5:26 AM

I'm assuming from your phrasing that you have an on-sheet pivot table that shows more than the 65K rows, and the corresponding pivot chart is being limited. Two random thoughts;

First, what file format are you using? If your pivottable shows more than 65K rows (xlsx, xlsm) then it probably isn't a legacy format issue

Second, where is the data being populated from? There are some formulas (and IIRC, VBA arrays?) that are still limited to 65K rows. For example, are you using PowerPivot and pulling a chart right off the powerpivot data? Are you creating a pivottable off an OLAP data source, then feeding that into a chart? Are you using any VBA arrays or worksheet formulas along the way to create data sets?

• Edited by Keith Ruck Wednesday, February 11, 2015 7:50 PM
• Proposed as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, February 16, 2015 6:22 AM
• Marked as answer by George.Zhao CHNMicrosoft contingent staff, Moderator Monday, March 09, 2015 5:26 AM

Hi,
I'm marking the reply as answer as there has been no update for a couple of days.
If you come back to find it doesn't work for you, please reply to us and unmark the answer.

Thanks

George Zhao
Forum Support
________________________________________
Come back and mark the replies as answers if they help and unmark them if they provide no help.
If you have any feedback on our support, please click "tnfsl@microsoft.com"

I'm using import from test file, but it's not the problem.

you can make 2 columns with 70K Rows and try to make a Pivot +chart- you will only see 5K rows in the chart.

excel memory is hardly in use- so memory isn't the problem.

I think I looked anywhere for a solution- I thought it was a bug in excel 2010 but than I tried excel 2013 and got the same results.

how can it be??

I'm desperate.

still no solution