Pie Chart - Columns

[StephenAccountant]

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.

 

[Shane Devenshire]

Hi,

Show us you data layout and explain what you mean by "won't work"? What
version of Excel are you using?

Excel pie charts have no problem plotting data laid out in either rows or
columns, in general.

For the second chart problem. Add autofilters to the original range and
plot the whole range. Then apply the filter so you only see the rows that
meet your criteria, the chart will plot only visible cells.