How to not plot non-values at all?

Hi

I have a list that looks something like this:

| A | B | C | D | E | F | G |
| 7 | 1 | _ | 2 | 3 | _ | 0 |

the values are calculated so they can vary and also be empty (as C and F in this example). I have connected a graph to the list. As it is now C and F are also shown in the graph, but are empty and leaving an empty space between the values before and after. I would want the graph to not show the C and F topics at all, and to only show the topics that have a value.

My list has over 100 values, and sometimes only e.g. 10 of them have a value. In that case I dont want the graph to also show 90 emtpy spaces.

Thankful for any help
/osciva

sort the data by descending mark, count how many marks you have, and feed that into a dynamic chart, if I have time later I will post a spreadsheet.

Thanks, but does this mean I have to sort it manually every time the value changes? To be usefull everything need to be done automatically.

see attachment

I think you do have to sort data every time, but you can do this via a macro attached to say a circle shape next to your data

regardless of how many rows you add of marks or blanks, the chart will plot all the marks in best mark first order

you wanted a fully automated system - try this !

I looked through robert111's zip files, and I have a very good understanding of what he's doing. But I don't understand how to make the OFFSET command go horizontally instead of vertically. When I make the chart, I get a formula error. It doesn't want to accept the range name in the values box. Don't know why.