software

Hello -

I'm working on a project and using an Excel Chart for the first time.

I need the numbers on the X axis to reflect specific numbers (1.1, 1.2, 1.3,
1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, etc.) for a total
of 26 different numbers. I cannot change them, and have tried looking up
quot;relabel x axisquot;, quot;name x axisquot; etc. Nothing seems to work.

All that I can get it to do is go from 1.0 to 26.0 - I can't figure out how
to customize the numbers displayed in the x axis of my chart. Can someone
please help me with this? I've spent hours trying to work it out and can't do
it alone.

Cheers and I look so forward to anyone's help.Hi,

To get those values to display you will need to fake the axis labels
using an additional data series and it's data labels.
Jon Peltier has an explanation of constructing arbitrary axes that you
should be able to adapt to your data.
peltiertech.com/Excel/Charts/ArbitraryAxis.html

You will need to add a set of x and y values where the x is the point
you want displayed (eg. 1.1, 1.2 etc) and the y values will all be zero.
Show the x value in the data label and change the data label alignment
to Below.

Cheers
Andy

CWriter81 wrote:
gt; Hello -
gt;
gt; I'm working on a project and using an Excel Chart for the first time.
gt;
gt; I need the numbers on the X axis to reflect specific numbers (1.1, 1.2, 1.3,
gt; 1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6, etc.) for a total
gt; of 26 different numbers. I cannot change them, and have tried looking up
gt; quot;relabel x axisquot;, quot;name x axisquot; etc. Nothing seems to work.
gt;
gt; All that I can get it to do is go from 1.0 to 26.0 - I can't figure out how
gt; to customize the numbers displayed in the x axis of my chart. Can someone
gt; please help me with this? I've spent hours trying to work it out and can't do
gt; it alone.
gt;
gt; Cheers and I look so forward to anyone's help.
gt;

--

Andy Pope, Microsoft MVP - Excel
www.andypope.info

This requires a simpler approach than Andy's suggestion.

If you want the numbers to show up as labels, without any regard to their
underlying value (i.e., consecutive labels 1.4 and 1.5 as far apart as
consecutive labels 1.5 and 2.1), have these values in a worksheet range
parallel to the Y values, and include them in the series data. To do this,
choose Source Data from the Chart menu, click on the Series tab, select the
series, click in the empty Category (X) Axis Labels box, and select the
range containing the labels.

If you want the X values to reflect the values in this range, make sure the
series uses this range as the X data, and use an XY chart, not a line chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
PeltierTech.com/
_______

quot;Andy Popequot; gt; wrote in message
...
gt; Hi,
gt;
gt; To get those values to display you will need to fake the axis labels using
gt; an additional data series and it's data labels.
gt; Jon Peltier has an explanation of constructing arbitrary axes that you
gt; should be able to adapt to your data.
gt; peltiertech.com/Excel/Charts/ArbitraryAxis.html
gt;
gt; You will need to add a set of x and y values where the x is the point you
gt; want displayed (eg. 1.1, 1.2 etc) and the y values will all be zero.
gt; Show the x value in the data label and change the data label alignment to
gt; Below.
gt;
gt; Cheers
gt; Andy
gt;
gt; CWriter81 wrote:
gt;gt; Hello - I'm working on a project and using an Excel Chart for the first
gt;gt; time. I need the numbers on the X axis to reflect specific numbers (1.1,
gt;gt; 1.2, 1.3, 1.4, 1.5, 2.1, 2.2, 2.3, 2.4, 3.1, 3.2, 3.3, 3.4, 3.5, 3.6,
gt;gt; etc.) for a total of 26 different numbers. I cannot change them, and have
gt;gt; tried looking up quot;relabel x axisquot;, quot;name x axisquot; etc. Nothing seems to
gt;gt; work. All that I can get it to do is go from 1.0 to 26.0 - I can't figure
gt;gt; out how to customize the numbers displayed in the x axis of my chart. Can
gt;gt; someone please help me with this? I've spent hours trying to work it out
gt;gt; and can't do it alone. Cheers and I look so forward to anyone's help.
gt;
gt; --
gt;
gt; Andy Pope, Microsoft MVP - Excel
gt; www.andypope.info