Thread: Line Chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Paul Paul is offline
external usenet poster
 
Posts: 49
Default Line Chart

Hover your mouse above each axis in turn.
Right-Click and select Format Axis.
Go to the Scale page, and uncheck the auto boxes.
Put in the values you feel are appropriate (Max, Min etc.) and click OK.

If the visual effect is not what you want, then repeat.



Regards
Paul




"Bob" wrote in message
...
I have the following data I want to chart:
8 12 16 36 64 100
Mtl Cost $15,207 $19,079 $22,950 $42,308 $69,408 $104,252
Engr Cost $16,640 $24,960 $33,280 $74,880 $133,120 $208,000

When I created the chart the upper bounds of the y axis is $350,000, and
the
Engr Cost series, although states it $208,000, it's above the $300,000.

What am I doing wrong.

Bob