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?


0
Nicole (56)
5/15/2007 8:01:02 AM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
700 Views

Similar Articles

[PageSpeed] 20

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" <Nicole@discussions.microsoft.com> wrote in message 
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@microsoft.com...
>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?
>
> 

0
andy9699 (3616)
5/15/2007 8:44:23 AM
Reply:

Similar Artilces: