Category axis problem

  • Thread starter Thread starter Giel Weysters
  • Start date Start date
G

Giel Weysters

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?
 
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
 
Back
Top