Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie chart handles in the pivot table don't function
Hi All:
I have a pie chart which activates off a pivot table. I want to expand the pie chart size so that I can see it better, and I can't get the "pull" handles to work? Please advise. Really need this one answered right waay, as I am missing a deadline! Thanks, Hazel |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie chart handles in the pivot table don't function
Hi,
I don't believe you can resize the plotarea for a pie chart, or in fact any chart, when it is linked to a pivot table. You will need to make your own chart based on the cells. But don't you the mouse to select the cells otherwise it will create an automatic link to the pivot table and you will not be able to resize the plotarea. Cheers Andy hazel wrote: Hi All: I have a pie chart which activates off a pivot table. I want to expand the pie chart size so that I can see it better, and I can't get the "pull" handles to work? Please advise. Really need this one answered right waay, as I am missing a deadline! Thanks, Hazel -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie chart handles in the pivot table don't function
Hi Andy: So then will it really be a pivot chart if I don't use the mouse to
select the cells? Still confused. Thanks, Hazel "Andy Pope" wrote: Hi, I don't believe you can resize the plotarea for a pie chart, or in fact any chart, when it is linked to a pivot table. You will need to make your own chart based on the cells. But don't you the mouse to select the cells otherwise it will create an automatic link to the pivot table and you will not be able to resize the plotarea. Cheers Andy hazel wrote: Hi All: I have a pie chart which activates off a pivot table. I want to expand the pie chart size so that I can see it better, and I can't get the "pull" handles to work? Please advise. Really need this one answered right waay, as I am missing a deadline! Thanks, Hazel -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie chart handles in the pivot table don't function
No it will not be a pivot chart.
You have to decide pivot functionality or resizable plotarea. Cheers Andy hazel wrote: Hi Andy: So then will it really be a pivot chart if I don't use the mouse to select the cells? Still confused. Thanks, Hazel "Andy Pope" wrote: Hi, I don't believe you can resize the plotarea for a pie chart, or in fact any chart, when it is linked to a pivot table. You will need to make your own chart based on the cells. But don't you the mouse to select the cells otherwise it will create an automatic link to the pivot table and you will not be able to resize the plotarea. Cheers Andy hazel wrote: Hi All: I have a pie chart which activates off a pivot table. I want to expand the pie chart size so that I can see it better, and I can't get the "pull" handles to work? Please advise. Really need this one answered right waay, as I am missing a deadline! Thanks, Hazel -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#5
Posted to microsoft.public.excel.charting
|
|||
|
|||
Pie chart handles in the pivot table don't function
This may or may not help you but by default a PivotChart is in a sheet by
itself. That makes it fairly large to begin with. Further, you can "explode" the pie by clicking any of the slices and dragging it away from the center. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... Hi All: I have a pie chart which activates off a pivot table. I want to expand the pie chart size so that I can see it better, and I can't get the "pull" handles to work? Please advise. Really need this one answered right waay, as I am missing a deadline! Thanks, Hazel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude pivot table data from pivot chart? | Charts and Charting in Excel | |||
Pivot Table Chart | Excel Discussion (Misc queries) | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Change Data In Pivot Table | New Users to Excel | |||
Display Pivot Table Chart in Powerpoint | Excel Discussion (Misc queries) |