View Single Post
Old 03-14-2011, 02:35 PM
judicial85 judicial85 is offline Windows 7 Office 2010 (Version 14.0)
Advanced Beginner
Join Date: Nov 2010
Posts: 64
judicial85 is on a distinguished road
Default Select Series Color - Macro


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..
Reply With Quote