Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase plot size within Chart area
Help, report due today. How do I increase the size of the plot area to fit
more closer to the chart area margins. I would like to bring the plot area closer to the border of the chart area. This has been annoying me. Moving the chart handles to increase the size simply moves the white border with it. Assistance that works, greatly appreciated. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase plot size within Chart area
Click in the middle of the chart to select the Plot Area. Resize this
rectangle to suit. If it's a 3D chart, you will not be able to make it as large as you'd probably like. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ropesend" wrote in message ... Help, report due today. How do I increase the size of the plot area to fit more closer to the chart area margins. I would like to bring the plot area closer to the border of the chart area. This has been annoying me. Moving the chart handles to increase the size simply moves the white border with it. Assistance that works, greatly appreciated. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase plot size within Chart area
I do have a 3-D chart. I am looking to expand it horitonally. I've tried
the plot area handle bar drag. This is not working--neither in chart as separate sheet or on a chart sheet. I would like to stretch the plot area to take up the empty spaces on both sides. How do I do this? This will help me with the flat charts also. Thanks at my ropes end. "Jon Peltier" wrote: Click in the middle of the chart to select the Plot Area. Resize this rectangle to suit. If it's a 3D chart, you will not be able to make it as large as you'd probably like. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ropesend" wrote in message ... Help, report due today. How do I increase the size of the plot area to fit more closer to the chart area margins. I would like to bring the plot area closer to the border of the chart area. This has been annoying me. Moving the chart handles to increase the size simply moves the white border with it. Assistance that works, greatly appreciated. |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Increase plot size within Chart area
If you try the protocol I've described, and it doesn't work, then you have
stretched the plot area as far as it will go. Using a better chart type might help (3D charts have innumerable problems, not just mechanically, but cognitively as well). - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ropesend" wrote in message ... I do have a 3-D chart. I am looking to expand it horitonally. I've tried the plot area handle bar drag. This is not working--neither in chart as separate sheet or on a chart sheet. I would like to stretch the plot area to take up the empty spaces on both sides. How do I do this? This will help me with the flat charts also. Thanks at my ropes end. "Jon Peltier" wrote: Click in the middle of the chart to select the Plot Area. Resize this rectangle to suit. If it's a 3D chart, you will not be able to make it as large as you'd probably like. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Ropesend" wrote in message ... Help, report due today. How do I increase the size of the plot area to fit more closer to the chart area margins. I would like to bring the plot area closer to the border of the chart area. This has been annoying me. Moving the chart handles to increase the size simply moves the white border with it. Assistance that works, greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Plot Area Auto Size | Charts and Charting in Excel | |||
Size of plot area expands when Chart Title is deleted - why? | Charts and Charting in Excel | |||
How to change plot area size of pivot chart | Charts and Charting in Excel | |||
How to increase chart area without affecting plot area? | Charts and Charting in Excel | |||
How do I increase the plot area over a number of pages? | Charts and Charting in Excel |