Line Chart

[Bob]

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

 

[Paul]

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