I have had a look. I do not think that the pie chart is the one you want, and the series seem to be completely uh useless on a piechart.
I think that for the piechart view to work you need to add all the peoples fees together by section. Then you can make a pie chart on the resulting lines.
Eg>
would becomeCode:Name Commission Mortgage Fee Life Fee Home Insurance Fee Bob 100.00 Jane 300.00 599.22 Tim 200.00 200.00
Which the pie chart actually means something.Code:Total Commission Mortgage Fee Life Fee Home Insurance Fee Total 600 599.22 200
Perhaps I am missing what you are looking for thoughsorry!
Excel intellisense is crap for charting isn't it!




sorry!
Reply With Quote