Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rick Andrews
 
Posts: n/a
Default Apply Two Fill Colours Between Lines in a Chart

I am trying to produce a graph that tracks an actual performance against a
target. When the actual performance is below the target, the area between
them needs to be filled red. When the actual performance is above the
target, the area between them needs to be filled green.



I have followed the steps detailed in the TechTrax Article on "Apply Fill
Color Between Lines in a Chart"
(http://pubs.logicalexpressions.com/P...cle.asp?ID=590).



This produced what I required except for the correct colouring.



Is this possible?






  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Apply Two Fill Colours Between Lines in a Chart

Hi

It should be possible you just need to use extra series to provide the
different colours. See this example.
http://www.andypope.info/ngs/ng21.htm

Cheers
Andy

Rick Andrews wrote:
I am trying to produce a graph that tracks an actual performance against a
target. When the actual performance is below the target, the area between
them needs to be filled red. When the actual performance is above the
target, the area between them needs to be filled green.



I have followed the steps detailed in the TechTrax Article on "Apply Fill
Color Between Lines in a Chart"
(http://pubs.logicalexpressions.com/P...cle.asp?ID=590).



This produced what I required except for the correct colouring.



Is this possible?







--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
How do I shade the area between two lines on a chart? Hart Charts and Charting in Excel 4 April 3rd 23 04:29 PM
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting in Excel 3 March 3rd 06 05:14 AM
Horizontal lines in waterfall chart Tim Charts and Charting in Excel 1 October 9th 05 11:45 PM
= Drawing more lines in a OHLCV chart = hcova Charts and Charting in Excel 1 December 13th 04 05:57 AM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 05:45 AM


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

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

About Us

"It's about Microsoft Excel"