Home |
Search |
Today's Posts |
#1
|
|||
|
|||
minimum on chart
Hi
I have a line chart which plots data in the range 2100 - 3000 How do I stop the chart having a big blank area from 0 - 2000 ? thanks Mike |
#2
|
|||
|
|||
are you sure you don't have an x-y chart rather than a line chart?
if it is an X-Y chart you should be able to select the axis and select the limits if it is a line chart the data series must be immense. "mikey" wrote: Hi I have a line chart which plots data in the range 2100 - 3000 How do I stop the chart having a big blank area from 0 - 2000 ? thanks Mike |
#3
|
|||
|
|||
Even in an XY chart, if the minimum value is less than a certain
percentage (66%?) of the maximum value, Excel's scaling algorithm defaults to a minimum of zero. Double click the axis, and choose a more reasonable minimum value. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ bj wrote: are you sure you don't have an x-y chart rather than a line chart? if it is an X-Y chart you should be able to select the axis and select the limits if it is a line chart the data series must be immense. "mikey" wrote: Hi I have a line chart which plots data in the range 2100 - 3000 How do I stop the chart having a big blank area from 0 - 2000 ? thanks Mike |
#4
|
|||
|
|||
"Jon Peltier" wrote in message ... Double click the axis, and choose a more reasonable minimum value. - Jon Thank You, Jon - that was what I needed to know |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating a Chart object | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |