Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Charts.Add - Smart, But Oh So Dumb
Here's the scenario, in Excel 2007 (of course)I have a sheet with 365
rows, 253 columns. I have a macro that's going to build a chart based on SOME of those columns. My code says Set oActChart = Charts.Add Used to work just fine in Excel 2003, now it takes 2.5 minutes and sucks up half a gig of memory, because it thinks I want to chart everything on the data sheet. I can get around this by selecting a small range on the data sheet, but I'd far prefer to be able to tell Excel not to try to anticipate what I want to do. Is there any simple way - other than that above - to do this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working with Smart Art Graphics, Sheets, and Charts | Excel Discussion (Misc queries) | |||
Smart charts. Is it possible? | Excel Discussion (Misc queries) | |||
what is a dumb or smart formula | Excel Worksheet Functions | |||
Dumb question of the day. | Excel Programming | |||
smart charts | Charts and Charting in Excel |