View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
ufo_pilot
 
Posts: n/a
Default Area between two lines in a chart

I looked in the Help section, I did this once before, a long time ago, so I'm
not too brushed up on this one.
But you may be able to get some information from the Help file:

To add up-down bars and drop, series, and high-low lines to charts

You can add series lines to connect data series in 2-D stacked bar and
column charts. Drop lines are available in 2-D and 3-D area and line charts.
High-low lines and up-down bars are available in 2-D line charts. Stock
charts already have high-low lines and up-down bars.
To add these lines and bars to all data series of the same chart type,
select only a single data series.

1 Click a data series in the chart that you want to add bars or lines to.
2 On the Format menu, click Data Series, and then click the Options tab.
3 Select the option for the type of lines or bars you want.



"Tulane chic" wrote:

I'm trying to find the area between two lines in a line chart. Both of the
lines are not functions so I am unable to intergrate. How can I find the area
between them?