Any one good at excel?

Question

I need to plot lines from a data row on a chart in excel 2003 (y axis) I also need to keep the scale on the graph 1.2.3.4...etc any one any ideas ive been trying for ages thanks

Answer 1

1. right click on the side of the plot area(gray by default) where the horizontal black line meets the border(then a column of tiny black square appear), a little pop up shows, then choose format gridlines,

2. scale tab, major unit, put a 1 on the right box, make sure the check box is unchecked, click ok button

Then your Y axis will always show a grid in interval of 1, hope this helps.