software

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?--
digicat
------------------------------------------------------------------------
digicat's Profile: www.excelforum.com/member.php...oamp;userid=14920
View this thread: www.excelforum.com/showthread...hreadid=499471When 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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;digicatquot; gt; wrote in
message ...
gt;
gt; The data in column A in the table I want to use for a chart contains
gt; numeric values: 2000 - 2001 - 2002 - ...
gt; In the chart these don't show as labels for the x-axis, but as a series
gt; of data in the chart.
gt; Any way around this without changing all the values in coumn A into
gt; text?
gt;
gt;
gt; --
gt; digicat
gt; ------------------------------------------------------------------------
gt; digicat's Profile:
gt; www.excelforum.com/member.php...oamp;userid=14920
gt; View this thread: www.excelforum.com/showthread...hreadid=499471
gt;