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
Highlighted
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
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies