Frank Bacchus
Member
Hi:
I have two questions on Pivot Charts. I am creating two single summary charts (1) an Exploding Pie Chart and (2) a column chart. Both are using the same date but displaying information at different levels. The Pie chart shows 3 slices with Percentages next to each color and a legend of what the three slices represents. Because there are only three slices, I would like to place the legend information, next to the appropriate slice (slanted) with the percentages inside the pie. How can I do this? I am attaching the source.
The second chart, a column chart, shows the counts at the next level (the level below the pie chart level). It excludes the level shown in the pie chart. I would like to use the same colors, shown in the pie chart, to identify each of the columns on this chart. Basically grouping each of the towers in their appropriate color group as is shown in the Pie Chart.
The attachment will make it clearer. Thanks.
frank
I have two questions on Pivot Charts. I am creating two single summary charts (1) an Exploding Pie Chart and (2) a column chart. Both are using the same date but displaying information at different levels. The Pie chart shows 3 slices with Percentages next to each color and a legend of what the three slices represents. Because there are only three slices, I would like to place the legend information, next to the appropriate slice (slanted) with the percentages inside the pie. How can I do this? I am attaching the source.
The second chart, a column chart, shows the counts at the next level (the level below the pie chart level). It excludes the level shown in the pie chart. I would like to use the same colors, shown in the pie chart, to identify each of the columns on this chart. Basically grouping each of the towers in their appropriate color group as is shown in the Pie Chart.
The attachment will make it clearer. Thanks.
frank
