Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can excel graphs be set to choose same colour i.e hols = yellow
I have a weekly task of tracking resource across a large department,
therefore numberous graphs. Is there any way to set up excel to select the same colour for the same task i.e. Holidays always show as Yellow on each graph. At the moment I am manually going through each graph and changing the colour of all tasks for each individual!! Currently using Excel 2003. Any help will be greatly received. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can excel graphs be set to choose same colour i.e hols = yellow
Hi,
See Jon's blog on a VBA solution to this problem. http://peltiertech.com/WordPress/200...y-series-name/ Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "LyndseyF_UK" wrote in message ... I have a weekly task of tracking resource across a large department, therefore numberous graphs. Is there any way to set up excel to select the same colour for the same task i.e. Holidays always show as Yellow on each graph. At the moment I am manually going through each graph and changing the colour of all tasks for each individual!! Currently using Excel 2003. Any help will be greatly received. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can excel graphs be set to choose same colour i.e hols = yellow
You can use VBA procedures to format named series in the same color. I show
how in this blog post: http://peltiertech.com/WordPress/200...y-series-name/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "LyndseyF_UK" wrote in message ... I have a weekly task of tracking resource across a large department, therefore numberous graphs. Is there any way to set up excel to select the same colour for the same task i.e. Holidays always show as Yellow on each graph. At the moment I am manually going through each graph and changing the colour of all tasks for each individual!! Currently using Excel 2003. Any help will be greatly received. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Can excel graphs be set to choose same colour i.e hols = yellow
Hi,
If each item (holidays, what ever) have the same series number then you can change all of them with one command in one workbook - Choose Tools, Option, Color, and note the Chart fills colors, modify the one you don't like by clicking it and choosing Modify, picking the new color and saying OK This will change this color for the entire workbook. -- Thanks, Shane Devenshire "LyndseyF_UK" wrote: I have a weekly task of tracking resource across a large department, therefore numberous graphs. Is there any way to set up excel to select the same colour for the same task i.e. Holidays always show as Yellow on each graph. At the moment I am manually going through each graph and changing the colour of all tasks for each individual!! Currently using Excel 2003. Any help will be greatly received. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I save new colour schemes for graphs in the colour template | Charts and Charting in Excel | |||
Excel - conditional formating on graphs. Change colour on a value | Charts and Charting in Excel | |||
How do I choose a cell colour, without it being tied to the data? | Excel Discussion (Misc queries) | |||
formula for if Cell c1 is yellow shaded cell d1 should be yellow | Excel Discussion (Misc queries) | |||
Problems with date calculations (bank hols etc) | Excel Discussion (Misc queries) |