Bars Stack when Selecting Secondary Axis

[jbeardslee]

I have a simple Bar Chart with two series. Series one is Days and Series two is in Minutes.
I want to add a Secondary vert axis on theright for the minutes. But when I do the two bars stack on top of each other.
How can I do this without having the bars stack up?

Average Calls per Day 30.0 Days
Average time per Call 9.8 Minutes

Image1.jpg
Image2.jpg

[jbeardslee]

No Replies from the Excel Experts...

Here is what I figured out.

Data...
Average Calls per Day 30.0 Count
Average time per Call 9.8 Minutes

Procedure...

Select First Series
Insert 2D Column Chart
Select Data
Add Second Series
Select Second Column and Format Data Series
Select Seondary Axis
Select Data
Add Third Series Same data as First
Add Fourth Series Same data as Second
Select the Column for Second Series and Format Data Series
Set Fill and Border to none
Select the Column for Third Series and Format Data Series
Set Fill and Border to none
Select Horz axis, Labels, none
Delete unused legends
Add Axis Labels

Basically Setup 4 Series with the same Data and then hide two.

Only problem is that the Bars are off center to teh Right.

Image3.jpg