Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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!!


  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,979
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 6
Default 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



  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2,979
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data does not show on a chart Cherisse Charts and Charting in Excel 1 July 24th 06 09:46 PM
negative [h]:mm:ss does not show on the x axis of a chart Devo Clubber Charts and Charting in Excel 0 June 29th 06 01:19 PM
Off the chart Graph labels, that don't show up? Dawn Charts and Charting in Excel 1 June 8th 06 03:07 AM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
How do I not include empty cell value chart labels in pie charts? JMarble Charts and Charting in Excel 1 May 13th 05 08:38 PM


All times are GMT +1. The time now is 06:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"