Scatter Chart Help

%3CLINGO-SUB%20id%3D%22lingo-sub-3519025%22%20slang%3D%22en-US%22%3EScatter%20Chart%20Help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3519025%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20scatter%20chart%20that%20I%20want%20to%20be%20able%20to%20flip%20through%20the%20individual%20weeks%20individually%20or%20show%20all%20weeks%20(like%20it%20is%20now).%20I%20also%20want%20to%20be%20able%20to%20look%20at%20it%20with%20just%20the%20dots%20that%20are%20on%20the%20workbook%2C%20but%20also%20be%20able%20to%20see%20it%20as%20a%20%22Line%20with%20Markers%22%20chart%20from%20a%20dropdown%20(snip-it%20picture%20example).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20data%20is%20copied%20and%20pasted%20to%20protect%20business%20information%2C%20but%20what%20we%20need%20is%20in%20the%20same%20place%2Fformat.%20Feel%20free%20to%20add%20as%20needed%20in%20additional%20space.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3519025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hello,

 

I have a scatter chart that I want to be able to flip through the individual weeks individually or show all weeks (like it is now). I also want to be able to look at it with just the dots that are on the workbook, but also be able to see it as a "Line with Markers" chart from a dropdown (snip-it picture example).

 

The data is copied and pasted to protect business information, but what we need is in the same place/format. Feel free to add as needed in additional space.

 

Thank you in advance.

0 Replies