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

--
Message posted from http://www.ExcelForum.com

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.


>-----Original Message-----
>I've got a 8 series chart. 7series make up the 100%
stacked column. I
>wanna show the 8th series as line on a secondary axis
with values not
>as percentages.
>I've done it before but can't remember how, still have
the chart but it
>shows no clue.
>Copied the 8th series to chart and it shows in legend but
i can't get
>right combination to show the actual series in the chart.
>Can anyone advise.
>Thanx
>
>
>---
>Message posted from http://www.ExcelForum.com/
>
>.
>

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

--
Message posted from http://www.ExcelForum.com

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/
_______

JohnDK < wrote:

> After adding the 8th series, i can't find it anywhere on the chart to
> select and change the chart type, but it does show in the legend as
> added.
>
> Thx
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>