Adding a second line on a two axis column stacked chart

  • Thread starter Thread starter JC
  • Start date Start date
J

JC

I have a stacked bar graph showing 4 data series on the x-
axis with a line showing 1 data series on the secondary
x-axis.

Now I want to add a second line to the secondary axis

When I do so it automatically becomes a bar instead of a
line, regardless which axis I am plotting it on.

Is there anyone out there that knows what I am doing
wrong and/or what the trick is ?
 
The trick is this: Don't use the "built-in custom" chart types, but make
your own. Make your chart with all series as stacked columns, then
select each one you want to change, and use Chart Type on the Chart menu
to change it. To put it onto the secondary axis, double click on the
series, and select Secondary on the Axis tab.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
It's okay to use the chart wizard to create charts with the built-in
standard types. I was pointing out that the built-in custom types are
not the only custom types available, nor are they the best suited to
your needs. When you add series to them, often they change existing
series in unexpected ways, and thinking that they are the only options
can be very limiting.

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

You have XP or 2003? If so, it sounds like the Display Units setting is
Hundreds.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Demunge my email address (remove the caps) and send me the file. I'll
take a look.

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