How to use Formulas in Chart Title and X&Y Axis

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

Frank Kabel

Hi
- select the title textbox
- click in the formula bar (Important9
- enter the formula directly in the formula bar (NOT in the textbox
itself)
 
How can I use formulas in the chart titles?
Example: I want the chart title to be the result of the following formula:
="Sales for the Years "&C4&" to "&C5
where C4 and C5 are variable.
 
You can use a cell reference in the chart title, but not a formula, so
create the title text in a worksheet cell, then refer to that. For
example, in cell C6, enter your formula:
="Sales for the Years " & C4 & " to " & C5

Then, click on the chart to select it
Select the chart title
Type an equal sign -- you'll see it appear in the formula bar
Click on the cell that contains the text for the chart, e.g. C6
Press the Enter key.
 
Back
Top