column titles

  • Thread starter Thread starter Curtis Croulet
  • Start date Start date
C

Curtis Croulet

I have a column chart. Excel has automatically inserted consecutive numbers
underneath the columns. I want to replace these with text, unique labels
for each column. I thought this would be an ultra-simple, ultra-intuitive
task, but I can't find anywhere to do it in Excel, and I can't find anything
on the web. How do I replace Excel's default numbers with text?
 
You need to set the data out like this

north 23
east 45
south 12
east 24

and make your chart using all this data; the names (North, etc) will be the
x-axis labels. You have no x-values so Excel provided 1,2,3
best wishes
 
If you don't want to reconstruct the chart, go to Chart menu > Source Data >
Series tab, select the series from the listbox, then click in the Category
(X axis) Labels box, and select the range containing the axis labels.

- Jon
 
You must log in or register to reply here.

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

Why can't I see the data labels I just added? 6
Dynamic Chart Title With 3D Stacked Column Chart 2
make column headings automatically appear as axis chart labels 1
Can I make a "tab name" the "chart title"? (question on this) 2
Gridlines on Column Chart 5
making a chart complicated 1
How do I update charts in excel 2007 2
Automatic Axis Titles in Excel 2007 4

Back
Top