Microsoft Office Forums Select Series Color - Macro

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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

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

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
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


All times are GMT -7. The time now is 02:09 AM.


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