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
|