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

    This topic contains 3 replies, has 3 voices, and was last updated by

     debaser 3 weeks, 3 days ago.

    • Author
      Posts
    • #517549 Reply

      notbrl
      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

      Berton
      AskWoody_MVP

      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:

      https://www.mtu.edu/umc/services/digital/writing/characters-avoid/

      Before you wonder "Am I doing things right," ask "Am I doing the right things?"

    • #585645 Reply

      notbrl
      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.

      Title

      Attachments:
    • #948377 Reply

      debaser
      AskWoody_MVP

      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.

    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.

    Your information: