A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Apply Two Fill Colours Between Lines in a Chart



 
 
Thread Tools Display Modes
  #1  
Old March 10th, 2006, 06:39 AM posted to microsoft.public.excel.charting
external usenet poster
 
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  
Old March 10th, 2006, 09:57 AM posted to microsoft.public.excel.charting
external usenet poster
 
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
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Vertical Lines on the Lines on 2 Axes Chart [email protected] Charts and Charting 3 March 3rd, 2006 05:14 AM
Multiple filter query of form truepantera Using Forms 6 August 4th, 2005 08:26 AM
Want to combine columns and horizontal lines in complex chart - Can it be Done?! James Hobart Charts and Charting 3 February 18th, 2005 03:23 AM
How do print a chart so the chart area 'fill' shows through it? holly Charts and Charting 1 October 9th, 2004 04:36 AM
Styles for chart Debra Dalgleish Charts and Charting 1 October 3rd, 2003 12:27 PM


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


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