Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have 7 different major sections (years) on the x axis of a bar graph. Is it
possible to have the backround/plot area (not the bars) colored in 7 different shades? Help is appreciated! |
#2
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Use a set of area chart series on the primary axes, using a technique like
this: http://pubs.logicalexpressions.com/P...cle.asp?ID=508 Then add new series for the bars. When you first add a new series it will not be the type you want, so change it to the bar or column (or whatever else) you want. You will probably also want it on the secondary axes. You can hide the primary axes and rearrange the other axes so the chart looks like you want it. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "JJ" wrote in message ... I have 7 different major sections (years) on the x axis of a bar graph. Is it possible to have the backround/plot area (not the bars) colored in 7 different shades? Help is appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to apply the same background to many sheets simultaneously. | Excel Worksheet Functions | |||
Form-filling application with Excel (background image)? | Excel Discussion (Misc queries) | |||
establishing the background colour of a cell | Excel Discussion (Misc queries) | |||
Background Picture OR text over a picture | Excel Discussion (Misc queries) | |||
Photo for background takes a lot of space (MB) | Setting up and Configuration of Excel |