View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
kurtz kurtz is offline
external usenet poster
 
Posts: 3
Default 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