If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Problem with Y-Axis Scale
Hi Everyone
Whenever I create a chart (a line chart in this case), the Y-Axis scale is absurd. Here's an example: X-values: 1 2 3 4 5 Y-Values: 10 20 30 40 50 When I chart these data points the Y-axis scale ranges from 1,110,000 - 1,140,000. I know I can change the scale, but I don't want to do this everytime I create a chart. Does anyone know what's going on? Is there a setting I can change in Excel or is it just something with my computer. Any help would be great! Thanks in advance. |
#2
|
|||
|
|||
Problem with Y-Axis Scale
I suspect you have inadvertently defined a chart as your default chart,
and this chart had that goofy Y axis scale. To get rid of a bad default chart type: Select any chart, go to Chart Type on the Chart menu. Click on the Custom Types tab, then click the User-Defined option button at the bottom. Select the Default item in the left column, and press Delete. The default default will now appear in the list; it's a plain vanilla column chart. - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ BMunny wrote: Hi Everyone Whenever I create a chart (a line chart in this case), the Y-Axis scale is absurd. Here's an example: X-values: 1 2 3 4 5 Y-Values: 10 20 30 40 50 When I chart these data points the Y-axis scale ranges from 1,110,000 - 1,140,000. I know I can change the scale, but I don't want to do this everytime I create a chart. Does anyone know what's going on? Is there a setting I can change in Excel or is it just something with my computer. Any help would be great! Thanks in advance. |
Thread Tools | |
Display Modes | |
|
|