ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Plot Area Sizing Question (https://www.excelbanter.com/charts-charting-excel/124012-plot-area-sizing-question.html)

Mommio2

Plot Area Sizing Question
 
This is really a beginner question I am sure. Would really appreciate some
help. When I create a chart in Excel 2003, sometimes the plot area is too
small and crowded and not all my data labels show up. Is there any way
other than dragging the corners to make the chart bigger (which doesn't
always work) to make it big enough for all my labels to show up? THANKS!!



Debra Dalgleish

Plot Area Sizing Question
 
You can format the x-axis:

Click on the x-axis to select it
Choose FormatSelected Axis
On the Scale tab, for Number of categories between tick-mark labels, enter 1
On the Font tab, you can choose a smaller font size
Click OK


Mommio2 wrote:
This is really a beginner question I am sure. Would really appreciate some
help. When I create a chart in Excel 2003, sometimes the plot area is too
small and crowded and not all my data labels show up. Is there any way
other than dragging the corners to make the chart bigger (which doesn't
always work) to make it big enough for all my labels to show up? THANKS!!




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


Mommio2

Plot Area Sizing Question
 
Wow, THANKS! Can't wait to try it! Really appreciate your taking the time
to answer me.


"Debra Dalgleish" wrote in message
...
You can format the x-axis:

Click on the x-axis to select it
Choose FormatSelected Axis
On the Scale tab, for Number of categories between tick-mark labels, enter
1
On the Font tab, you can choose a smaller font size
Click OK


Mommio2 wrote:
This is really a beginner question I am sure. Would really appreciate
some help. When I create a chart in Excel 2003, sometimes the plot area
is too small and crowded and not all my data labels show up. Is there
any way other than dragging the corners to make the chart bigger (which
doesn't always work) to make it big enough for all my labels to show up?
THANKS!!



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com