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
|