Displaying cell data in a chart
 

Previous posts indicate a successfuly method for displaying data/text from a
cell into a chart. Following this procedure, I select the chart, press the
equal sign, and select the cell, and then enter. The address of the sheet
and the cell address are displayed after the equal sign. When I press enter
nothing seems to happen. The data are supposed to display in the middle of
the chart, but I do not get any display of the data. I am in a Pivot Table
worksheet but did not directly insert a Pivot Chart. I used getpivotdata and
created new cells for plotting into the inserted column chart using that
data. I appear to be able to utilize all Excel charting funcgtions with
these charts. Am I missing something?

J. Austin

Displaying cell data in a chart
 

Hi,

By any chance are you using xl2007?
If so the type ='s does not work. You need to insert the textbox and then
use the formula bar to enter the cell reference.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"J Austin" wrote in message
...
Previous posts indicate a successfuly method for displaying data/text from
a
cell into a chart. Following this procedure, I select the chart, press
the
equal sign, and select the cell, and then enter. The address of the sheet
and the cell address are displayed after the equal sign. When I press
enter
nothing seems to happen. The data are supposed to display in the middle
of
the chart, but I do not get any display of the data. I am in a Pivot
Table
worksheet but did not directly insert a Pivot Chart. I used getpivotdata
and
created new cells for plotting into the inserted column chart using that
data. I appear to be able to utilize all Excel charting funcgtions with
these charts. Am I missing something?

J. Austin

Displaying cell data in a chart
 

Andy,
Thanks for the quick response. Yes, I am using xl2007. And your solution
worked great. Going to save me a lot of grief in updating a large number of
charts automatically.

Thanks again,

J.Austin

"Andy Pope" wrote:

Hi,

By any chance are you using xl2007?
If so the type ='s does not work. You need to insert the textbox and then
use the formula bar to enter the cell reference.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"J Austin" wrote in message
...
Previous posts indicate a successfuly method for displaying data/text from
a
cell into a chart. Following this procedure, I select the chart, press
the
equal sign, and select the cell, and then enter. The address of the sheet
and the cell address are displayed after the equal sign. When I press
enter
nothing seems to happen. The data are supposed to display in the middle
of
the chart, but I do not get any display of the data. I am in a Pivot
Table
worksheet but did not directly insert a Pivot Chart. I used getpivotdata
and
created new cells for plotting into the inserted column chart using that
data. I appear to be able to utilize all Excel charting funcgtions with
these charts. Am I missing something?

J. Austin