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.
http://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:
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
"relabel x axis", "name x axis" 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.
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info