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.
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-07-26 20:53:58 +0200
Seen: 65 times
Last updated: Aug 25 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
Anyone? Buehler?
mississippi ( 2012-07-31 18:04:20 +0200 )edit