+ Reply to Thread
Results 1 to 2 of 2

How do a create a chart that changes as I change my date range?

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    Peoria, US
    MS-Off Ver
    Excel 2007
    Posts
    4

    How do a create a chart that changes as I change my date range?

    I am currently creating a chart that is tracking our price trend. I have a cell that can change the date my price trend starts. How do I get my chart tied into the cell so that the previous date drops off of my chart?

    How do I insert my spreadsheet so everyone can understand what I am looking for?
    Last edited by rohlfnj; 07-30-2013 at 04:48 PM.

  2. #2
    Registered User
    Join Date
    04-16-2013
    Location
    Peoria, US
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: How do a create a chart that changes as I change my date range?

    Ok I figured it out. I would like the chart to drop off all the dates that are before cell I2. Is this possible?
    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. Create a milestone chart using a list of date range
    By miss_chloe in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-25-2013, 01:58 AM
  2. Macro to modify chart sheets (resize, add headers/footers, change date range)
    By seattletimebandit in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-02-2013, 08:31 PM
  3. Excel 2007 : Change date range in pivot table chart
    By Tino XXL in forum Excel General
    Replies: 1
    Last Post: 02-10-2011, 12:25 PM
  4. Replies: 2
    Last Post: 12-05-2008, 12:01 PM
  5. Create a new chart for every change of values in a combobox
    By uriel78 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-06-2005, 03:06 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