+ Reply to Thread
Results 1 to 3 of 3

Last x Months charts with dynamic label for month and year

  1. #1
    Registered User
    Join Date
    07-10-2019
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016;2019; Office 365
    Posts
    19

    Question Last x Months charts with dynamic label for month and year

    Guys,

    I have been working a series of chart and I recently I stumble upon a chart that saves some space on the month and year; Months will start with the first letter and the year will show only one time under the letters of each month.

    Trying to apply this to my reality was a little bit more complicated than I expected, since I canīt manage to have Year and Month to be dynamic along with rest of the data.

    Does anyone here have clue to set a dynamic named range for the XValues to accommodate this? My chart uses the last 12 months and the formula is pretty simple:

    Formula: copy to clipboard
    Please Login or Register  to view this content.



    This is the chart example that I intend to use:
    Chart_Month_Year.JPG

    Appreciate all help!
    CariocaExcel

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: Last x Months charts with dynamic label for month and year

    Without knowing how your data is organized. Hard to help you.

    I'd recommend uploading sample workbook with desensitized data.

    Though I'd strongly recommend using 3 letter code for month. With single letter, there's nothing that differentiates March from May, except for the position of data. This is poor practice in any sort of data visualization/analysis.

    If 3 letter code can be used... you can use Pivot Table combined with Excel table to make it more dynamic.

    Sample attached.
    Attached Files Attached Files
    Last edited by CK76; 07-16-2019 at 01:48 PM.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-10-2019
    Location
    Rio de Janeiro, Brazil
    MS-Off Ver
    2016;2019; Office 365
    Posts
    19

    Re: Last x Months charts with dynamic label for month and year

    Thanks for the input. Since I am not a regular on Pivot Table I will take some time to understand it.

+ 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. Convert list of dates in month / quarter / year format to months only
    By craigsa in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-09-2018, 04:33 PM
  2. Sum different months each month (Year to date calculation)
    By Musabi1978 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-26-2018, 09:15 PM
  3. [SOLVED] VBA Insert Current Month, Year and subsequent months/year for 15 months
    By MichiganWilliams in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-19-2014, 03:49 PM
  4. Perserving dynamic value for month and year
    By D-smoke in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-10-2013, 08:06 AM
  5. Replies: 2
    Last Post: 06-21-2012, 08:17 PM
  6. Replies: 0
    Last Post: 03-14-2006, 03:20 PM
  7. [SOLVED] HOW TO SUBTRACT A YEAR+MONTH AND SHOW DIF IN MONTHS?
    By noles fan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-01-2005, 01:05 PM

Tags for this Thread

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