SOLVED

Colum chart based on certain conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-1270957%22%20slang%3D%22en-US%22%3EColum%20chart%20based%20on%20certain%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1270957%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20see%20attached%20an%20example%20of%20a%20file%20I'm%20working%20on%20at%20the%20moment.%20I'm%20trying%20to%20make%20a%20column%20chart%20but%20it%20should%20only%20show%20data%20from%20the%20A%20column%20on%20the%20X%20axis%20and%20B%2FC%2FD%20columns%20on%20the%20Y%20axis%20if%20the%20E%20column%20says%20'Yes'.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20know%20this%20can%20be%20done%20manually%20but%20as%20data%20in%20the%20B%2FC%2FD%20columns%20will%20be%20frequently%20updated%20it%20would%20be%20great%20if%20there's%20a%20way%20to%20get%20this%20to%20update%20automatically.%3CBR%20%2F%3E%3CBR%20%2F%3ECurious%20if%20this%20is%20possible%20and%20thanks%20in%20advance%20for%20your%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EBest%2C%3CBR%20%2F%3EJop%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1270957%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%3CLINGO-SUB%20id%3D%22lingo-sub-1275672%22%20slang%3D%22en-US%22%3ERe%3A%20Colum%20chart%20based%20on%20certain%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1275672%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%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%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThat's%20exactly%20what%20I%20was%20looking%20for%2C%20thanks!%20Is%20there%20also%20way%20to%20sort%20the%20graph%20so%20the%20highest%20number%20in%20a%20certain%20one%20would%20appear%20first%20(in%20this%20example%2C%20column%20D)%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1272497%22%20slang%3D%22en-US%22%3ERe%3A%20Colum%20chart%20based%20on%20certain%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1272497%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F578474%22%20target%3D%22_blank%22%3E%40JopOctopus%3C%2FA%3E%26nbsp%3BSomething%20like%20in%20the%20attached%20file%3F%20If%20not%2C%20kindly%20ignore%20or%20clarify%20how%20the%20graph%20should%20look%20like.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi!

Please see attached an example of a file I'm working on at the moment. I'm trying to make a column chart but it should only show data from the A column on the X axis and B/C/D columns on the Y axis if the E column says 'Yes'.


I know this can be done manually but as data in the B/C/D columns will be frequently updated it would be great if there's a way to get this to update automatically.

Curious if this is possible and thanks in advance for your time.

Best,
Jop

4 Replies
Highlighted
Best Response confirmed by JopOctopus (Occasional Contributor)
Solution

@JopOctopus Something like in the attached file? If not, kindly ignore or clarify how the graph should look like.

 

Highlighted

Hi @Riny_van_Eekelen

That's exactly what I was looking for, thanks! Is there also way to sort the graph so the highest number in a certain one would appear first (in this example, column D)?

Highlighted

@JopOctopus Put your cursor in cell E3. Then add a filter. It will add a filter buttons to B3:D3. Don't really understand why it works, but it does.

Then you can sort any of the columns in descending order. Please see attached.

Highlighted

Thanks @Riny_van_Eekelen, managed to get it to work!