multiple series bar and line chart

D

David NGC

Hello,

I am creating charts with 5 data series. I have it set up to create both
bars and lines. (bars plotted agains primary y axis, lines against secondary
y axis) However, it always sets the first four series to display as bars and
the last one as a line. I need the first two as bars and the last three as
lines.

How do I force a series from one type to the other?

I have already tried "plot series on secondary axis" but that only plots the
bars against the second axis. it does not change them to a line.

I am using excel 2003, and cannot use plugins. Only stock excel.

Thanks
 
L

Luke M

Select the single series you want to change. Now goto Chart - Chart Type, and
change it to whatever you'd like.

Repeat as needed for other series. Note that you will still need to move
them over to the secondary axis, but you already know how to do that.
 
D

David NGC

Awesome! Thanks a lot.



Luke M said:
Select the single series you want to change. Now goto Chart - Chart Type, and
change it to whatever you'd like.

Repeat as needed for other series. Note that you will still need to move
them over to the secondary axis, but you already know how to do that.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top