+ Reply to Thread
Results 1 to 2 of 2

Dropdown Graphs - yearly calender - day by day reporting

  1. #1
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Dropdown Graphs - yearly calender - day by day reporting

    Hello all.

    I am attempting to create a dropdown where I can choose a month, and it will show production numbers for each day in the month I have chosen.
    The graph attached to the dropdown will also change when I choose a new month with the new data.

    I have done dropdowns before that change when I choose a new time frame. Just not sure why this is eluding me and need some help.

    I have attached a sample showing how I have it set-up with fake data in the fields.

    Any assistance would be great.

    Thanks.
    Dave

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,428

    Re: Dropdown Graphs - yearly calender - day by day reporting

    Perhaps this will be of some help.
    C18:P18 are populated with the dates from row 20, formatted mmm yy
    Cell A19 utilizes C18:P18 as a drop down list and is also formatted mmm yy
    Cell A20 is populated using: =INDEX(C20:AC20,MATCH(A19,C20:AC20,0))
    Cells A21:A50 are populated using: =IF(A20< EOMONTH(A20,0),A20+1,NA())
    Cells B20:B50 are populated using: =IF(A20="",NA(),SUMPRODUCT((C$20:AC$50=A20)*(D$20:AD$50)))
    The column chart uses the values from column B for the column values and the values in column A as the X Axis labels.
    Test by selecting another month/year in cell A19.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 8
    Last Post: 01-28-2014, 11:02 AM
  2. Replies: 4
    Last Post: 05-24-2013, 01:24 PM
  3. [SOLVED] Create different graphs depending on dropdown list
    By Candbapt in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-31-2013, 10:00 AM
  4. [SOLVED] Combining Sheets with Graphs to a Dropdown box
    By diggers16 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2012, 01:39 PM
  5. Want to make a Calender with Dropdown List Events(picture) for each Day
    By pietersc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-20-2012, 02:13 PM
  6. Excel yearly calender download
    By dilsepukar in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-19-2011, 05:58 PM
  7. Replies: 2
    Last Post: 08-12-2007, 12:24 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