| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capturing chart title from cell | Charts and Charting in Excel | |||
| Can I have a value in a chart title that references a cell? | Excel Discussion (Misc queries) | |||
| Chart title = cell contects | Charts and Charting in Excel | |||
| Pasting Objects into Chart title and Axis title | Charts and Charting in Excel | |||
| how to cell reference a Chart title | Charts and Charting in Excel | |||
Linear Mode
