Home

Dynamic Chart with array data

%3CLINGO-SUB%20id%3D%22lingo-sub-854923%22%20slang%3D%22en-US%22%3EDynamic%20Chart%20with%20array%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-854923%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20am%20kinda%20stuck%20with%20this%20excel%20issue.%20%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3EI%20have%20a%20list%20of%20items%20throughout%20the%20duration%20of%2052%20weeks...%20these%20items%20show%20the%20number%20of%20data%20for%20each.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EQuestion%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E1)%20How%20can%20I%20have%20a%20dynamic%20chart%20where%20I%20can%20display%20the%20items%20based%20on%20my%20selection%20of%20the%20week%20from%20a%20drop%20down%20list.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E2)%20Only%20show%20the%20items%20that%20show%20values%20above%20zero.%3C%2FSPAN%3E%20%3CSPAN%3ENote%20that%20my%20data%20is%20an%20array%20and%20not%20a%20single%20column.%3C%2FSPAN%3E%26nbsp%3B%20I%20don't%20want%20to%20use%3CSPAN%3E%26nbsp%3Bpivots%20or%20separate%20sheets%20for%20the%20formulas%20and%26nbsp%3Bdefinitely%26nbsp%3Bno%20coding.%20%26nbsp%3BI%20would%20like%20to%20keep%20my%20sheet%20simple%20and%20clean%20by%20embedding%20the%20formulas%20within%20the%20chart%20itself.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-854923%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Edynamic%20charts%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
izgirty
Occasional Visitor

Hi everyone,

 

I am kinda stuck with this excel issue.  I have a list of items throughout the duration of 52 weeks... these items show the number of data for each.

Question:

1) How can I have a dynamic chart where I can display the items based on my selection of the week from a drop down list.

2) Only show the items that show values above zero. Note that my data is an array and not a single column.  I don't want to use pivots or separate sheets for the formulas and definitely no coding.  I would like to keep my sheet simple and clean by embedding the formulas within the chart itself.

 

Thanks

Related Conversations