Titles referencing multiple cells

  • Thread starter Thread starter geooil
  • Start date Start date
G

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
 
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.
 
Back
Top