Trying to copy a spreadsheet from Excel to a spreadsheet table to pick rows to graph in a column chart.
This isn't the spreadsheet, but it's set up like this. The underlines are there to space things out like table cells.
Number of Pets
Number of Plants
In the spreadsheet table:
display data: everything
source data: the numbers and the blank line on the "Number of Plants" row
destination :a blank row extending from column 2 to column 4
In column chart;
make a series
make pick by row
source data: the blank row from col 2 to col 4
make rows 1,2, 5 not pickable
When I preview, some of the pickable rows show nothing on the bar graph and others show graph for other row.
What am I doing wrong ?