ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Area between two lines in a chart (https://www.excelbanter.com/new-users-excel/93735-area-between-two-lines-chart.html)

Tulane chic

Area between two lines in a chart
 
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?

ufo_pilot

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?



All times are GMT +1. The time now is 07:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com