Simple Graph

  • Thread starter Thread starter Gary Thomson
  • Start date Start date
G

Gary Thomson

This is probably the easiest problem ever posted, and I
have accomplished it before, but for some reason this
morning it is not working!!!

I want a simple graph - line at 45 degrees to the x-axis,
going through the points (0,0), (1.5,15) and (3.0,30). I
have 0,1.5 and 3.0 in cells A2:A4, and 0,15 and 30 in
cells B2:B4. What am I doing wrong? What needs to
be "Data Range" and "Values"???

Many Thanks
 
Brilliant, thanks, I now have the correct graph.

However, I only want the x-axis to label 0, 1.5 and 3;
Similarly, I only want the y-axis to show 0, 15 and 30.

Is there any way to do this? (The x-axis currently has a
step size of 0.5).
 
Yes, double click the axis and adjust the scales Major step value to 1.5
and 15 for the y axis.

Cheers
Andy
 
Ok, that workd Andy, thank you.

Further question - INstead of having the y-axis displaying
15 and 30, I want the labels to state (for 15) "One 15,000
tonne plant", and (for 30) "Two 15,000 tonne plants".

Is there a way to do this???
 
Back
Top