CODEWITHSUNDEEP
excelchartsexcel-formulacells
tralston
tralston

Reputation: 3045

Excel Chart Referencing Cell With Formula

I have a chart (a chart page, not an embedded chart) that I have a title for in Excel 2010. I want to reference a cell so that title changes based on that cell's value. Let's say that the cell is A1. I seen forums saying you can link a chart's title to a cell by clicking it, pressing "=" and clicking on the referenced cell. This works just fine until I want to make put a formula in the title.

Say A1 = "Time", and I set the chart title to =Sheet1!A1. The title updates to: Time. But if I want to make it more flexible, like ="It's about "&Sheet1!A1, I get an error:

The formula you typed contains an error. Try one of the following: ... [clipped]

Is the title field limited as to its input? Is there another way to accomplish this without VBA?

Upvotes: 1

Views: 2045

Answers (1)

chris neilsen
chris neilsen

Reputation: 53166

It would seem that the Title field can accept only a simple cell reference.

(also tried creating a named range with the required formula, without success)

An alternative is to create another cell with the required formula, and refer to that cell for the chart title.

Upvotes: 2

Related Questions