Fixed numbers on Y axis

[Eva_]

I have looked through previous mail on this site, but did not find any solution to my problem; hence I try sending this in hope for some help.

I need to put below range of number into a chart. The Tube Diameter on the Y axis - but I need the numbers fixed exactly as they are. Is that possible? Only options I get in Excel is steps of 10, 100, 1000 etc.

Do hope to hear from someone soon. Thanks beforhand...

Tube Diameter Meter
219,1 10.000
273,0 10.000
323,9 7.000
355,6 5.000
406,4 5.000
457,0 3.000
508,0 3.000
610,0 3.000
711,0 2.000
813,0 2.000
914,0 1.000
1016,0 1.000
1220,0 1.000

[Carim]

Hi,

Take a look at Jon' s proposal ...
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

[Eva_]

Hi Carim,

If only I could use the X axis for category as the examples is the link you sent to me shows. However the problem is, that I need the Y axis to do this, and I could not find any help for this on the site you sent me. As you see the categories below have unregular steps, which collidates with the steps you can choose for the Y axis.

I know how to do it, when the X axis is used to show the category. However my task is to get the Y axis to do the job.

219,1
273,0
323,9
355,6
406,4
457,0
508,0
610,0
711,0
813,0
914,0
1016,0
1220,0

[Eva_]

Did a closer study of the link Carim sent to me and found the needed help on this page:

http://peltiertech.com/Excel/Charts/Y_CategoryAxis.html

All the best
Eva

[Carim]

Glad you could fix your problem

Thanks for sharing the solution ...