Thread: column titles
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default column titles

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
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Curtis Croulet" wrote in message
news:KnM3j.26664$XT.2929@trnddc01...
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?
--
Curtis Croulet
Temecula, California
33°27'59"N, 117°05'53"W