| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
2007 column chart theme colors via VBA
I'm creating a column chart with 20 pairs of series. Because there are so
many series (2x20==40), I've done it quickly with VBA. What I haven't figured out is how to use "theme colors" to set the fill color for each series with VBA. Ideally each pair would use the same color but with two different shades (is that even the correct term?). Is there a guide somewhere that explains how to work with theme colors in this setting? I suppose I'm not necessarily tied to theme colors, but it would be nice (so users could change the theme, I suppose). Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Share Theme Colors with other users | Excel Discussion (Misc queries) | |||
| Excel Theme Colors Strange Behavior | Excel Discussion (Misc queries) | |||
| Excel 2007 Negative Bar Colors in a Chart | Charts and Charting in Excel | |||
| Theme Colors are horrible! | Excel Discussion (Misc queries) | |||
| Theme Colors in Office 2007 | Excel Discussion (Misc queries) | |||
Threaded Mode
