Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stubborn macro
I've found macros very useful in the past, but I haven't
used one for a while, and I'm (clearly) out of practice. I'm trying to write a simple macro which draws a bubble chart uses a few cells of data from a worksheet. It's stopping on the first line after Charts.Add - ActiveChart.ChartType = xlBubble and I don't understand why! Anyone got any bright ideas? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stubborn macro
Did you try recording a macro while you created one manually. Even that
isn't fool proof, but it should be a start. The order you do things in chart creation with macros can be important. It is possible you don't have you data in the chart yet or for some other reason, it errors on xlbubble. Also, I don't believe there was a bubble chart option in Excel 97. For the best help, you might want to post this question (with more details) in the Charting newsgroup Microsoft.public.excel.charting -- Regards, Tom Ogilvy "josie" wrote in message ... I've found macros very useful in the past, but I haven't used one for a while, and I'm (clearly) out of practice. I'm trying to write a simple macro which draws a bubble chart uses a few cells of data from a worksheet. It's stopping on the first line after Charts.Add - ActiveChart.ChartType = xlBubble and I don't understand why! Anyone got any bright ideas? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stubborn macro
That's exactly what I did. Designed the chart from data
on the worksheet while recording, then got rid of the chart and ran the macro. No joy. Thanks anyway. I'll post the query with more detail on the charting section. Josie -----Original Message----- Did you try recording a macro while you created one manually. Even that isn't fool proof, but it should be a start. The order you do things in chart creation with macros can be important. It is possible you don't have you data in the chart yet or for some other reason, it errors on xlbubble. Also, I don't believe there was a bubble chart option in Excel 97. For the best help, you might want to post this question (with more details) in the Charting newsgroup Microsoft.public.excel.charting -- Regards, Tom Ogilvy "josie" wrote in message ... I've found macros very useful in the past, but I haven't used one for a while, and I'm (clearly) out of practice. I'm trying to write a simple macro which draws a bubble chart uses a few cells of data from a worksheet. It's stopping on the first line after Charts.Add - ActiveChart.ChartType = xlBubble and I don't understand why! Anyone got any bright ideas? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stubborn cell formatting. | Excel Worksheet Functions | |||
A Very stubborn apostrophe that only shows in editing mode and the formula bar... | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Stubborn Link Data/Value Problem - Help Appreciated! | Excel Programming | |||
Start Macro / Stop Macro / Restart Macro | Excel Programming |