Automatically ignore empty rows for diagrams in LibreOffice Calc

Question

The task I am trying to get done is the following (hope I am able to clarify what I mean):

1. LibreOffice 5.0.5.2
2. 1024 rows of data in a Calc sheet
3. ~256 lines with excerpts of the data right of the original
4. these excerpts are shown (or not shown) based on a flag in the same row
5. these flags are set by conditions I want to change several times to plot several different scenarios
6. every time the flags change, another subset of the 1024 rows will have data in them at the right side
7. this data shall be plotted in a bar chart

8. I do not want to select ~256 by hand, but instead I want to select the whole block on the right and tell LibreOffice use only the rows with data in it to plot and ignore the rest

   (Ideally I would tell this only one time, then change the flags and the diagram would get updated with the now filled rows)

Any suggestions what I might have overseen and how to accomplish this task?

Answer 1

The problem with a bar chart is that it treats every entry as a category, regardless of the content. So empty cells have a location in the chart:

Add a filter on the data, and deselect empty cells (or choose Not Empty):

Only cells with values will be included: