Hi All,
I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for row, how do I capture it as well? Please help me.
<colgroup><col width="305" style="width: 229pt; mso-width-source: userset; mso-width-alt: 9760;">
<col width="129" style="width: 97pt; mso-width-source: userset; mso-width-alt: 4128;">
<col width="27" style="width: 20pt; mso-width-source: userset; mso-width-alt: 864;">
<col width="96" style="width: 72pt; mso-width-source: userset; mso-width-alt: 3072;">
<col width="93" style="width: 70pt; mso-width-source: userset; mso-width-alt: 2976;">
<col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3232;">
<col width="91" style="width: 68pt; mso-width-source: userset; mso-width-alt: 2912;">
<col width="65" style="width: 49pt; mso-width-source: userset; mso-width-alt: 2080;">
<tbody>
</tbody>
I have created a VBA that automatically creates a pivot table. However, I would also like to automate the creation of a graph from the the pivot table. What I want to happen is to make a graph from the details without including "Row Labels" and "Grand Total". If there is a new entry for row, how do I capture it as well? Please help me.
Count of Status | Column Labels | ||||||
Row Labels | > 5 Days | NA | Uncorrected | Within 1 Day | Within 5 Days | Grand Total | |
Claims - Credit & Surety Claims | 1 | 1 | |||||
Claims - Long Tail | 2 | 2 | |||||
Claims - Short Tail | 6 | 1 | 7 | ||||
Claims - Workers Compensation - Claims | 1 | 1 | 3 | 5 | |||
Policy Support Services - Credit Control | 1 | 4 | 6 | 11 | |||
Policy Support Services - Elders | 2 | 4 | 6 | ||||
Policy Support Services - Financial Institution | 2 | 3 | 5 | 1 | 11 | ||
Policy Support Services - Motorcycle | 4 | 4 | |||||
Grand Total | 2 | 19 | 4 | 19 | 3 | 47 | |