Create chart with date selection

**gjvanveen** · 04-01-2021, 06:22 AM

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?

**Estevaoba** · 04-01-2021, 03:01 PM

I use this formula in E2 to find date of start week and copy down to E3 for finish week date:

Formula:

Please Login or Register  to view this content.

I create named range "Dates" for the label (x) values with this formula:

Formula:

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:

Please Login or Register  to view this content.

File attached.

Good luck!

**gjvanveen** · 04-02-2021, 04:08 AM

Originally Posted by Estevaoba

I use this formula in E2 to find date of start week and copy down to E3 for finish week date:

Formula:

Please Login or Register  to view this content.

I create named range "Dates" for the label (x) values with this formula:

Formula:

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:

Please Login or Register  to view this content.

File attached.

Good luck!

Just perfect!! Thanks!

**Estevaoba** · 04-02-2021, 07:04 AM

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

Create chart with date selection

LinkBack

Thread Tools

Rate This Thread

Display

Create chart with date selection

Re: Create chart with date selection

Re: Create chart with date selection

Re: Create chart with date selection

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Dynamic date range selection from pull down menu and auto chart update HELP

Change chart data selection depending on date

[SOLVED] Expand chart based on End Date selection

Start Date and End Date selection for chart.

Create chart X-Axis categorized by date

How do i create a chart that updates for autofiltered selection

How to create Line chart by date. Newbie thank you

Bookmarks

Bookmarks

Posting Permissions