Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

1 Answer

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
add comment

Your Answer

 
discard

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.