Forum Discussion
Colum chart based on certain conditions
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
JopOctopus Something like in the attached file? If not, kindly ignore or clarify how the graph should look like.
4 Replies
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.
