#1   Report Post  
Old May 17th 09, 10:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default Line Graphs

Is there a way to shade the area between two lines in a line graph, while
leaving the rest unshaded?


  #2   Report Post  
Old May 18th 09, 01:47 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Line Graphs

Yep, try this:

http://peltiertech.com/Excel/Charts/XYAreaChart2.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
_______


"SecretaryII" wrote in message
...
Is there a way to shade the area between two lines in a line graph, while
leaving the rest unshaded?



  #3   Report Post  
Old May 18th 09, 01:50 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2009
Posts: 39
Default Line Graphs

You could likely "trick" Excel by making another set of data between the two
data points and using a zero gap.
--
Regards,
Eddie
http://www.HelpExcel.com


"SecretaryII" wrote:

Is there a way to shade the area between two lines in a line graph, while
leaving the rest unshaded?

  #4   Report Post  
Old May 28th 09, 06:46 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: May 2009
Posts: 1
Default Line Graphs

On May 17, 7:47*pm, "Jon Peltier"
wrote:
Yep, try this:

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

- Jon
-------
Jon Peltier, Peltier Technical Services, Inc.http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and Programminghttp://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

"SecretaryII" wrote in message

...



Is there a way to shade the area between two lines in a line graph, while
leaving the rest unshaded?- Hide quoted text -


- Show quoted text -


What is the logic to setting the date range on the secondary x axis to
1-1001? Area 1/Area 2 series both fall off the chart when I get to
this step, but I'm not sure how to remedy.
  #5   Report Post  
Old May 29th 09, 10:41 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 6,582
Default Line Graphs

Dividing the axis into 1000 units provides good resolution. Sometimes you
can't set the minimum of a date scale to zero, so I use 1 to 1001 as the
range.

- 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
_______


wrote in message
...
On May 17, 7:47 pm, "Jon Peltier"
wrote:
Yep, try this:

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

- Jon
-------
Jon Peltier, Peltier Technical Services,
Inc.http://PeltierTech.com/WordPress/

Advanced Excel Conference - June 17-18 2009 - Charting and
Programminghttp://peltiertech.com/Training/2009-06-ACNJ/AdvExcelConf200906ACNJ.html
_______

"SecretaryII" wrote in message

...



Is there a way to shade the area between two lines in a line graph,
while
leaving the rest unshaded?- Hide quoted text -


- Show quoted text -


What is the logic to setting the date range on the secondary x axis to
1-1001? Area 1/Area 2 series both fall off the chart when I get to
this step, but I'm not sure how to remedy.




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
Line graphs Charles Eaves Charts and Charting in Excel 3 October 16th 08 10:21 AM
Line graphs [email protected] Charts and Charting in Excel 1 June 8th 08 01:03 PM
How do you select line or columns in "Line-Column on 2 axes" graphs? mizterbusy Excel Discussion (Misc queries) 0 September 19th 06 06:48 AM
Q about Line Graphs Stacey Charts and Charting in Excel 2 June 16th 05 02:50 AM
Line Graphs and Bar Graphs Christopher Anderson Excel Discussion (Misc queries) 1 December 3rd 04 07:16 PM


All times are GMT +1. The time now is 12:00 AM.

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