Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add only SOME Fill effects to multiple bars
Hoping someone can help (Excel 2003)
I have a column chart with one series displayed. I've gone into the Format Data Series option and 'varied the points by color' so each column is a different color. Easy enough. But now, I want to be able to add a specific pattern (Go into Fill Effects / Patterns tab) to each of these bars while maintaining their current color. The problem is as soon as I choose a pattern, it also applies the colors that were chosen as part of the current pattern Fill Effects. So I have to double-click each column manually to add the same pattern if I want to maintain the current color. Is there a quick way to add patterns (or any formatting effect) to a series while still maintaining their current color scheme? Thank you! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Add only SOME Fill effects to multiple bars
Once you format points individually, if you apply a format to the entire
series, you lose the formatting applied to individual points. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Access Joe" wrote in message ... Hoping someone can help (Excel 2003) I have a column chart with one series displayed. I've gone into the Format Data Series option and 'varied the points by color' so each column is a different color. Easy enough. But now, I want to be able to add a specific pattern (Go into Fill Effects / Patterns tab) to each of these bars while maintaining their current color. The problem is as soon as I choose a pattern, it also applies the colors that were chosen as part of the current pattern Fill Effects. So I have to double-click each column manually to add the same pattern if I want to maintain the current color. Is there a quick way to add patterns (or any formatting effect) to a series while still maintaining their current color scheme? Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
radar chart - how to acieve transparency in fill effects? | Charts and Charting in Excel | |||
Fill Effects on Fill Color | Excel Discussion (Misc queries) | |||
multiple combination bars chart | Charts and Charting in Excel | |||
adding multiple error bars to bar chart | Charts and Charting in Excel | |||
Fill Effects | Excel Discussion (Misc queries) |