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 have a pivot table of names (1st column) and corresponding data (2nd column). I want to create a bar chart that places a label on every bar, regardless of whether excel thinks it will fit or not.

Here is what I have done:

  1. Insert->Pivot Chart
  2. Click Clustered Column
  3. Right-click on graph, select Format Axis
  4. set specify unit interval to 1

Excel now just labels every 2nd bar, even though it would easily fit (I have about 150 bars) with the given label font size. Even though I have selected 1, it has the same text density as if I set specify unit interval to 2.

How do I force it to 1?

share|improve this question
    
What happens if you change the size of the chart? –  guitarthrower Feb 3 at 21:56
    
@guitarthrower no effect as far as I can tell... –  quant Feb 4 at 3:50

1 Answer 1

up vote 1 down vote accepted

I just tried, and got the same thing. So I tried reducing the number of bars to see if there was a limit. I reduced the number of bars to 100 and all the labels show up. Added one more, and they only show every other label.

I also tried with a normal chart (not a pivot chart) and got the same results. 100 labels = OK. 101 = No Go.

It appears you have found a limitation in Excel.

share|improve this answer

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.