View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Paul Wilson Paul Wilson is offline
external usenet poster
 
Posts: 12
Default How do I start a chart at 150, instead of 0?

Hi,

If you have let Excel do most of the work in setting up the chart, then hold
the mouse pointer over the axis you want to change and right-click. Choose
the option Format Axis. In the dialog box which appears select the second
page headed Scale. First remove the ticks in the auto boxes particularly
for Minimum and Maximum values. Put in the max and min values you want and
click ok. Play around with the other values if you wish too.

Regards

Paul


"re" wrote in message
...
My data is in the arnge of 150-250. How do I start my chart at 150,
instead
of zero? I'm cahrting data values against dates(months).