+ Reply to Thread
Results 1 to 2 of 2

Select Date and Change Line Graph X-Axis

  1. #1
    Registered User
    Join Date
    05-14-2013
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    92

    Select Date and Change Line Graph X-Axis

    I am trying to change a line graph so when the date in N:2 changes it modifies the graph so N:2 becomes the start date on the graph to the last recorded date.

    i.e. it changes the graph for 1/5/2010 to 1/22/2016 currently to 2/5/2015 to 1/22/2016. where the 2/5/2015 is the changing dynamic value.

    Thanks,
    Brandon

    Help File.xls

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,765

    Re: Select Date and Change Line Graph X-Axis

    Is it necessary to enter the date in a cell and reference that cell? One strategy would employ "filters". https://support.office.com/en-us/art...F-C6204E6E5C8A In this strategy, instead of entering the date in a cell, you would enter the start date in the filter dialog behind the filter drop down. When autofilter hides rows, the chart usually follows and does not display data in the hidden rows.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. Replies: 1
    Last Post: 08-27-2015, 01:54 AM
  2. *Help* Line of best fit across multiple Y axis line graph
    By zeroX14 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-07-2015, 11:31 PM
  3. [SOLVED] 3 axis chart with stacked bar graph and line graph above
    By hefe_espada in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-26-2013, 12:53 PM
  4. [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
  5. line graph XY axis cant do
    By jagguy in forum Excel General
    Replies: 1
    Last Post: 07-23-2008, 07:29 AM
  6. [SOLVED] can I make the vertical axis the category axis in Excel line graph
    By power1 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-20-2006, 04:50 PM
  7. [SOLVED] Second x-axis for line graph
    By Sabine in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-17-2005, 09:05 PM

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