Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I start a chart at 150, instead of 0?
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). |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I start a chart at 150, instead of 0?
Right-click on the vertical axis Format axis Scale tab
Uncheck the Auto-Min box, key in your start value OK -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "re" wrote: My data is in the range of 150-250. How do I start my chart at 150, instead of zero? I'm charting data values against dates(months). |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I start a chart at 150, instead of 0?
From within the chart use the "scale" option. set minimum to 150?? or what
ever you want instead of auto. "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). |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I start a chart at 150, instead of 0?
On Sun, 25 Jan 2009 15:26:06 -0800, re wrote:
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). Right-click the axis; select Format Axis; then set your minimum amount manually instead of "automatic". --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 Names - Why can't it start with Chart? | Charts and Charting in Excel | |||
Chart Start and End Dates ~ | Charts and Charting in Excel | |||
In a GANTT, how do I get diff projects to start later on chart | Charts and Charting in Excel | |||
make line in chart start at y axis | Charts and Charting in Excel | |||
How to chart start and stop times | Charts and Charting in Excel |