+ Reply to Thread
Results 1 to 3 of 3

Display Chart Data Only Up to Current Month

  1. 06-02-2018, 02:10 PM #1
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Display Chart Data Only Up to Current Month

    Hi guys, bumping into another here... As per screenshot and attachment. Would you please suggest? Thank you!

    https://www.excelforum.com/attachmen...1&d=1527962971 [EXCEL]

    2018-06-02_1906.png
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-02-2018, 02:22 PM #2
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,308

    Re: Display Chart Data Only Up to Current Month

    In I581

    =IF(I590="-",NA(),IF(MONTH(I580)<=MONTH(TODAY()),I590,NA()))

    copy across
    Reply With QuoteRegister To Reply
  3. 06-02-2018, 03:23 PM #3
    vill
    vill is offline
    Forum Contributor
    Join Date
    05-29-2017
    Location
    UK
    MS-Off Ver
    Pro Plus 2016
    Posts
    301

    Re: Display Chart Data Only Up to Current Month

    Magic JohnTopley! Works, thank you :-)
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Button click to display current month only data from a sheet in excell and GOOGLE
    By dori2o in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-24-2017, 08:24 AM
  2. [SOLVED] Current day to display as Year, Month, Day?
    By OpOrange in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 09-21-2014, 09:41 PM
  3. display only weekdays from current month
    By muldercs in forum Excel General
    Replies: 3
    Last Post: 11-20-2013, 08:25 AM
  4. [SOLVED] Look up for current month and display corresponding value
    By Abu Abdurakhim in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-26-2013, 03:19 AM
  5. Chart automatically shows different data based on the current month
    By adste89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-19-2012, 04:36 AM
  6. Display chart data when month has data
    By Aland2929 in forum Excel General
    Replies: 2
    Last Post: 02-11-2012, 07:24 AM
  7. display value based on current month
    By XLS-EXCEL in forum Excel General
    Replies: 8
    Last Post: 10-04-2007, 08:28 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1