+ Reply to Thread
Results 1 to 9 of 9

Multi Level Unthick

  1. #1
    Registered User
    Join Date
    01-22-2014
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Multi Level Unthick

    Case Closed..

    Hello,


    i create a chart from pivot table,

    this is the chart
    a.jpg

    but when i unthick the multi level category labels
    b.jpg

    the chart change like this??
    c.jpg

    can anyone help me? why some of my axis label's gone?
    sorry for my bad english

    thanks.
    Last edited by pociners; 01-22-2014 at 07:39 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Multi Level Unthick

    can you post example file rather than pictures.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-22-2014
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Multi Level Unthick

    this is the data.
    you can find the chart in "sheet2"

    thanks.
    Attached Files Attached Files
    Last edited by pociners; 01-22-2014 at 06:41 AM.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Multi Level Unthick

    The algorithm that calculates what to display appears to be a little over zealous.

    If you increase the chartobject size or reduce the font size of axls labels the text should reappear.

  5. #5
    Registered User
    Join Date
    01-22-2014
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Multi Level Unthick

    Quote Originally Posted by Andy Pope View Post
    The algorithm that calculates what to display appears to be a little over zealous.

    If you increase the chartobject size or reduce the font size of axls labels the text should reappear.
    thanks for your replies, but i just solve this case with my method.. haha,,
    case closed :D


    *but i have another question about chart in excel, :p
    i'll make another thread for my question..

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Multi Level Unthick

    care to share your method? what did you do.

  7. #7
    Registered User
    Join Date
    01-22-2014
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Multi Level Unthick

    Quote Originally Posted by Andy Pope View Post
    care to share your method? what did you do.
    i can't explain how it works, it's so complicated i think.. *just kidding, haha*
    but you can see the file, :D
    Attached Files Attached Files

  8. #8
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: Multi Level Unthick

    okay but that is no longer a pivot chart

  9. #9
    Registered User
    Join Date
    01-22-2014
    Location
    Indonesia
    MS-Off Ver
    Excel 2010
    Posts
    31

    Re: Multi Level Unthick

    Quote Originally Posted by Andy Pope View Post
    okay but that is no longer a pivot chart
    well i think there's no different, because my chart can automatically update when the tables is changed.. :D

    btw, can you help me with my question in this thread?
    http://www.excelforum.com/excel-char...ml#post3554791


    thanks..

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Bill of Materials conversion from multi level to single level
    By susmitpatel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-11-2013, 12:53 AM
  2. Multi level BOM
    By neorez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-23-2010, 05:22 PM
  3. Multi-Level VLOOKUP
    By jibjabmraz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-24-2007, 01:40 PM
  4. Multi-Level Data
    By Janice Holton in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-24-2006, 05:55 PM
  5. Using macro to convert single level BOM to Multi Level BOM
    By andrew_chong in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-07-2006, 04:57 PM

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