Share via

Excel 2010 Bar Chart, Bars width changes when a 2nd Axis is added

Anonymous
2014-02-28T22:13:11+00:00

I have a bar chart that I created that has 7 series, ordered by date. I wanted to add a second vertical axis for the Total Installs line element.  The first pic is the original chart, the second pic is what happened to the bars after I added the 2nd axis. Does anyone know why this happens and how to change the width of the bars in the chart?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

Answer accepted by question author

Anonymous
2014-03-01T00:45:51+00:00

Hi,

Excel is getting confused by the dates.  Not sure why.

You can fix it by double-clicking on the x-axis then selecting Axis Type: Text Axis.

Hope that helps.

Cheers

Rich

Was this answer helpful?

0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Anonymous
    2014-03-03T13:22:06+00:00

    Thank you sir. That actually worked like a champ.

    Was this answer helpful?

    0 comments No comments