Chart problem: values in column A don't show as labels on x-axis

D

digicat

The data in column A in the table I want to use for a chart contains
numeric values: 2000 - 2001 - 2002 - ...
In the chart these don't show as labels for the x-axis, but as a series
of data in the chart.
Any way around this without changing all the values in coumn A into
text?
 
B

Bernard Liengme

When the x-categories can be mistaken for numbers, that is what Excel does.
Try removing the heading from the top of that column (but not from the
y-values); select the heading and the data to make the chart.
Excel should now find x-category values
best wishes
 

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

Bubble chart labels on x axis 2
Don't want to show X axis labels. 2
Replacing numeric X-axis labels with corresponding text string 2
Line chart - Change the Axis round 1
Display data values in columns on bar chart 1
Chart X-Axis in reverse order! 1
Bizarre chart behaviour when changing axis cross at points 2
charts look different if you put in data into the x axis 3

Top