Pie chart not showing complete data

[SBC]

Of 6 rows of data, one row isn't being plotted. The first 2 boxes in that
row have values of 0. Could this be the reason it's not showing? The values
in the row not being plotted are large enough that they should be visible on
the chart.

 

[CyberTaz]

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.

 

[SBC]

Of 6 rows of data, one row isn't being plotted. The first 2 boxes in that
row have values of 0. Could this be the reason it's not showing? The values
in the row not being plotted are large enough that they should be visible on
the chart.

Thanks for the reply, very helpful!

 

[SBC]

Thanks!

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.