Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated titles for charts
I have 60 - 70 Charts that I need to develop. All of them will have the same
basic layout only with different data and titles. Is there a way for me to link the title of a chart back to a cell in a worksheet? This would allow me to just make one chart, duplicate it, and then modify the cell references for the data including the title. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automated titles for charts
When you crate your chart, don't use the chart title, or if you do, put
somethign in there just as a placeholder, since you'll be deleting it (that way the chart size will adjust to accomodate for the space). Delete your title box on the chart. Draw a text box where the title was. Whith your text box active, click in the formula window and type ='SheetName'!A1 where SheetName is the name of the sheet and A1 is the cell where the title resides. Whatever is in that cell will display in the text box, which can be formatted to look like a title. You must type that into the formula bar at the top. If you type it into the text box as if you were entering text, the box will display the formula, not the value in the referenced cell. HTH JonR "J. T. C." wrote: I have 60 - 70 Charts that I need to develop. All of them will have the same basic layout only with different data and titles. Is there a way for me to link the title of a chart back to a cell in a worksheet? This would allow me to just make one chart, duplicate it, and then modify the cell references for the data including the title. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automated task to present data in a graph form. | Charts and Charting in Excel | |||
how to make column titles float with the scroll bar | Excel Discussion (Misc queries) | |||
How to group similar column titles together???? | Excel Discussion (Misc queries) | |||
"print column titles" | Excel Discussion (Misc queries) | |||
print titles won't appear on some pages | Excel Discussion (Misc queries) |