Titles referencing multiple cells

[geooil]

I have a single series chart and I am using two cells as the series nam
that I have placed as the graph title. I am setting up a template an
have multiple graphs referring to different months.

If A1 has the text May in in and B1 has the text June in it, is there
way that I can refer to them in the series name window so that I can
have it say "Expenses from May to June" ie "Expenses from A1 to B1"

Currently I have ='Sheet1'!$E$18:$E$19 but this only gives me "Ma
June"

Thanks for you hel

 

[Debra Dalgleish]

Calculate the title in another cell in the worksheet, then reference
that cell from the chart. For example, in cell E20:

="Expenses from " & E18 & " to " & E19

Select the chart, type an equal sign, and click on cell E20
Press the Enter key to see the text box.