#1   Report Post  
Posted to microsoft.public.excel.newusers
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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   Report Post  
Posted to microsoft.public.excel.newusers
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Goal line or target line to Excell 2007 Chart hawaiiham2000 Charts and Charting in Excel 5 October 2nd 09 05:35 PM
How to change bar to line in line-column on 2 axes chart in Excel2 jaysan3 Charts and Charting in Excel 2 July 2nd 08 11:13 AM
change last serie to be line in the line-column Excel chart in Wor Eric Charts and Charting in Excel 3 June 30th 07 04:58 PM
Getting line on line chart to display after creation from Pivot Table dcsi_jim Charts and Charting in Excel 8 February 6th 07 08:54 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM


All times are GMT +1. The time now is 09:41 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"