Range colors in the background of a chart? XL 2007

[cjbrown815]

Hello, ~Excel 2007, XP pro sp3~
I have a column chart and I need to add range colors in the background. The chart goes from 0 - 10 in the Y axis and date in the X axis, I need to add a green background from 6 - 8 a yellow from 4 - 6 and from 8 - 9 and a red from 1 - 4 and from 9 - 10. How can I do this?

thanks
Cj

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[kjv1611]

You mean format cells? If this isn't something that changes, just click the cell/column(s) you want to change, right-click, format, on pattern, select your color..

Or since it's Excel 2007, select the cell/column(s), and choose the color from the paint bucket on the "Home" tab.

--

"If to err is human, then I must be some kind of human!" -Me

 

[cjbrown815]

Hi Thanks,
No I mean format background of chart

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[kjv1611]

Oh yeah, now I see that word, chart.

 

[xlhelp]

First, plot your data in worksheet columns as a line chart.

Then in three rows in another part of the spreadsheet(say columns H to N:

Leave H1 blank. In J1 to N1 type in any name such as "value" without quotation marks(also without quotation marks" cases that follow.) Yes, in all of them.

In H2 type "a". J2 to N2 type in 0, 0.2, 0.4, 0.6, 0.8, 1.0
In H3 type "b". J3 to N3 repeat as in J2 to N2 (same numbers)

Highlight H1 to N3. Copy. Select your Chart. Go to Paste Special. Choose New Series, Columns, Series Names in First Row and Category (X Labels) in First Column. Click OK.

There will be new small lines on the Chart. Click each one, right click, Format Data Series, Secondary Axis.

Once you are done with all of them, go to Layout Tab, Choose Axes drop down and select Secondary Horizontal Axis, Show axis left to right.

Click on each horizontal line that has been plotted and change the Chart Type for each one to area chart. At this point patience is a virtue.

Change your original plot from line chart to column chart.

Click Secondary Horinatl Axis, right Click and Choose Format Axis. Under "Position Axis:" Click "At tick Marks".

On Layout tab, Select Axes drop down and point to Secondary Horizontal Axis and Choose "Show Axis without labeling"

Change colors on the bands to heart's desire.



Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[cjbrown815]

Thank you,
I'm stuck on the "Click Secondary Horinatl Axis, right Click and Choose Format Axis. Under "Position Axis:" Click "At tick Marks".


I don't see that option (Position axis) under "Format Axis"

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[xlhelp]

Should be second from the bottom; if not, something went wrong somewhere. Follow the instructions to a T, it works.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents