Pie Bar chart for Subtoal

[excelsishya]

Hi all,

Recently i saw Pie bar chart,where main product total was pie and subtotal of 1 product was in bar.

<table style="padding-right: 2pt; padding-left: 2pt; font-size: 11pt; font-family: Calibri,Arial; background-color: rgb(255, 255, 255);" border="1" cellpadding="0" cellspacing="0"> <colgroup> <col style="font-weight: bold; width: 30px;"> <col style="width: 67px;"> <col style="width: 64px;"></colgroup> <tbody> <tr style="font-weight: bold; font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;"> <td>
</td> <td>C</td> <td>D</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">2</td> <td>ITEM 1</td> <td style="text-align: right;">20</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">3</td> <td>ITEM 2</td> <td style="text-align: right;">30</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">4</td> <td>ITEM3</td> <td style="text-align: right;">40</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">5</td> <td>Product A</td> <td style="text-align: right;">90</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">6</td> <td>Product B</td> <td style="text-align: right;">80</td></tr> <tr style="height: 18px;"> <td style="font-size: 8pt; background-color: rgb(202, 202, 202); text-align: center;">7</td> <td>TOTAL</td> <td style="text-align: right;">170</td></tr></tbody></table>

product A and product B will be pie.

behind product a bar will there showing 23,30,40.


Can any please provide steps on how to do it.

Also if possible let say product b had sub items can another bar behind it possible.

Thanks

 

[VoG]

These may help you http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=471

 

[excelsishya]

Thanks VOG,

i will read this try to build chart .Let you know the result.

 

[excelsishya]

VOG i was able to build chart after going trough link you gave. Thanks again