100% stacked with line on secondary axis

  • Thread starter Thread starter JohnDK
  • Start date Start date
J

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
 
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.
Click to expand...

hope this helps.
 
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
 
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/
_______
 
Back
Top