Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-14-2011, 02:35 PM
judicial85 judicial85 is offline Select Series Color - Macro Windows 7 Select Series Color - Macro Office 2010 (Version 14.0)
Advanced Beginner
Select Series Color - Macro
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

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
Select Series Color - Macro Selecting specific text out of a series of columns speedycorn1 Word 3 11-01-2010 02:58 PM
Select Series Color - Macro Select text by color Invain Word 1 02-14-2010 07:08 AM
Select Series Color - Macro 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

Other Forums: Access Forums - Senior Forums

All times are GMT -7. The time now is 05:46 AM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd. is not affiliated with Microsoft