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
|
|||
|
|||
Changing Millions to Thousands
Yesterday while poking and clicking around a graph I had created, I found a
box where you could change your number from millions to thousands. Today, I cant find it. In my Y axis's I have my number set in millions, and I want to change those numbers to thousands. It wasnt in the "Format Axix" box either. What and where is this box that has this feature? ps.. I love excel... 03 is great, and 07 is even better. The more I learn, the more I become addicted. |
#2
|
|||
|
|||
Changing Millions to Thousands
Hi,
Assuming you are using 2003 or earlier - 1. Double-click the Y-axis and choose the Scale tab 2. Open the Display Units drop down If this helps, please click the Yes button Cheers, Shane Devenshire "Wendy" wrote: Yesterday while poking and clicking around a graph I had created, I found a box where you could change your number from millions to thousands. Today, I cant find it. In my Y axis's I have my number set in millions, and I want to change those numbers to thousands. It wasnt in the "Format Axix" box either. What and where is this box that has this feature? ps.. I love excel... 03 is great, and 07 is even better. The more I learn, the more I become addicted. |
#3
|
|||
|
|||
Changing Millions to Thousands
Cool, thank you so much! Absolutely will click YES!
Cheers! "Shane Devenshire" wrote: Hi, Assuming you are using 2003 or earlier - 1. Double-click the Y-axis and choose the Scale tab 2. Open the Display Units drop down If this helps, please click the Yes button Cheers, Shane Devenshire "Wendy" wrote: Yesterday while poking and clicking around a graph I had created, I found a box where you could change your number from millions to thousands. Today, I cant find it. In my Y axis's I have my number set in millions, and I want to change those numbers to thousands. It wasnt in the "Format Axix" box either. What and where is this box that has this feature? ps.. I love excel... 03 is great, and 07 is even better. The more I learn, the more I become addicted. |
#4
|
|||
|
|||
Changing Millions to Thousands
Wendy -
In Excel 2007, select the axis and right-click, or directly right-click the axis, from the menu choose Format Axis | Axis Options | Display units, and select from the drop-down list. In Excel 2003, choose Format Axis | Scale | Display units. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "Wendy" wrote in message ... Yesterday while poking and clicking around a graph I had created, I found a box where you could change your number from millions to thousands. Today, I cant find it. In my Y axis's I have my number set in millions, and I want to change those numbers to thousands. It wasnt in the "Format Axix" box either. What and where is this box that has this feature? ps.. I love excel... 03 is great, and 07 is even better. The more I learn, the more I become addicted. |
Thread Tools | |
Display Modes | |
|
|