chart plot area - split formatting

  • Thread starter Thread starter guvner
  • Start date Start date
G

guvner

I have an excel chart with a single line through the chart (at an
angle). I would like to insert one picture in the plot area below the
line and another picture above the line. Is this possible? Many
thanks for any assistance.
 
Instead of a line chart, you could create an area chart, with a
different picture as fill in each series.

For example, with the following data in A2:E2 --

S1 10 15 20 25

In the row below, enter:

S2 =30-B2

Copy the formula across to cell E3
Create a stacked area chart from the data.
Double-click on the Y axis, and set the Maximum scale to 30
Double-click the top series, click the Fill Effects button,
and on the Picture tab, select a picture.
Fill the bottom series with the second picture.
 
Back
Top