Chart Question - Positive/Negative colors 1

[Scott02]

Hello All. I've got an area chart that reflects positive and negative values. I've been trying to find a way to show the areas in different colors, depending on the sign of the data. I need the area with positive data to be blue, and the area below zero to be red. Does anyone know if this is an option in Excel anywhere? Thanks for any advice.

Scott

 

[SkipVought]

Hi,

Using a formula, make a range for positive value and another for negative values
[tt]
Val Pos Neg
22 22 0
-5 0 -5
31 31 0
[/tt]
plot Pos & Neg

Skip,

_[red][/red]

 

[Scott02]

Skip,

I'm not sure I follow. The data being plotted is a variance from actual to plan numbers. Some being positive, some negative, along a timeline. If along the way they are dipping up and down, how do I get one continuous line, but different colored areas? Will your suggestion work that way?

Thanks for the help

Scott

 

[xlbo]

Skip's suggestion will work for a Column chart - probably not so well for a line chart but I would've thought that for your purpose, you would be better off with a column chart anyway...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Scott02]

If my goal is to keep this as a line chart with colored areas above/below the line being blue(+) or red (-), am I aiming for the stars here, or is there actually a way to do this? I appreciate the feedback.

Thanks

Scott

 

[Corgano]

This website has some cool chart info including what I think you're looking for:

http://andypope.info/charts.htm

 

[Corgano]

It's forth from the bottom

(sorry for the double post, there's no edit feature >< )

 

[xlbo]

aaaah - area chart - not line chart...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[Scott02]

Thanks for the help guys. I'm going to work on that with the example from the website Corgano shared with me. It'll take me a bit to go through the set up. Looks like a lot of interesting stuff on the site as well.

Thanks again

Scott