Apr 01 2020 03:40 AM - edited Apr 01 2020 03:41 AM
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
Apr 01 2020 11:29 AM
Solution@JopOctopus Something like in the attached file? If not, kindly ignore or clarify how the graph should look like.
Apr 02 2020 08:23 AM
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)?
Apr 02 2020 08:59 AM
@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.
Apr 06 2020 04:59 AM
Thanks @Riny_van_Eekelen, managed to get it to work!
Apr 01 2020 11:29 AM
Solution@JopOctopus Something like in the attached file? If not, kindly ignore or clarify how the graph should look like.