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