Mac Forum / Applications / Excel / July 2007

I'm not really clear on how you have your data arranged and how you're
trying to plot it. Pie Charts handle only a single data series (one column
or one row of data) but from your description it sounds like you have
multiple data series you're trying to plot with a pie. IOW - The first row
or column can contain text labels and a second column or row should contain
the values to be plotted or you can plot just the one row or column of
values, but a pie can't plot more than the 1 set of values.

If your first column contains what XL interprets as values *those* are what
is actually being plotted in your pie chart - any additional columns are
being ignored. Since the first two values are the same ( 0 ) they're being
plotted as concident or "no size" slices of the pie. Both are there but you
can only see one - the legend will include all six, however.

If I'm misinterpreting your post please clarify how your data is structured
& what you're trying to plot.

Thanks for the reply, very helpful!