Dynamic chart

[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

 

[Earl Kiosterud]

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.

 

[Thrava]

Earl,
thanks much. This helps tremendously
Thrava