+ Reply to Thread
Results 1 to 4 of 4

All titles are not visible in chart

  1. #1
    Registered User
    Join Date
    11-25-2008
    Location
    Poland
    Posts
    25

    All titles are not visible in chart

    I have made a chart, quite expanded... I attach my example. Is there any way to make all titles visible near X axis ??

    graph.xlsx

    graph.xls

    Thank you for help, Adam

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372
    Hi,

    on your chart, double click the x axis to bring up the Format Axis window. Go to the Scale tab. For "number of categories between tick marks" select 1.

    Adjust the font size so that all the category labels fit. Remember to give your readers a magnifying glass because the labels are too small to read now.

    'zat help?

  3. #3
    Registered User
    Join Date
    11-25-2008
    Location
    Poland
    Posts
    25
    Yeah, the problem is that I dont want to give magnifying glass :P Maybe there is another way to do this? to make it visible, clear and all elements visible? If not, I need to satisfy my reader with magnifying glass :D

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    You could try a bar chart instead of a column chart.

    But basically the problem is too much information in too small a space.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1