Forum Discussion
Solved
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...
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!