Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Line Chart
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Goal line or target line to Excell 2007 Chart | Charts and Charting in Excel | |||
How to change bar to line in line-column on 2 axes chart in Excel2 | Charts and Charting in Excel | |||
change last serie to be line in the line-column Excel chart in Wor | Charts and Charting in Excel | |||
Getting line on line chart to display after creation from Pivot Table | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) |