100% stacked with line on secondary axis

[JohnDK]

I've got a 8 series chart. 7series make up the 100% stacked column.
wanna show the 8th series as line on a secondary axis with values no
as percentages.
I've done it before but can't remember how, still have the chart but i
shows no clue.
Copied the 8th series to chart and it shows in legend but i can't ge
right combination to show the actual series in the chart.
Can anyone advise.
Than

 

[Guest]

After adding the 8th serie selected and right click and
select chart type (line) then go to format data series -

axis ->and select secondary axis.

hope this helps.

 

[JohnDK]

After adding the 8th series, i can't find it anywhere on the chart t
select and change the chart type, but it does show in the legend a
added.

Th

 

[Jon Peltier]

John -

Right click on the series you want to change, select Chart Type from the
pop up menu, and choose a Line style.

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