Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart How do I create Y axis to represent numbers I am using
I am attempting to create a chart that is populating its data from another
worksheet in the same book. I am pulling in numbers that range from 75000 to 3000000 and I would like my y axis to be 50K to 350K in multiples of 25K but I can not figure out how to adjust the axis key. Thanks for your help in advance. Krefty |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart How do I create Y axis to represent numbers I am using
Select the axis and press Ctrl+1 (numeral one).
Excel 2003 and earlier: In the dialog that appears, click on the Scale tab, and enter the values you want for min, max, and major unit, and don't check the corresponding Auto boxes. Excel 2007: Check Fixed for each of min, max, and major unit, and enter the values you want in the boxes. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Krefty" wrote in message ... I am attempting to create a chart that is populating its data from another worksheet in the same book. I am pulling in numbers that range from 75000 to 3000000 and I would like my y axis to be 50K to 350K in multiples of 25K but I can not figure out how to adjust the axis key. Thanks for your help in advance. Krefty |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Excel Chart How do I create Y axis to represent numbers I am using
Right-click on the axis and it will give you a "Format axis" option. In
there, choose the Scale tab. -- David Biddulph "Krefty" wrote in message ... I am attempting to create a chart that is populating its data from another worksheet in the same book. I am pulling in numbers that range from 75000 to 3000000 and I would like my y axis to be 50K to 350K in multiples of 25K but I can not figure out how to adjust the axis key. Thanks for your help in advance. Krefty |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
how do I create a stacked bar chart on 2 axis | Charts and Charting in Excel | |||
how do i create a bar chart that has 2 y axis instead of one? | Charts and Charting in Excel | |||
How do I create a chart where there are two Y axis and the bars ar | Charts and Charting in Excel | |||
How do I create more than two Y axis in a chart? | Charts and Charting in Excel |