Skip to Content
0
Former Member
Feb 13, 2012 at 07:40 PM

spreadsheet table to column chart problem

24 Views

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.

Neighbors_______________Jones___Smith_____Tomlinson

Number of Pets

Cat_________________________1______0____________1

Dog_________________________1______2__________10

Fish_________________________0_____30___________4

Number of Plants

Trees_______________________ 2______3____________1

Potted_______________________1______2____________1

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 ?