ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   Chart Labels Don't Show (https://www.excelbanter.com/new-users-excel/124144-chart-labels-dont-show.html)

Mommio2

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!!



Debra Dalgleish

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


Mommio2

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




Debra Dalgleish

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