Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart title and text formula?
I have a series of charts that I'd like to create a title for using the left
function. I'd like the chart titles to be the result of =LEFT(B7,7). I know how to pull the full contents of a cell but thought of saving a step to avoid doing this as a separate cell formula and point the chart title to that. Any ideas? Thanks!!! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Dynamic Chart title and text formula?
The formulas in the chart's text elements can only be link formulas.
Splurge and use the extra cell, it doesn't cost much. - Jon ------- Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 4/15/2010 4:40 PM, Cecilia wrote: I have a series of charts that I'd like to create a title for using the left function. I'd like the chart titles to be the result of =LEFT(B7,7). I know how to pull the full contents of a cell but thought of saving a step to avoid doing this as a separate cell formula and point the chart title to that. Any ideas? Thanks!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Chart Title With 3D Stacked Column Chart | Charts and Charting in Excel | |||
Dynamic chart title | Charts and Charting in Excel | |||
Dynamic Chart Title? | Charts and Charting in Excel | |||
Dynamic updating of chart title | Charts and Charting in Excel | |||
dynamic chart title text | Excel Discussion (Misc queries) |