Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart title linked to a cell (Excel 97/2000)

    I need to create a series of charts where the title will change regularly. Is it possible to have the chart title linked to the contents of the cell?

    Thanks!

    Larry

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Chart title linked to a cell (Excel 97/2000)

    Create you chart as normal, and enter a dummy title. When you have everything in place follow these steps :

    1 Select the Chart Title,

    2 with the title selected, place an = sign in the formula Bar

    3 then Click on the Cell that you intend to hold the title.

    Your chart should now have the contents of that cell as the title. You can apply independent formatting to your title

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Apr 2001
    Location
    Chapel Hill, North Carolina, USA
    Posts
    138
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart title linked to a cell (Excel 97/2000)

    Andrew -

    Thanks it!!!!!!!!!! Thank you very, very much

    Larry

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •