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

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

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

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

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