Bars overlapping for primary axis data and secondary axis data

**Lui23** · 01-18-2013, 05:47 AM

Hey guys,

I have data wherein i have number of branches and total revenues for 8 banks. When i try to combine these data in a single chart using total revenues on primary axis and number of branches on secondary axis, the bars for each bank for these 2 values overlap. Instead, what i want is bars side by side of each other. I tries selecting a series and then reducing/increasing the overlap but it does not work. Can anyone help?

Regards,
Ankit

**Spencer101** · 01-18-2013, 05:49 AM

Hi Ankit,

Could you post an example workbook?

**Lui23** · 01-18-2013, 05:54 AM

Hi,

I have attached an example sheet. I tried to play around with the overlap function but it does not help.

**lmp** · 01-19-2013, 05:06 AM

Hello,

you need to chart two series on each axis. On the primary axis, chart the total revenue and an empty series.
On the Secondary axis chart an empty series and then the number of banks.

See attached.