| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to write a macro to modify an Excel chart
I want to "record" a macro that, for example, changes the line styles on an
Excel chart. I tried by selecting the chart, then clicking on "record macro", manually changing the line style, and then clicking on "stop recording". But then when I tried to use the macro it wouldn't do anything. When I edited the macro there was no code, just the comment lines giving the shortcut. Is it possible to use the "record" feature for macros that work with charts, or must one start with the VB editor? Thanks, Henry -- leave well enough alone |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a copy of excel file in macro but have it auto write | Excel Worksheet Functions | |||
| Modify Macro Code Depending on Excel Version | Excel Discussion (Misc queries) | |||
| How do I write an auto macro to undo filtering at statup in Excel | Excel Worksheet Functions | |||
| is it possible to execute write to the fields in another .xsl form a macro in another .xsl? e.g. some way to load another .xsl into an .xsl macro and write to its data? | Excel Worksheet Functions | |||
| How to write a macro to get the system time in excel 97 | Excel Discussion (Misc queries) | |||
Threaded Mode
