Calc selects too many rows for a label

If I use the wizard to make a stacked bar chart with a pivot table and I select the checkbox marked “first row as label” in the Data Range tab, I expect it to only select the first row to be the label. Instead, it’s selecting 4 rows for one table, 3 for another, and only 1 for yet another. Why is LibreOffice selecting too many rows to use as a label (the rows may or may not have data in them). Thanks for any insights.

Anyone? Buehler?

I encountered what sounds like this problem, and with a lot of fiddling eventually discovered that Calc automatically determines how many rows to use for the label by searching for the first number in the first column only (other columns are not searched). The first number it finds in the first column is then taken as the start of the data. Calc can be tricked into doing the right thing by putting a zero into the top-left cell of the data before creating the chart. This 0 can be deleted afterwards.

@Kath – this sounds like a bug or limitation to me. Thoughts?