ChartObject will not add to the activesheet when data set is too large...

[herbie226]

Hello,

Here is a good one I suspect.

I wasnt to graph a large quantity of data. I have made a macro that successfully plots a small subset of my data in an organized fashion. I always use a small subset of data to create my macros and then test on the full data set to confirm that there are no bugs. Usually I have no issues scaling up. But this time I cant understand why my chart object will not be created if my data size is too large. I am not trying to plot more than the 250 graphs at once --> just FYI.

To explain my problem will be too difficult so I have attached the small subset of test data and the full size data for comparison.

I hope someone can give me an answer as to why this is happening.

My macro code is below.

"test" file is the large file --> Macro will not create the chart object in this workbook.
"small book2" is the small file --> Macro will create the chart object in this workbook.

Thanks!!!

Please Login or Register  to view this content.

[herbie226]

Maybe I should mention, the graph to be plotted will only plot columns which has "AAAA" as the header. When the Loop is functional (I commented it out) it will run down all the columns and plot separate charts for each different header.

[herbie226]

Bumping to the top...

If anyone needs any other information, please ask.

Thanks!

[Andy Pope]

The problem is that when you add the chart it tries to populate it with data in the current region.
This causes the operation to fail.

Move the active cell to an empty region

Please Login or Register  to view this content.

[herbie226]

Okay Andy. That did work. I thought that the cahrt object was independant from the current region but apparently not.

Thank you again.