MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Custom chart- line column on 2 axes

Posted by Barry K on January 08, 2002 8:53 AM

I'm creating a custom line column chart on 2 axes with 6 rows of data. I want 5 rows on the primary axis as bars and the 6th row on the secondary axis as a line. When creating the chart I get 3 data points as bars and 3 as lines regardless of which axis they are on. How can I get the 5 data points as bars and the 6th as a line?

Barry K

Posted by Adam S. on January 08, 2002 11:18 AM

do this

Hey Barry.

You need to identify which bar/line series that automatically pops in on your chart is supposed to go where (likely they're defaulting differently than you're hoping: your legend should show what line is what). Then you can change the lines to bars and vice-versa, and also correct the axis it is supposed to go on.

To change the lines to bars or vice-versa: select one of the incorrect series, right click\Chart type (then you can select bar or line).

To change the axis (I assume you have 2 y-axes, a primary and secondary axis), select the series you want to change, Format\Selected data Series\axis\then select primary or secondary axis.

That should do it.

Adam S.

Posted by Barry K on January 08, 2002 1:58 PM

Re: do this

Thanks Adam, that's something I never would have tried!