+ Reply to Thread
Results 1 to 4 of 4

Create chart with date selection

  1. #1
    Registered User
    Join Date
    03-24-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    10

    Create chart with date selection

    Hello,

    I have a table that is getting bigger and bigger with data. So is the chart on sheet2 also.
    I'm trying to generate a chart based on a variable start- and end date based on weeknumber. For example, I would like to see the data of week 2021-4 only (start and end the same weeknumer) or I want to see the data from week 2021-2 to 2021-5.
    I tried to get the data with INDEX (column O on sheet 1). But it only shows the first values.

    Now I know, I could just use and auto-filter on column M to select the data, but when switching from 2 weeks to 20 weeks data I have to check al weeks I need.

    I was also trying to use a slide-bar, but I could only use 1 cel / slider.
    I've seen some nice options from other people, but I don't know if they used VBA or not. They could easily run through dates, returning the correct data for that period.

    I would like to see all data that applies to values higher or equal to the weeknumber in Sheet2!D2 and lower or equal to weeknumber in Sheet2!D3.

    Do I need VBA, or just another formula(s) in Excel?
    Attached Files Attached Files
    Last edited by gjvanveen; 04-02-2021 at 04:08 AM. Reason: issue is solved

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    602

    Re: Create chart with date selection

    I use this formula in E2 to find date of start week and copy down to E3 for finish week date:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I create named range "Dates" for the label (x) values with this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then I create a new named range for each parameter. For example, "Parameter_1", using the formula above, just changing the first range:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    File attached.

    Good luck!
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    03-24-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    10

    Re: Create chart with date selection

    Quote Originally Posted by Estevaoba View Post
    I use this formula in E2 to find date of start week and copy down to E3 for finish week date:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    I create named range "Dates" for the label (x) values with this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Then I create a new named range for each parameter. For example, "Parameter_1", using the formula above, just changing the first range:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    File attached.

    Good luck!

    Just perfect!! Thanks!

  4. #4
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    602

    Re: Create chart with date selection

    You're welcome. Glad to help.
    Thank you for the feedback and for the reputation added.
    Have a blessed day!

+ 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. [SOLVED] Dynamic date range selection from pull down menu and auto chart update HELP
    By bmaness in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-09-2020, 10:02 AM
  2. Change chart data selection depending on date
    By skatmandu2002 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 11-01-2017, 03:17 PM
  3. [SOLVED] Expand chart based on End Date selection
    By Aland2929 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-10-2017, 04:07 AM
  4. Start Date and End Date selection for chart.
    By DauntlessDS in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 02-09-2015, 05:57 PM
  5. Create chart X-Axis categorized by date
    By joejiang2001 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-08-2014, 12:07 PM
  6. How do i create a chart that updates for autofiltered selection
    By cheeselover27 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-20-2012, 05:44 AM
  7. How to create Line chart by date. Newbie thank you
    By JerryLog in forum Excel General
    Replies: 1
    Last Post: 06-07-2012, 10:50 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