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

Jon tells all at
http://peltiertech.com/Excel/Charts/...OnTwoAxes.html
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kevin" wrote in message
...
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.
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Kevin" wrote:

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

"Kevin" wrote:

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

"Kevin" wrote:

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

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

On Sat, 18 Jul 2009 06:33:01 -0700, jaichander
wrote:



"Kevin" wrote:

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

Regards,

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