Using part of a cell in a chart title
 

I have a chart which should get a title. However, this should be partly be
used from a cell e.g.

"counted with 5%"

5% should be taken from the cell and used in the title.

Is this possible?

Using part of a cell in a chart title
 

Hi,

Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
http://www.andypope.info/tips/tip001.htm

Cheers
Andy
--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Nicole" wrote in message
...
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.

"counted with 5%"

5% should be taken from the cell and used in the title.

Is this possible?