Adding a second line on a two axis column stacked chart

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 ?
 
J

Jon Peltier

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

Jon Peltier

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

Jon Peltier

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

Jon Peltier

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

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

Similar Threads

sideways stacked bar charts with line series on the same axis 0
Use text descriptors as Y axis units 1
Chart data scrunches to left when adding X axis date series 0
Make Y-axis values correspond to x- axis value 1
column charts with set set of data 0
Dynamic series in rows 1
Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? 2
multiple series bar and line chart 2

Top