charts - 1 column and 2 lines

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

Guest

Is it possible to make one chart with 1 series of columns and 2 series of
lines. The colums are numbers, the lines are %.
expl:
- in columns: 3037 - 1663 - 987 - 338
- 1st line: 49%, 27%, 16%, 5%
- 2nd line: 49%, 76%, 92%; 97%

thanks, Katleen
 
Hi,

Yes it is possible. Start by creating a LINE chart based on all three data
sets.
Select the data series you want as a column and then change it's chart type
to Column. Right click, Chart Type, Column.
Select the column series and change the Axis to secondary. Double click
series and pick Secondary on the Axis tab.

This will leave the 2 lines on the primary axis, you should see them now.
And the columns on the secondary.
Label the Axes to make the association clear.

Cheers
Andy
 
Back
Top