+ Reply to Thread
Results 1 to 1 of 1

Select custom date ranges and update line graph (Macro?)

  1. #1
    Registered User
    Join Date
    06-21-2014
    Location
    Sydney
    MS-Off Ver
    2011
    Posts
    92

    Select custom date ranges and update line graph (Macro?)

    Hello All,

    I have been tinkering all day but I cannot find a way to be able to do this!

    Currently have a simple line graph showing Income and Expenses, I would like to be able to run a macro to be able to see the graph for a calendar year or financial year (Cal Yr 2017, Fin Yr 2017, Cal Yr 2018, Fin Yr 2018).

    I have a simple test dataset attached with data from Jan 2017 but I will be building on this.

    I would really appreciate any help with this.

    P.S (In the graph slicer, if you also happen to know how to show two series as a slicer choice (i.e. a choice to select Income V Expenses as well as being able to select individual series) that would also be really useful.)

    Keelin
    Attached Files Attached Files

+ 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. Macro to select custom date ranges and update line graph
    By Keelin in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-03-2017, 08:01 AM
  2. how to make line graph dynamic based on date ranges?
    By mikey42979 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-09-2016, 03:33 PM
  3. Select Date and Change Line Graph X-Axis
    By Branbran10 in forum Excel General
    Replies: 1
    Last Post: 01-26-2016, 01:39 PM
  4. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  5. [SOLVED] Macro shows three seperate data ranges in line graph
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-22-2015, 05:36 PM
  6. [SOLVED] How do I update my static line graph to allow a user to select which data to graph
    By capcon in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 12-31-2011, 10:22 PM
  7. Custom Line Graph on 2 axes help
    By nevs in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 10-27-2005, 10:29 AM

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