+ Reply to Thread
Results 1 to 2 of 2

Displaying single / multiple months in pivot chart title?

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Displaying single / multiple months in pivot chart title?

    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

  2. #2
    Registered User
    Join Date
    10-29-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    80

    Re: Displaying single / multiple months in pivot chart title?

    OK , so I figured it out.
    In cell $L$8 I used a basic IF test to see if the months were the same. =IF($M$8=$M9,"Same","Different")

    I then used this cell to decide which text to post in the chart title. =IF($L$8="Same","Chart Title Text "&CHAR(10)&TEXT($M$2,"mmm yyyy"),$L$4)
    (where $L$4 holds the alternative text =$L$1&CHAR(10)&TEXT($M$2,"mmm yyyy")&$L$3&TEXT($M$3,"mmm yyyy")

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] [Gant Chart] Displaying Multiple Work Dates on a single line
    By Rastancu in forum Excel General
    Replies: 3
    Last Post: 07-03-2019, 01:03 PM
  2. [SOLVED] Pivot table or Chart, but data has multiple items in a single cell
    By Rilly in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 08-22-2018, 10:24 AM
  3. Displaying ALL months in Pivot table, even if there is no data
    By ahorwitz in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-23-2016, 12:09 PM
  4. Displaying Data for Current Months Only on a Line Chart
    By HangMan in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 05-15-2015, 07:45 AM
  5. Replies: 0
    Last Post: 10-10-2011, 05:03 AM
  6. [SOLVED] Single pie chart for different months
    By Ranbir in forum Excel General
    Replies: 2
    Last Post: 05-14-2010, 03:13 PM
  7. Pivot table displaying last 12 months
    By Acro in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-15-2006, 05:35 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1