SOLVED

Creating a pair of dynamic graphs for a dashboard presentation

%3CLINGO-SUB%20id%3D%22lingo-sub-3064991%22%20slang%3D%22en-US%22%3ECreating%20a%20pair%20of%20dynamic%20graphs%20for%20a%20dashboard%20presentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3064991%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20to%20create%20a%20pair%20of%20donut%20graphs%20that%20detect%20what%20week%20the%20current%20day%2Fdate%20falls%20under.%26nbsp%3B%20Simply%20put%2C%20we%20are%20tracking%20how%20many%20lots%2Fwork%20orders%20pass%20final%20inspection%20and%20how%20many%20get%20rejected.%26nbsp%3B%20This%20needs%20to%20be%20in%20a%20rather%20simple%20dashboard%20style%20presentation%20for%20our%20Monday%20Manager's%20Meeting%20(MMM)%20every%20week.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thought%20I%20was%20going%20to%20be%20able%20to%20attach%20my%20file%20but%20I%20don't%20see%20a%20button%20to%20do%20that.%26nbsp%3B%20I'll%20insert%20a%20picture.%26nbsp%3B%20I%20want%20the%20%22PREVIOUS%20WEEK%22%20graph%20on%20the%20left%20to%20detect%20the%20current%20date%20when%20they%20open%20the%20file%20at%20the%20MMM%2C%20and%20automatically%20plot%2Fdisplay%20the%20pass%2Freject%20info%20for%20the%20previous%20week.%26nbsp%3B%20I%20want%20the%20%22YEAR-TO-DATE%22%20graph%20on%20the%20right%20to%20simply%20display%20that%3A%20the%20year-to-date.%26nbsp%3B%20Obviously%2C%20we're%20not%20very%20far%20into%202022%20just%20yet%2C%20but%20there%20should%20be%20enough%20there%20to%20see%20what%20I'm%20getting%20at.%26nbsp%3B%20The%20formulas%2Fdata%20reference%20other%20worksheets%2C%20but%20this%20is%20simply%20a%20graph%20question%2C%20which%20is%20restricted%20to%20the%20sheet%20in%20the%20picture.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Lorenski_1-1642532841111.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F340459iF84D7856334735B8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Lorenski_1-1642532841111.png%22%20alt%3D%22Lorenski_1-1642532841111.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3064991%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I need to create a pair of donut graphs that detect what week the current day/date falls under.  Simply put, we are tracking how many lots/work orders pass final inspection and how many get rejected.  This needs to be in a rather simple dashboard style presentation for our Monday Manager's Meeting (MMM) every week.

 

I thought I was going to be able to attach my file but I don't see a button to do that.  I'll insert a picture.  I want the "PREVIOUS WEEK" graph on the left to detect the current date when they open the file at the MMM, and automatically plot/display the pass/reject info for the previous week.  I want the "YEAR-TO-DATE" graph on the right to simply display that: the year-to-date.  Obviously, we're not very far into 2022 just yet, but there should be enough there to see what I'm getting at.  The formulas/data reference other worksheets, but this is simply a graph question, which is restricted to the sheet in the picture.

 

Lorenski_1-1642532841111.png

 

 

2 Replies
best response confirmed by Lorenski (New Contributor)
Solution

Hi @Lorenski 

 

you can achieve this with a few simple formulas:

- identify previous week of todays date: =WEEKNUM()

- pick the values for previous week: =VLOOKUP()

- calcualte YTD values: =SUMIF()

 

DTE_0-1642579836399.png

In the attached file, you can find my example.

 

Thank you DTE! Worked the first time!