Chart Labels Don't Show
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!! |
Chart Labels Don't Show
As answered in .charting:
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 |
Chart Labels Don't Show
Thanks again! I panicked and asked my question here, too, after it sat out
on the other board unanswered for some time. "Debra Dalgleish" wrote in message ... As answered in .charting: 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 |
Chart Labels Don't Show
You're welcome!
Mommio2 wrote: Thanks again! I panicked and asked my question here, too, after it sat out on the other board unanswered for some time. "Debra Dalgleish" wrote in message ... As answered in .charting: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 09:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com