Category axis problem

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?
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top