I'm currently building a chart with Excel out of a fair number of lines of statistics.
Since there are too many lines, i cannot plot them all, otherwise the chart would become unreadable.
I'm currently selecting the lines and values by hand, which is a tedious process. I'm trying to automate some of this work.
The question : I want to only plot the 5 highest lines of statistics. At any point in time (the "columns"), I can easily extract the 5th highest value. I then know if a value is among the 5 best ones ("IF" function).
For a cell value to not be plotted, it's enough to keep the cell empty. So, if a value is not among the 5 best ones, i want the cell to be considered empty, so that it is not plotted.
The problem is, i don't know how to "not output anything" or "output something which will not be plotted" from an "IF" function. For example, if output value is "", nothing is displayed in the cell, but it is still considered like a zero by the chart.