Chart data series background color

T

Terry Deever

How do I change the background color for the data series?

I want a bar chart to display the bars with a blue color.
When a number in the data series is negative, I want the
bar representing the negative number to be red. On the
Format Data Series window on the Patterns tab, I have
checked the box that says "Invert if negative." Now when
negative, the bar color is white. I can't find where to
set the background color to red.
 
D

Debra Dalgleish

You can select a different background colour to format the column. There
will be a pattern showing in the column, but this may be an acceptable
option for you:

1. Right-click a column, and choose Format Data Series
2. On the Patterns tab, click Fill Effects
3. On the Pattern tab, select a background colour,
which will be the positive numbers
4. Select a foreground colour, which will be the negative numbers
5. Click OK, click OK

Or, try the conditional formatting technique on Jon Peltier's web site:
http://www.geocities.com/jonpeltier/Excel/Charts/ConditionalChart1.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top