News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Excel 365 – Use Formula In Chart Title

    Home Forums AskWoody support Productivity software by function MS Excel and spreadsheet help Excel 365 – Use Formula In Chart Title

    Viewing 3 reply threads
    • Author
      • #517549 Reply
        AskWoody Lounger

        I was trying to use this formula in an Excel 365 chart title:
        =”Total Participation: ” & Modules!D26 & ” Surveys”

        Apparently you cannot directly enter a formula into a chart title in this version of Excel but you can reference a cell that contains a formula. I supposed I could enter this formula in a cell behind the chart so it cant be seen…

        Am I doomed?

      • #560052 Reply

        What error message did you get?  There’s some symbols/special characters that can’t be used in a file name.  Adding to that is some programs using a part of the beginning text in a document as the default file name.  Some examples:

        Before you wonder "Am I doing things right," ask "Am I doing the right things?"
      • #585645 Reply
        AskWoody Lounger

        Berton – thank you for your response.  I am getting no error message.

        When entering a formula directly into a Chart Title box/label you get what you type as text (see upper image).

        The workaround (lower image) is to click in the Chart Title to select it, then in the formula bar enter a reference to a cell that does contain a formula – in this case A10.  The formula contained in A10 is shown below in row 11.

        What I ended up doing for my report was to enter the formula I wanted for the title in a cell then placed the chart in front of it.


      • #948377 Reply

        You can indeed only use references to ranges in the chart title formula. If you really need to avoid a helper cell though,  you can define a name that points to a cell, then use that name as the formula link in the chart title, before amending the name to refer to the formula you want to use. IMO, it’s simpler and better to just use a cell as it’s easier to maintain.

        1 user thanked author for this post.
    Viewing 3 reply threads

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Excel 365 – Use Formula In Chart Title

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