View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default charts - 1 column and 2 lines

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

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Katleen" wrote in message
...
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