how do I display 2 secondary Y axis' side by side?

[Kevin]

I am setting up a chart for the following
Month Jan Feb Mar Apr
Units 5 4 3 6
Dollar 55 35 40 67
with units and dollar as primary and secondary Y axis'.

My problem is that the two vertical bars for each month overlap each other.
How can I display the units bar and dollar bar for each month side by by side?

If you wish, you can call me at 215 375 4528 cell.

Thanks,

Kevin Si

 

[Bernard Liengme]

Jon tells all at
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes

 

[Shane Devenshire]

Hi,

1. Plot the chart as a line chart including both series
2. Right-click one of the data series on the chart and choose Format Data
Series

2003:
3. Select the Axis tab and choose Secondary axis.

2004:
3. On the Series Options tab pick Secondary Axis.

 

[jaichander]

I am setting up a chart for the following
Month Jan Feb Mar Apr
Units 5 4 3 6
Dollar 55 35 40 67
with units and dollar as primary and secondary Y axis'.

My problem is that the two vertical bars for each month overlap each other.
How can I display the units bar and dollar bar for each month side by by side?

If you wish, you can call me at 215 375 4528 cell.

Thanks,

Kevin Si

 

[jaichander]

I am setting up a chart for the following
Month Jan Feb Mar Apr
Units 5 4 3 6
Dollar 55 35 40 67
with units and dollar as primary and secondary Y axis'.

My problem is that the two vertical bars for each month overlap each other.
How can I display the units bar and dollar bar for each month side by by side?

If you wish, you can call me at 215 375 4528 cell.

Thanks,

Kevin Si

Jai chander

The problem is typical in 2*2 set of data. That where there are 2 vertical
charts. After one chart is put on secondary axis, it get overlapped. Moreover
in the options the, overlap menu does not work. It work in more than 2 bars.

Is it some bug or there is solution. I have tried quite a bit. The only
option is change one bar into line. or begin with more than 2 bars and than
reduce it

 

[Tushar Mehta]

See
Graphical display of numbers that differ by a magnitude
http://www.tushar-mehta.com/excel/charts/plot magnitude differences.htm

Jai chander

The problem is typical in 2*2 set of data. That where there are 2 vertical
charts. After one chart is put on secondary axis, it get overlapped. Moreover
in the options the, overlap menu does not work. It work in more than 2 bars.

Is it some bug or there is solution. I have tried quite a bit. The only
option is change one bar into line. or begin with more than 2 bars and than
reduce it

Regards,

Tushar Mehta
Microsoft MVP Excel 2000-2008
www.tushar-mehta.com
Tutorials and add-ins for Excel, PowerPoint, and other products