Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Charts Using Macros
Hi,
How do I create and run a macro to format a bar graph in Excel? For example, I want to change a bar to brown and then apply a gradient. Formatting text seems easy enough, but I don't know how to create macros to format colors in charts. Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formatting Charts Using Macros
If you have Excel 2003 or earlier, you can simply turn on the macro
recorder, perform the formatting manually, then examine the recorded code. It won't be efficient code, but it will work, and it will give you the syntax needed. I've written a couple guidelines for fixing up your recorded macros: http://peltiertech.com/WordPress/how...ecorded-macro/ http://peltiertech.com/WordPress/mak...dent-of-sheet/ If you are using Excel 2007, you can still use macros from 2003, usually without major changes. However, the macro recorder doesn't record any formatting you perform on shapes or charts. You could try using the help files, but for over two years I've struggled with them. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "neesie214" wrote in message ... Hi, How do I create and run a macro to format a bar graph in Excel? For example, I want to change a bar to brown and then apply a gradient. Formatting text seems easy enough, but I don't know how to create macros to format colors in charts. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make macros in charts | Charts and Charting in Excel | |||
How do I update charts using macros | Charts and Charting in Excel | |||
Formatting (macros or templates)? | Excel Discussion (Misc queries) | |||
Excel Charts(Graphs) & Macros | Excel Discussion (Misc queries) | |||
Macros & pie charts | Charts and Charting in Excel |