| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
limiting values shown in cell
I have a spreadhseet of numbers that the user inputs. That spreadsheet is
linked to another sheet in the workbook to create a chart. To control the scale I only want transfer the value of the 'thousands'.... example:(in $$) user input: $517,420 ---transfers to chart data sheet as : 517 user input: $19,872 ---transfers to chart data sheet as : 20 user input: $1,318,972 ---transfers to chart data sheet as : 1319 I know there is a way to do this, but obviously I am stumped! Thanks in advance for any help! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
limiting values shown in cell
Hi,
Maybe this =ROUND(A1/1000,0) Mike "stacy05" wrote: I have a spreadhseet of numbers that the user inputs. That spreadsheet is linked to another sheet in the workbook to create a chart. To control the scale I only want transfer the value of the 'thousands'.... example:(in $$) user input: $517,420 ---transfers to chart data sheet as : 517 user input: $19,872 ---transfers to chart data sheet as : 20 user input: $1,318,972 ---transfers to chart data sheet as : 1319 I know there is a way to do this, but obviously I am stumped! Thanks in advance for any help! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
limiting values shown in cell
Stacy,
I would leave the amounts in the chart data sheet as is. I would change the format of the amount/currency axis of the chart. Give it a custom number number format of "#,##0,". With this custom format, 517,420 will DISPLAY as 517 (WILL DISPLAY AS.... the actual value will still be 517,420 in case you need to use the actual value in calculations elsewhere) and 1,318,972 will display as 1,319. You can also format the value cells on the chart data sheet with the same format if you desire. HTH, Conan "stacy05" wrote in message ... I have a spreadhseet of numbers that the user inputs. That spreadsheet is linked to another sheet in the workbook to create a chart. To control the scale I only want transfer the value of the 'thousands'.... example:(in $$) user input: $517,420 ---transfers to chart data sheet as : 517 user input: $19,872 ---transfers to chart data sheet as : 20 user input: $1,318,972 ---transfers to chart data sheet as : 1319 I know there is a way to do this, but obviously I am stumped! Thanks in advance for any help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I ensure that in a chart zero(0) values are not shown ? | Charts and Charting in Excel | |||
| limiting the viewable space to the data shown | Excel Worksheet Functions | |||
| Column of Text Shown = Total Times Shown? | Excel Worksheet Functions | |||
| limiting cell value | Excel Discussion (Misc queries) | |||
| Named Ranges shown (or not shown) as blue means what? | Excel Worksheet Functions | |||
Linear Mode
