Tags: cell, chart, control, dynamic, excel, microsoft, msdn, sensethat, software, titleof

dynamic chart title

On Microsoft » Microsoft Excel

3,656 words with 4 Comments; publish: Wed, 28 May 2008 14:05:00 GMT; (30646.88, « »)

Dont know if this has been asked before but, how do you make the title

of a chart dynamic? I want to control the title in a cell in the sense

that if i change the cell text, it would update the title in the chart.

I want to avoid clicking and editing the chart title every time.

Any help would be appreciated.

Message posted from http://www.mcse.ms/

All Comments

Leave a comment...

  • 4 Comments
    • Hi Pronto,

      See Jon Peltier's web site page:

      http://peltiertech.com/Excel/Charts/Dynamics.html

      Regards,

      Norman

      "pronto >" <<pronto.1aan03.excel.todaysummary.com.excelforum-nospam.com> wrote in message

      news:pronto.1aan03.excel.todaysummary.com.excelforum-nospam.com...

      > Dont know if this has been asked before but, how do you make the title

      > of a chart dynamic? I want to control the title in a cell in the sense

      > that if i change the cell text, it would update the title in the chart.

      > I want to avoid clicking and editing the chart title every time.

      > Any help would be appreciated.

      >

      > --

      > Message posted from http://www.mcse.ms/

      >

      #1; Wed, 28 May 2008 14:06:00 GMT
    • If the chart already has a title:

      --Click on the chart to select it

      --Select the chart title

      --Type an equal sign -- you'll see it appear in the formula bar

      (you don't need to click in the formula bar before typing)

      --Click on the cell that contains the text for the chart, e.g. C6

      --Press the Enter key.

      If the chart doesn't have a title:

      --Click on the chart to select it

      --Type an equal sign -- you'll see it appear in the formula bar

      (you don't need to click in the formula bar before typing)

      --Click on the cell that contains the text for the chart, e.g. C6

      --Press the Enter key.

      --Drag the text box from the centre of the chart to the top

      --Use the buttons on the formatting toolbar to format the text

      pronto < wrote:

      > Dont know if this has been asked before but, how do you make the title

      > of a chart dynamic? I want to control the title in a cell in the sense

      > that if i change the cell text, it would update the title in the chart.

      > I want to avoid clicking and editing the chart title every time.

      Debra Dalgleish

      Excel FAQ, Tips & Book List

      http://www.contextures.com/tiptech.html

      #3; Wed, 28 May 2008 14:08:00 GMT
    • Once you have the title on the chart, select it, then go to the formula bar

      and put in the formula

      =Sheet1!A1

      Now when you change the text in A1 of Sheet1, the chart title will change.

      Not sure that was covered in the link provided.

      Regards,

      Tom Ogilvy

      "pronto >" <<pronto.1aan03.excel.todaysummary.com.excelforum-nospam.com> wrote in message

      news:pronto.1aan03.excel.todaysummary.com.excelforum-nospam.com...

      > Dont know if this has been asked before but, how do you make the title

      > of a chart dynamic? I want to control the title in a cell in the sense

      > that if i change the cell text, it would update the title in the chart.

      > I want to avoid clicking and editing the chart title every time.

      > Any help would be appreciated.

      >

      > --

      > Message posted from http://www.mcse.ms/

      >

      #4; Wed, 28 May 2008 14:09:00 GMT