I have 2 problems with a pie chart.

The first is that my data is in columns and i can't seem to get the pie
chart to work. I have the first column which is the description, and then
the second column is the amount. But every time i try to put that into a pie
chart it won't work, it only seems to want to work when the dat is in rows.

The second problem i have is that I want to be able to create pie chart from
data within a list. The problem is the list can be say 200 rows long, but I
want to create a pie chart from the list with rows the meet certain criteria.
So i have a second table that brings out the rows that meet the criteria but
when I do the pie chart i will have to allow for up to 200 rows because I
will never know how many rows will meet the criteria.