Line Graphs

S

SecretaryII

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

HelpExcel.com

You could likely "trick" Excel by making another set of data between the two
data points and using a zero gap.
 
D

daniel.priddy

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
_______






- Show quoted text -
Click to expand...

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.
 
J

Jon Peltier

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-06-ACNJ/AdvExcelConf200906ACNJ.html
_______


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
_______






- Show quoted text -
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make the shading look uniform around a double spaced line in MS Word? 0
Line graphs; excel 2007 1
Hide line and legend when data not present 0
Automatic Macro to create 200 graphs 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Plotting Line Graphs to Specific Bar Graphs 0
Justification function versus wide spaces 0
Style Gallery View 3

Top