Add further graphics to created line chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a line chart with two lines, one line goes up and the other
line trends down. As there any way that I can show the difference in the
value of the 2 lines by "painting" the area BETWEEN the 2 lines and adding
the amount inside the "painted" area? For instance, the top line has a value
of $2,000; the second line has a value of $500. Is there any way to shade or
paint only the area between the 2 lines - which represents the $1,500
difference in the 2 - and add text in the painted area saying "$1,500"?

Thanks.
 
One way that I can think of is to use an area chart and give the data series
with the smaller values a white fill. You would need to use a regular textbox
to "float" or drag the $1,500 text in place on top of the chart.
 
Back
Top