Naming the graph title based on first and last slicer item

[RobbertH]

How would i go about titling my (pivot)graph based on the first and last item selected through a slicer.

Basicall the slicer allows the user to select the data range the graph is based on and i want to show the selection in the title of the graph.

Hope you can help! Thanks

 

[oldbrewer]

I only know how to put a text cell in a chart - that could reference a cell that itself references your slicers.

 

[RobbertH]

That would be a workaround but how do i get the first item of the slicer in a cell, and idem the last?

 

[oldbrewer]

Your user selects the data range - say he enters 3 in A1 and 10 in B1

in a spare cell put =concatenate("graph of xxxxxx for values between ", A1, " and ",B1)

set up the text cell in the chart and make it equal the cell with the concatenate formula