Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Chart Title
Is it possible to refer back to a cell for part or all of the Chart Title?
Also, is the same possible when naming worksheets? |
#2
|
|||
|
|||
righlcick chart-click sorucedata. choose series-,in the existing series go
to the line<name click the icon and click the cell where the name is located hit enter and click ok . now see the chart. is the new title shown? you can also write a vba reg sheetname you can add this code statement in vba activesheet.name=range("I3") I3 is cell where the name is located. LDanix wrote in message ... Is it possible to refer back to a cell for part or all of the Chart Title? Also, is the same possible when naming worksheets? |
#3
|
|||
|
|||
Hi,
You can link all of the chart title to a cell. Click the chart title and then in the formula bar enter = now click the cell with the chart title in it and press enter. This works for data labels as well. Cheers Andy LDanix wrote: Is it possible to refer back to a cell for part or all of the Chart Title? Also, is the same possible when naming worksheets? -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Relative Chart Title? | Charts and Charting in Excel | |||
Problem with Chart Title Formatting | Charts and Charting in Excel | |||
how to cell reference a Chart title | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |