How to Show all X-Axis in Column or Bar Graph

[lexkhan]

Using Excel 2007!

I have 91 entries in Column A and B as follows:

Column A:
Name

Column B:
Age

I want to create a graph based on 91 entries but Column or Bar Graph only shows 45-50 names in X-axis. How can i make all 91 names appear in Column or Bar Graph?

Please help!

 

[tusharm]

There is an option in the axis format dialog box to control the number of categories (Interval between labels, I believe). Change it to 1.

 

[lexkhan]

Thank you so much!