I have a slicer linked to a chart which allows me to select various months of the year (April through to March).
The chart title is populated via a linked cell which contains the following formula for producing From and To months:
=$L$1&CHAR(10)&TEXT($M$2,"mmm yyyy")&$L$3&TEXT($M$3,"mmm yyyy") to produce:
"Chart title text from"
"mmm yyyy to mmm yyyy".
When I select multiple months, the chart populates the title correctly ie
"Chart title text from"
"Apr 2019 to Jan 2020".
However, if I want to select only one month in the slicer, I'm looking for a way for the chart to reflect this single option and only display the month one time. Eg
Instead of
"Chart title text from"
"Apr 2019 to Apr 2019"
replace with
"Chart title text from"
"Apr 2019"
Anyone help me please?
Many thanks
Bookmarks