View Single Post
  #3   Report Post  
Jon Peltier
 
Posts: n/a
Default

You could use the approaches in this article:

http://pubs.logicalexpressions.com/P...cle.asp?ID=471

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Co-op Bank wrote:

Hello,

I have some data which I which I would like to represent in a pie chart. My
data has three columns, titled 'Products', 'Activities' and 'Cost'. The
'Products' column has 5 items and the activities column has 4 different items.

I would like to segment the pie chart by 'Products' and then break down that
segment into its 'Activities' so for example in a single visual view you
could see product 'VISA' taking up a 20% segment of the total 'Products' pie
and activitie 'Calls' taking up 50% of the 'VISA' 20% product segment.

Ideally each 'Products' segment would be coloured and the 'Activities' would
be patterns. Is this possible? Any assistance very much appreciated.
Best regards
Brian
Manchester, England