SOLVED

Colum chart based on certain conditions

Copper 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
best response confirmed by JopOctopus (Copper Contributor)
Solution

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

 

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)?

@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.

Thanks @Riny_van_Eekelen, managed to get it to work!

1 best response

Accepted Solutions
best response confirmed by JopOctopus (Copper Contributor)
Solution

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

 

View solution in original post