| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
numeric values in a chart
I need to display a value from the spreadsheet into a chart (for example
values that are not captured by the chart). I tried with the camera and the copy link images but it did not work |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
numeric values in a chart
You mean as a text label? Select the chart, click in the formula bar, type
=, then select the cell with the value and hit Enter. A textbox will appear in the middle of the chart linked to the cell. Move and format it as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... I need to display a value from the spreadsheet into a chart (for example values that are not captured by the chart). I tried with the camera and the copy link images but it did not work |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
numeric values in a chart
"Jon Peltier" wrote: You mean as a text label? Select the chart, click in the formula bar, type =, then select the cell with the value and hit Enter. A textbox will appear in the middle of the chart linked to the cell. Move and format it as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... I need to display a value from the spreadsheet into a chart (for example values that are not captured by the chart). I tried with the camera and the copy link images but it did not work Not exactly. Suppose I'm dispalyn a line chart with the % yeraly change of us population. I need to display (and automatically update) the absolute value (not the%) of the population in the last two years |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
numeric values in a chart
Calculate the value in a cell, then use the protocol I described to display
it in a textbox. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... "Jon Peltier" wrote: You mean as a text label? Select the chart, click in the formula bar, type =, then select the cell with the value and hit Enter. A textbox will appear in the middle of the chart linked to the cell. Move and format it as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... I need to display a value from the spreadsheet into a chart (for example values that are not captured by the chart). I tried with the camera and the copy link images but it did not work Not exactly. Suppose I'm dispalyn a line chart with the % yeraly change of us population. I need to display (and automatically update) the absolute value (not the%) of the population in the last two years |
|
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
numeric values in a chart
It works nicely. Thanks a lot! "Jon Peltier" wrote: Calculate the value in a cell, then use the protocol I described to display it in a textbox. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... "Jon Peltier" wrote: You mean as a text label? Select the chart, click in the formula bar, type =, then select the cell with the value and hit Enter. A textbox will appear in the middle of the chart linked to the cell. Move and format it as needed. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "kurtz" wrote in message ... I need to display a value from the spreadsheet into a chart (for example values that are not captured by the chart). I tried with the camera and the copy link images but it did not work Not exactly. Suppose I'm dispalyn a line chart with the % yeraly change of us population. I need to display (and automatically update) the absolute value (not the%) of the population in the last two years |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| How do I display non-numeric values in a scatter chart? | Charts and Charting in Excel | |||
| how do i show non-numeric values graphically in a chart? | Charts and Charting in Excel | |||
| Return Numeric Labels that have different Numeric Values | Excel Worksheet Functions | |||
| Text values to numeric values | Excel Discussion (Misc queries) | |||
Linear Mode
