numeric values in a chart

[kurtz]

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

 

[Jon Peltier]

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

 

[kurtz]

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
_______





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

 

[Jon Peltier]

Calculate the value in a cell, then use the protocol I described to display
it in a textbox.

- Jon

 

[kurtz]

It works nicely. Thanks a lot!

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
_______