Excel 365 – Use Formula In Chart Title

Topic

New Reply

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?

Reply | Quote

Replies

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?"

Reply | Quote

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.

Reply | Quote

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.

notbrl

Reply | Quote