+ Reply to Thread
Results 1 to 2 of 2

Macro to select custom date ranges and update line graph

  1. #1
    Registered User
    Join Date
    MS-Off Ver

    Macro to select custom date ranges and update line graph

    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.)

    Attached Files Attached Files

  2. #2
    Forum Guru Winon's Avatar
    Join Date
    East Rand, R.S.A.
    MS-Off Ver

    Re: Macro to select custom date ranges and update line graph

    Post deleted, Wrong Thread
    Last edited by Winon; 01-03-2017 at 08:04 AM.
    Please consider:

    Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .

+ 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. 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
  2. Select Date and Change Line Graph X-Axis
    By Branbran10 in forum Excel General
    Replies: 1
    Last Post: 01-26-2016, 01:39 PM
  3. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  4. [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
  5. Unable to update line graph
    By Muse83 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-26-2014, 11:42 AM
  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


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