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

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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
 
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.
 
Kevin said:
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
Click to expand...
 
Kevin said:
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
Click to expand...


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
 
Back
Top