![]() |
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!! |
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 |
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