Linking charts/graphs with dynamic developer list

%3CLINGO-SUB%20id%3D%22lingo-sub-1083809%22%20slang%3D%22en-US%22%3ELinking%20charts%2Fgraphs%20with%20dynamic%20developer%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1083809%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20All%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20a%20few%20Issues...%3CBR%20%2F%3E%3CBR%20%2F%3ENumber%201%2C%20I%20want%20everything%20dynamically%20linked%20with%20my%20Developer%20List%20box%20for%20month.%3CBR%20%2F%3E%3CBR%20%2F%3ENumber%202%2C%20My%20%22Written%20Premium%20Growth%22%20chart%20should%20be%20showing%20the%20%22Actual%22%20Inside%20of%20the%20%22Target%2C%22%20I%20want%20the%20%22Target%22%20Red%20when%20it%20is%20not%20reached%20while%20the%20%22Actual%22%20is%20blue%20and%20the%20%22Target%22%20green%20when%20it%20is%20surpassed%20while%20the%20%22Actual%22%20remains%20blue.%20Right%20now%20the%20graph%20has%20the%20two%20measurements%20stacked%20on%20each%20other%20rather%20than%20overlapping%2Finside%20one%20another%3CBR%20%2F%3E%3CBR%20%2F%3ENumber%203%2C%20is%20my%20graph%20for%20%22Loss%20Ratio%22%20should%20behave%20the%20same%20way%20I%20want%20my%20graph%20in%20%22Number%202%22%20to%20behave.%20The%20entire%20circle%20should%20be%20based%20on%20the%20%22target%22%2C%20and%20than%20the%20filled%20in%20should%20be%20based%20on%20the%20%22Actual%22%3CBR%20%2F%3E%3CBR%20%2F%3EFinally%2C%20I%20want%20my%20numbers%20in%20%22Process%22%20to%20behave%20dynamically%20with%20the%20Developer%20List%20box%20as%20well.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20assistance%20in%20this%20manner%20would%20be%20greatly%20appreciated.%26nbsp%3B%20Think%20%22Excel%20For%20Dummies%22%20when%20providing%20an%20answer%20because%20i'll%20need%20screenshots%20and%20my%20hand%20held%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1083809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1084140%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20charts%2Fgraphs%20with%20dynamic%20developer%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084140%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F494154%22%20target%3D%22_blank%22%3E%40shade206%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20say%20that%20your%20biggest%20issue%20is%20the%20way%20you%20have%20structured%20your%20date.%20It's%20going%20to%20be%20extremely%20difficult%20to%20make%20something%20nice%20out%20of%20it.%20You%20ask%20for%20assistance%20at%20the%20level%20of%20%22Excel%20for%20Dummies%22.%20In%20the%20attached%20workbook%20(yours)%20I've%20inserted%20a%20sheet%20(Sheet2)%20with%20an%20example%20of%20how%20I%20would%20tackle%20your%20points%201%20and%202.%20Everything%20is%20in%20one%20sheet%20just%20to%20make%20it%20easier%20to%20follow.%20Not%20particularly%20beautiful%20and%20certainly%20not%20at%20the%20dummy%20level.%20Sorry!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20Listbox%20triggers%20data%20ranges%2C%20that%20in%20turn%20sets%20the%20charting%20data.%20One%20set%20for%20Actual%20%26lt%3B%20Target%20and%20one%20for%20Actual%20%26gt%3B%3D%20Target.%20The%20first%20set%20has%20color%20blue%20on%20red%2C%20the%20second%20blue%20on%20green.%3C%2FP%3E%3CP%3EAt%20the%20moment%20I%20don't%20have%20the%20time%20to%20resolve%20your%20other%20two%20requests%2C%20but%20perhaps%20you%20get%20inspired%20to%20work%20it%20out%20yourself.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1084570%22%20slang%3D%22en-US%22%3ERe%3A%20Linking%20charts%2Fgraphs%20with%20dynamic%20developer%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1084570%22%20slang%3D%22en-US%22%3E%3CP%3EThank%20you%2C%20i%20actually%20need%20to%20delete%20this%20thread%20as%20it%20is%20not%20what%20i%20needed%20to%20do...%20i'm%20going%20to%20start%20a%20new%20one%20with%20much%20more%20specific%20questions%20instead%20of%20such%20a%20broad%20stroke%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hello All,

I have a few Issues...

Number 1, I want everything dynamically linked with my Developer List box for month.

Number 2, My "Written Premium Growth" chart should be showing the "Actual" Inside of the "Target," I want the "Target" Red when it is not reached while the "Actual" is blue and the "Target" green when it is surpassed while the "Actual" remains blue. Right now the graph has the two measurements stacked on each other rather than overlapping/inside one another

Number 3, is my graph for "Loss Ratio" should behave the same way I want my graph in "Number 2" to behave. The entire circle should be based on the "target", and than the filled in should be based on the "Actual"

Finally, I want my numbers in "Process" to behave dynamically with the Developer List box as well. 

Any assistance in this manner would be greatly appreciated.  Think "Excel For Dummies" when providing an answer because i'll need screenshots and my hand held  

2 Replies
Highlighted

@shade206 

I would like to say that your biggest issue is the way you have structured your date. It's going to be extremely difficult to make something nice out of it. You ask for assistance at the level of "Excel for Dummies". In the attached workbook (yours) I've inserted a sheet (Sheet2) with an example of how I would tackle your points 1 and 2. Everything is in one sheet just to make it easier to follow. Not particularly beautiful and certainly not at the dummy level. Sorry!

 

The Listbox triggers data ranges, that in turn sets the charting data. One set for Actual < Target and one for Actual >= Target. The first set has color blue on red, the second blue on green.

At the moment I don't have the time to resolve your other two requests, but perhaps you get inspired to work it out yourself.

Highlighted

Thank you, i actually need to delete this thread as it is not what i needed to do... i'm going to start a new one with much more specific questions instead of such a broad stroke  @Riny_van_Eekelen