• Chart title linked to cells (Excel 2000)

    Home » Forums » AskWoody support » Productivity software by function » MS Excel and spreadsheet help » Chart title linked to cells (Excel 2000)

    Author
    Topic
    #383015

    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.

    Viewing 0 reply threads
    Author
    Replies
    • #651554

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

      Andrew C

      • #651555

        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.

    Viewing 0 reply threads
    Reply To: Chart title linked to cells (Excel 2000)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: