Category axis problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Giel Weysters - 28 Nov 2003 16:54 GMT

I use Excel 97.
I have a chart based on two columns, one column ranges from 0 to 360
(catagery axis), the other has different values from 20 to 90 (value axis).
I can't get the catagery axis to start from 0 (zero)
It starts from 1, which is very disturbing.
The problem starts with the menue "Axis lay-out".
In the sub-menu Scale, the first field asks for: "Value axix (Y) crosses by
category number: ?
I would like it to cross at 0, but the systems insists that the number
should at least be 1.
Consequently, the labels at the category axis start at 1.

Maybe the names of menues and field are somewhat different in the english
language, because I had to translate from Dutch.
Can anybody help me out?

Reply to this Message

Jon Peltier - 29 Nov 2003 04:52 GMT

Giel -

I suspect you have created a Line chart (third choice in the left list
in the chart wizard), when you really want an XY Scatter chart (fifth
choice). The difference is in the category axis, not in the ability to
display lines connecting the points. Right click on the chart, choose
Chart Type from the pop up menu, and change to an XY Scatter chart. For
more information about this topic, see my web pages:

X Axis: Category or Value?
http://www.geocities.com/jonpeltier/Excel/Charts/CatVsValueAxis.html

Scatter Chart or Line Chart?
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=190

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

> I use Excel 97.
> I have a chart based on two columns, one column ranges from 0 to 360
[quoted text clipped - 11 lines]
> language, because I had to translate from Dutch.
> Can anybody help me out?

Reply to this Message