Chart Labels Don't Show

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mommio2 - 30 Dec 2006 16:42 GMT

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

Reply to this Message

Debra Dalgleish - 31 Dec 2006 00:14 GMT

As answered in .charting:

You can format the x-axis:

Click on the x-axis to select it
Choose Format>Selected 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

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

Signature

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

Reply to this Message

Mommio2 - 31 Dec 2006 09:17 GMT

Thanks again! I panicked and asked my question here, too, after it sat out
on the other board unanswered for some time.

> As answered in .charting:
>
[quoted text clipped - 15 lines]
>> always work) to make it big enough for all my labels to show up?
>> THANKS!!

Reply to this Message

Debra Dalgleish - 31 Dec 2006 20:49 GMT

You're welcome!

> Thanks again! I panicked and asked my question here, too, after it sat out
> on the other board unanswered for some time.
[quoted text clipped - 18 lines]
>>>always work) to make it big enough for all my labels to show up?
>>>THANKS!!

Signature

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

Reply to this Message

Rate this thread: