How do I make a graphic with non-numerical data on X axis ?

G

Guest

I would like to make a graphic with non-numerical data on X axis (e.g. names
of persons or cities). When I use the normal graphic construction procedure
in Excell, numbers are generated (1, 2, 3 ...) in place of the text of the X
axis column. can anyone help me? Thanks.
 
J

Jon Peltier

Select the chart, and choose Source Data from the Chart menu. Click on the
Series tab. Make sure the appropriate range is indicated in the Category (X)
Axis Labels box.

This cannot be done in an XY chart, but will work for Line, Column, and
other chart types.

- Jon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XY-charts with non numerical x axis 1
Make Y-axis values correspond to x- axis value 1
Can I use non-numeric x axis data in excel charts? 2
How can I make a scatter plot graph with a category x-axis? 0
Overlaying 2 Data Series with Different Time (X) Axis 3
Plot a time series on the x-axis and categories on the y-axis 3
graphing numerical values on the x-axis 2
Excel 2007: X-axis labeling 1

Top