Remember Me?

#1
April 27th 09, 12:28 AM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 22
changing area color based on line value

I have been working with an area chart colored in green. Based on certain
values of the graph, I would like the area just below the data point
highlighted in a different color (like red). In the end, the area graph will
have 2 different colors in the 'area' below the line. The color below, will
depend on the value of the line above. Any help is appreciated.

Also, I would consider a vertical bar graph where the spacing in between
bars is zero. That way, from a far, it could give the appearance of an area
graph. I think I would need each 'bar' colored appropriately. I have
struggled coming up with this graph as well.

I envision a 3 column data series...
Column A = x axis
Column B = y axis
Column C = logic calculation that determines whether the data point is
colored red or green.

I am open to suggestions and assistance.

#2
April 29th 09, 02:21 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 6,582
changing area color based on line value

You cannot color an area chart in this way, but you can fudge it with a
column chart. Here's a technique:

http://peltiertech.com/Excel/Charts/...nalChart1.html

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
Advanced Excel Conference - June 17-18 2009 - Charting and Programming
http://peltiertech.com/Training/2009...00906ACNJ.html
_______

"JW" wrote in message
...
I have been working with an area chart colored in green. Based on certain
values of the graph, I would like the area just below the data point
highlighted in a different color (like red). In the end, the area graph
will
have 2 different colors in the 'area' below the line. The color below,
will
depend on the value of the line above. Any help is appreciated.

Also, I would consider a vertical bar graph where the spacing in between
bars is zero. That way, from a far, it could give the appearance of an
area
graph. I think I would need each 'bar' colored appropriately. I have
struggled coming up with this graph as well.

I envision a 3 column data series...
Column A = x axis
Column B = y axis
Column C = logic calculation that determines whether the data point is
colored red or green.

I am open to suggestions and assistance.

#3
April 29th 09, 02:55 PM posted to microsoft.public.excel.charting
 external usenet poster First recorded activity by ExcelBanter: Jul 2006 Posts: 2,489
changing area color based on line value

Hi,

It's not 100% clear whether the whole area between 2 points should be
coloured differently.

In xl2007 the conditional method suggested by Jon works quite well at
shading blocks between points. This is mainly due to the fact the gap
between points is now a vertical drop to the base line rather than a slope.

Perhaps an alternative is to use error bars. Add a line series, based on
only those points with the low values. Add minus 100% error bars.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"JW" wrote in message
...
I have been working with an area chart colored in green. Based on certain
values of the graph, I would like the area just below the data point
highlighted in a different color (like red). In the end, the area graph
will
have 2 different colors in the 'area' below the line. The color below,
will
depend on the value of the line above. Any help is appreciated.

Also, I would consider a vertical bar graph where the spacing in between
bars is zero. That way, from a far, it could give the appearance of an
area
graph. I think I would need each 'bar' colored appropriately. I have
struggled coming up with this graph as well.

I envision a 3 column data series...
Column A = x axis
Column B = y axis
Column C = logic calculation that determines whether the data point is
colored red or green.

I am open to suggestions and assistance.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post KenM Excel Discussion (Misc queries) 5 November 24th 08 08:56 PM just_asks Charts and Charting in Excel 3 February 28th 07 04:37 AM djarcadian Excel Discussion (Misc queries) 3 August 10th 06 10:44 PM [email protected] Charts and Charting in Excel 0 July 10th 06 06:40 PM JB12 Charts and Charting in Excel 3 December 10th 05 04:48 PM

All times are GMT +1. The time now is 01:01 PM.