Column Charts Axis Labels - Not showing all of them

[exkris]

I had a column chart with 90 columns on it and every value for the X axis was present. I had to add another ~20 and now only every second X axis value is displayed. I have:

1) Reduced the size of the text to see if that would show the missing values, nope.
2) Under axis options, the value "Specify interval unit" is equal to 1.


Is there any way I can show each X axis value or is this a limitation of excel column charts?

 

[Hermanito]

Which Excel version do you use?

 

[exkris]

2007

 

[Hermanito]

I don't have that version on this PC (only 2010 on this one), but when you say the Interval is set to 1, did you make sure this was actually the selected setting? Excel 2010 also has an automatic setting, to be selected with a radiobutton between those two...

Make sure the setting of 1 in the Interval is active, because that is what seems to be the issue I think...

In Excel 2003, I think it's a checkbox, if the box is checked, it's set to automatic mode, uncheck it to force it to use the value you entered...

 

[exkris]

Yeah I've tried both automatic, interval to 1, resize the text, realign the text....

 

[Hermanito]

Strange, if it's not set to automatic it should show all labels...
90 labels is not an issue, they should be shown easily.

Can you upload the file somewhere and post a link, then I can have a look?

 

[exkris]

Ah.... I don't think I can do that... I am contracting to an oil company and the file has lots of costs, history and vendor lists involved.

I think I am going to have to chalk this one up as a limitation to Excel, unfortunately.

 

[Hermanito]

It surely isn't a limitation of Excel, I've had charts with more than 100 labels, no problem.
I understand you cannot send the file. Try for yourself in an empty Excelfile:
- create random data, e.g. 100 rows of it
LABEL - DATA
Lbl1 - 12
Lbl2 - 23
etcetera

Make a chart of it and experiment with the labels, you should easily be able to make them all show.

 

[exkris]

I have 5 of these charts, all of them to print on 11x17 and they all do the same thing... I wonder if its because of 2007? Might have to see if someone around the office has 2010 installed.

 

[Hermanito]

On my other PC now, with 2007 on it...

I feel your pain now... I have been able to reproduce your problem, and I did not yet find a way to force Excel to show all the labels, though it should, according to how the settings are...

I hope it's a bit of a relief to know you are not going crazy, the problem really exists

I will try some more, and if I find a solution, I will of course post it here...