Hi All

I am trying to create a dynamic pie chart (has to be a pie chart) that
can automatically take into account the fact that the number of series
to be graphed each time changes, and that there may be missing data
within the list of data

The 'Plot Empty Cell' section under Tools - Options does not seem to
apply to Pie Charts as I cannot select any of the options here

I have tried using the formula
=OFFSET('Sheet1'!$B$7,1,0,COUNTA('Sheet1'!$B:$B)-1,1) in the named
range for the data called Spend, and =OFFSET(Spend,0,-1) in the
corresponding data labels, but I this still graphs areas where there
are missing cells

Does anyone have any suggestions how to achieve this

Thanks

Karen


--
ksp
------------------------------------------------------------------------
ksp's Profile: http://www.excelforum.com/member.php...fo&userid=6267
View this thread: http://www.excelforum.com/showthread...hreadid=546340