| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Y axis
If I have a chart that i want to switch the left values and scales on the Y
axis with the one on the right is there an easy way to do this? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis
To swap primary and secondary Y axes, you need to have both primary and
secondary X axes, at least temporarily. Format the scale of each horizontal axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for the other. Then if you needed to add it, remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... If I have a chart that i want to switch the left values and scales on the Y axis with the one on the right is there an easy way to do this? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis
I have tried several times to update the scale of the primary which is
percentage of shipments type (ie 50-100%) and the secondary is amt of shipments in millions (ie 0-45) with data like this Total Ship Count 36,467,496 32,039,170 Automated 31,986,666 27,818,094 Vendor Manual 4,098,784 3,859,498 CFSC/Ops Manual 382,046 361,578 When I update the percentage scale it just reverts right back to the original value as if I had not changed it. "Jon Peltier" wrote: To swap primary and secondary Y axes, you need to have both primary and secondary X axes, at least temporarily. Format the scale of each horizontal axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for the other. Then if you needed to add it, remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... If I have a chart that i want to switch the left values and scales on the Y axis with the one on the right is there an easy way to do this? |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis
Do you change the number, then check the box? The box says Auto, and
checking it lets Excel use whatever value it automatically calculates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... I have tried several times to update the scale of the primary which is percentage of shipments type (ie 50-100%) and the secondary is amt of shipments in millions (ie 0-45) with data like this Total Ship Count 36,467,496 32,039,170 Automated 31,986,666 27,818,094 Vendor Manual 4,098,784 3,859,498 CFSC/Ops Manual 382,046 361,578 When I update the percentage scale it just reverts right back to the original value as if I had not changed it. "Jon Peltier" wrote: To swap primary and secondary Y axes, you need to have both primary and secondary X axes, at least temporarily. Format the scale of each horizontal axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for the other. Then if you needed to add it, remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... If I have a chart that i want to switch the left values and scales on the Y axis with the one on the right is there an easy way to do this? |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis
That helped. One more thing the display units is not opened up so I can
change that. How can I update it so I can change it to say millions? "Jon Peltier" wrote: Do you change the number, then check the box? The box says Auto, and checking it lets Excel use whatever value it automatically calculates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... I have tried several times to update the scale of the primary which is percentage of shipments type (ie 50-100%) and the secondary is amt of shipments in millions (ie 0-45) with data like this Total Ship Count 36,467,496 32,039,170 Automated 31,986,666 27,818,094 Vendor Manual 4,098,784 3,859,498 CFSC/Ops Manual 382,046 361,578 When I update the percentage scale it just reverts right back to the original value as if I had not changed it. "Jon Peltier" wrote: To swap primary and secondary Y axes, you need to have both primary and secondary X axes, at least temporarily. Format the scale of each horizontal axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for the other. Then if you needed to add it, remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... If I have a chart that i want to switch the left values and scales on the Y axis with the one on the right is there an easy way to do this? |
|
#6
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Y axis
I never use the display units. I use a number format that suppresses the
extra digits (put a comma at the end for each set of three zeros to omit), and add the appropriate text to the axis title. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... That helped. One more thing the display units is not opened up so I can change that. How can I update it so I can change it to say millions? "Jon Peltier" wrote: Do you change the number, then check the box? The box says Auto, and checking it lets Excel use whatever value it automatically calculates. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... I have tried several times to update the scale of the primary which is percentage of shipments type (ie 50-100%) and the secondary is amt of shipments in millions (ie 0-45) with data like this Total Ship Count 36,467,496 32,039,170 Automated 31,986,666 27,818,094 Vendor Manual 4,098,784 3,859,498 CFSC/Ops Manual 382,046 361,578 When I update the percentage scale it just reverts right back to the original value as if I had not changed it. "Jon Peltier" wrote: To swap primary and secondary Y axes, you need to have both primary and secondary X axes, at least temporarily. Format the scale of each horizontal axis, checking Value Y Axis Crosses at Maximum for one, unchecking it for the other. Then if you needed to add it, remove the secondary category axis. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "TXDalessandros" wrote in message ... If I have a chart that i want to switch the left values and scales on the Y axis with the one on the right is there an easy way to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
| TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
| can I make the vertical axis the category axis in Excel line graph | Charts and Charting in Excel | |||
| How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
| Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel | |||
Linear Mode
