Home |
Search |
Today's Posts |
#1
|
|||
|
|||
PIE CHART - HELP!!!
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing a Chart Directly?? | Charts and Charting in Excel | |||
Chart formatting | Charts and Charting in Excel | |||
Problem with xlusrgal.xls file | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel | |||
Why do my text boxes disappear from my chart when I click out? | Charts and Charting in Excel |