Bar Charting Question--Please Help!

j3x

New Member
Joined
Feb 6, 2004
Messages
20
Hi,
I'm attempting to graph 4 series of data. Two should use the primary y-axis and two should use the secondary y-axis. Whenever I try to do this, the second two bar graphs get graphed on top of/stacked on the first two instead of to the right of them. Is there a way to get around this? Much thanks.
 

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,021
Add two additional dummy series to both axis' groups of series. For Y2 you might need to use the series formula to adjust the final argument to make the dummies series #1 & #2.

HTH
 

Greg Truby

MrExcel MVP
Joined
Jun 19, 2002
Messages
10,021
j3x,

[response based on question asked in PM]

If you want both [Y1-series & Y2-series] to be bars or columns, then yes, you'll need to utilize some dummy series to fix the "one in front of the other" problem.

That said, typically when you have a double-y-axis chart you mix types. To do that click on the series that are being mapped to either the 1st or 2nd Y axis and then right-click and from the popup pick Chart Type and change it to a line or something. This keeps the data points lined up nicely vis-a-vis the category (X) axis while fixing the old "peek-a-boo" problem.

HTH
 

Forum statistics

Threads
1,148,528
Messages
5,747,221
Members
424,069
Latest member
kamkwok1hh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top