Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 27th 09, 12:28 AM posted to microsoft.public.excel.charting
JW JW is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 22
Default 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   Report Post  
Old 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
Default 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   Report Post  
Old 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
Default 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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing text color based upon If KenM Excel Discussion (Misc queries) 5 November 24th 08 08:56 PM
Changing the color of PART of a line just_asks Charts and Charting in Excel 3 February 28th 07 04:37 AM
Changing background color based on different cell djarcadian Excel Discussion (Misc queries) 3 August 10th 06 10:44 PM
Changing color of line chart by date [email protected] Charts and Charting in Excel 0 July 10th 06 06:40 PM
Changing a line color when it crosses another benchmark line? 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.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017