#1
|
|||
|
|||
Select Series Color - Macro
Hello,
I was wondering if it was possible to create a button in Excel (2010) that will change the color of a series in a chart at once; that is line, marker fill, marker line. The fact is, I have almost 20 charts - each with the same legend - that have 1% xxx, 2% xxx, 3% xxx, 5% xxx, 7% xxx, 10% xxx etc. Where each #% xxx point to a different cell in my spreadsheet (one cell each). Every graph needs (for example) 1% xxx to be Navy, 2% xxx - burgundy, 3% xxx - green etc. I'd really like to automate this as it will take almost as much time as composing the rest of my presentation. Any suggestions would be much appreciated.. Bryan |
Tags |
automation, graph color, macro |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Data Series | Zach | Excel | 1 | 11-05-2010 02:45 PM |
Selecting specific text out of a series of columns | speedycorn1 | Word | 3 | 11-01-2010 02:58 PM |
Select text by color | Invain | Word | 1 | 02-14-2010 07:08 AM |
Uniform color for scatter plot with 2 series | gramentz | Excel | 2 | 01-17-2010 08:21 AM |
Custom animating a line chart by series and category. | Gahzi | PowerPoint | 0 | 05-19-2009 11:53 AM |