Two y-axes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

alext49 - 03 Aug 2007 19:56 GMT

Hi,

I have column chart set up with two data series side-by-side, one of which
needs to be put on a different scale. When I click on the second data series
and select "secondary axis", the data series disappears for all except the
final data point, which is then stacked on top of series 1.

I am successful if I select custom chart and select "line -column on two
axes", but then my second data series is a line instead of a column.
Thoughts or suggestions appreciated.

Reply to this Message

alext49 - 03 Aug 2007 20:52 GMT

I just noticed that it's not stacking the data, it's showing the smaller data
up to a point and then the larger data is going up to the taller height along
the y axis. I still would like to show two distinct bar charts, though--one
on the left measured against the first y axis, and the second on the right
measured against the second (right) y axis.

> Hi,
>
[quoted text clipped - 6 lines]
> axes", but then my second data series is a line instead of a column.
> Thoughts or suggestions appreciated.

Reply to this Message

ShaneDevenshire - 03 Aug 2007 21:02 GMT

Hi,

This is probably happening because both series are being plotted as columns,
something that Excel is not well designed to handle.

One solution is to change at least one of the series to a line chart.
Select the series and choose Chart, Chart Type, Line.

A second somewhat more convoluted solution is to create two dummy series and
put one on one axis the other on the second axis. I wrote a couple of
articles on this technique in about 1991 and also published it in a couple of
Excel books. Jon also has it on his website as do others.

If you need more detail, let us know.

Signature

Cheers,
Shane Devenshire

> I just noticed that it's not stacking the data, it's showing the smaller data
> up to a point and then the larger data is going up to the taller height along
[quoted text clipped - 12 lines]
> > axes", but then my second data series is a line instead of a column.
> > Thoughts or suggestions appreciated.

Reply to this Message

Bernard Liengme - 04 Aug 2007 12:58 GMT

See http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> Hi,
>
[quoted text clipped - 7 lines]
> axes", but then my second data series is a line instead of a column.
> Thoughts or suggestions appreciated.

Reply to this Message

marsolek@gmail.com - 27 Sep 2007 22:02 GMT

On Aug 4, 4:58 am, "Bernard Liengme" <blien...@stfx.TRUENORTH.ca>
wrote:

> Seehttp://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
> best wishes
[quoted text clipped - 14 lines]
> > axes", but then my second data series is a line instead of a column.
> > Thoughts or suggestions appreciated.

That was a big help to me also, thanks for the link!

-Mike

Reply to this Message