Dynamic chart

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

Hi group,

I know I've read this somewhere before...
Essentially, I have a fixed range of Data Source that
feeds a pie chart.
Not all the range would necessarily have data in it.

I want this pie chart to only plot cells within this fixed
range that actually contains data.

How?
Thrava
 
rava,

If you're showing the category labels on the chart (not in the legend), one
way is to make a helper column that shows the label only when the value cell
has something in it:

A B C
2 Tom =IF(C2>0, A2, "") 5
3 Dick (copy down)
4 Harry 7

Chart using column B for labels, C for values. Dick's row won't have a
label, and will effectively not show in the pie.
 
Back
Top