Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
column titles
1 view
Skip to first unread message
Curtis Croulet
Nov 29, 2007, 11:32:42 PM11/29/07
to
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
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
Bernard Liengme
Nov 30, 2007, 8:04:07 AM11/30/07
to
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" <calypte@_NO_SPAM_verizon.net> wrote in message
news:KnM3j.26664$XT.2929@trnddc01...
Jon Peltier
Dec 1, 2007, 5:46:44 PM12/1/07
to
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.
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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______
"Bernard Liengme" <blie...@stfx.TRUENORTH.ca> wrote in message
news:%2342t%23F1MI...@TK2MSFTNGP06.phx.gbl...
0 new messages