Value and area between 2 lines

  • Thread starter Thread starter Helal
  • Start date Start date
H

Helal

Hi All,

I have a chart plotting two smooth lines, one for budget
and the other for actual.

Is there any way I can have different colour than the
colour of the plot area between the two lines. Also, how
can I show the value between two lines at certain points?

Thanks for your help.

Regards

Helal
 
Helal -

If the chart works okay as a line chart (as opposed to an XY Scatter
chart), and the line isn't smoothed, you could make a stacked area
chart, where one series plotted the lower curve, and the other plotted
the difference between them. Format the bottom series to be invisible
(no fill) so the top one gives the shading between the two.

Unfortunately, area charts do not support smoothing of the connecting
lines, and they often do not provide for a useful X axis.

If the line segments are straight, you could use the TREND worksheet
function to compute the Y for a given X: TREND(Known Ys, Known Xs,
Particular X); use the endpoints of a particular segment. If you want
the Y value along a curving line that Excel drew, that's a lot of work.
Brian Murphy (http://xlrotor.com) has posted information about the
bezier curve that Excel draws between points, while Dave Braden has
posted to these newsgroups about cubic spline functions that could also
give these values. Check the google newsgroup archives at
http://www.google.com/advanced_group_search.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Back
Top