Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Chart title linked to cells (Excel 2000)

    Hello,

    Is there a way to have a chart title be linked to two cells? I know it can be linked to one cell (ex. =Sheet1!$A$209), however I might have data that it in two different cells, and I cannot construct the formula. I've tried:
    =Sheet1!$A$209 & "" & Sheet1!$A$210 and some other similar versions, which do not work.
    I also tried to make a separate textbox below the title of the chart with link to the second cell, but the chart will not print that text box, as it is not part of the chart itself.

    Thanks in advance!
    K.

  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 cells (Excel 2000)

    Could you combine the contents of the cells in a single unused cell and then point your chart title at that cell ?

    Andrew C

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    107
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Chart title linked to cells (Excel 2000)

    Hm, that is also a solution, haven't thought of it, thanks a lot.

    I found meanwhile something else that works, I used the Y Axis value and linked the second cell to that. Then just repositioned it and it prints now fine.

    Thanks again,
    K.

Posting Permissions

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