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

PowerPivot How to chart with contiguous time axis? 0
Chart problem: values in column A doen't show on x-axis 0
Scatter charts for name with two values 0
Trendline Not Appearing In Chart Problem ? 0
How to getting text labels to show up in scatter chart. 0
Bubble chart labels on x axis 2
Bizarre chart behaviour when changing axis cross at points 2
One extra x axis item that wont go away - can anyone help? 3

Top