Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am not able to wrap the text of x-axis labels on an excel 2007 bar PivotChart. As a result, the axis labels are overlapping onto eachother. Does anyone know how can I wrap these labels?

share|improve this question
An image showing the problem may help. – pnuts Mar 12 '13 at 3:17

By Bar Chart I assume you mean, a chart with some discrete categories on the Y axis, some continuous value on the X axis, with bars going left-to-right.

If so, you can control how many labels get put on the X axis by right-clicking the X axis and choosing Format Axis..., then for Major Unit choosing Fixed and typing a value larger than the value that was automatically chosen by Excel.

If you can't do this, it might be that your x axis is made of discrete categories rather than numerical values. If so, Bar chart format may not be the best choice for your data. Or, you need a way to express your X axis values as a continuous number rather than discrete values.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.