+ Reply to Thread
Results 1 to 3 of 3

Graph with changeable date axis

  1. 04-23-2019, 07:41 AM #1
    Scott Bolton
    Scott Bolton is offline
    Registered User
    Join Date
    04-23-2019
    Location
    NL
    MS-Off Ver
    Office 365
    Posts
    2

    Graph with changeable date axis

    Hi, chaps.

    I have a list of values taken on consecutive dates over several months. Is it possible to create a graph showing only the previous four weeks' data from TODAY, to change each time the sheet is opened?

    Thanks in advance.

    S
    Reply With QuoteRegister To Reply
  2. 04-23-2019, 05:23 PM #2
    dflak
    dflak is offline
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    365
    Posts
    7,920

    Re: Graph with changeable date axis

    You can do this with named dynamic ranges. See these two wikis.
    http://www.utteraccess.com/wiki/Offs...Dynamic_Ranges
    http://www.utteraccess.com/wiki/Dynamic_Charting
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.
    Reply With QuoteRegister To Reply
  3. 04-24-2019, 06:52 AM #3
    Scott Bolton
    Scott Bolton is offline
    Registered User
    Join Date
    04-23-2019
    Location
    NL
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Graph with changeable date axis

    Thanks, dflak. This should keep me busy for a while!
    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. Need to graph 2 distinct date ranges on the same X-axis on a chart
    By ard1601 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-28-2019, 11:18 AM
  2. [SOLVED] Bar Graph Displaying Monthly Rolling Average with 3 X-Axis , 1 Y-Axis with Date & Clicker
    By SCYETA in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-23-2019, 05:25 PM
  3. [SOLVED] changeable graph based on drop down list
    By mrsak87 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-08-2018, 07:26 AM
  4. Select Date and Change Line Graph X-Axis
    By Branbran10 in forum Excel General
    Replies: 1
    Last Post: 01-26-2016, 01:39 PM
  5. [SOLVED] Need graph to show alphanumeric values as Y axis labels with Date as Z axis labels
    By Ochimus in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-24-2015, 08:40 PM
  6. using date & time in the x axis of a graph
    By sjhonny in forum Excel General
    Replies: 2
    Last Post: 01-18-2007, 09:39 AM
  7. [SOLVED] X-Y Graph with Months, Not Date on Axis
    By Sam Fertel in forum Excel General
    Replies: 1
    Last Post: 01-10-2006, 12:20 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