-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Color condition in a Pivot chart
- Thread starter Santiago
- Start date
Russ At Index
Well-known Member
- Joined
- Sep 23, 2002
- Messages
- 704
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Santiago,
I think this is what you are after , if i have miss intrepreted
your thread , i apologise !!!!
Right click & select format either :
Format Gridlines.
Format Data Series.
Format Plot Area.
Depending where you "hovver" your mouse , you
can choose to colour all areas of your chart.
Hope this helps you out !
I think this is what you are after , if i have miss intrepreted
your thread , i apologise !!!!
Right click & select format either :
Format Gridlines.
Format Data Series.
Format Plot Area.
Depending where you "hovver" your mouse , you
can choose to colour all areas of your chart.
Hope this helps you out !
Upvote
0
DancingDavidE
New Member
- Joined
- Feb 2, 2003
- Messages
- 30
would anyone have any suggestions 'strategy wise' on how to go about selecting some columns and coloring them differently from the rest of the columns?
I have a set of data graphed, and some of the data may be organized in groups, so for instance I may want to highlight all of the columns corresponding to Group A, meanwhile leaving everything sorted in descending order of consumption for the whole population.
Right now I'm not doing this in a pivot chart, I have some macros to do it on regular charts. The problem is that I end up with so many different files and charts, it would be handy to have one chart and change it every time I need an update.
I have a set of data graphed, and some of the data may be organized in groups, so for instance I may want to highlight all of the columns corresponding to Group A, meanwhile leaving everything sorted in descending order of consumption for the whole population.
Right now I'm not doing this in a pivot chart, I have some macros to do it on regular charts. The problem is that I end up with so many different files and charts, it would be handy to have one chart and change it every time I need an update.
Upvote
0
