+ Reply to Thread
Results 1 to 4 of 4

Top 5 Values Labels in Chart

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

    Top 5 Values Labels in Chart

    helloo...


    i create a chart in excel,
    is there any way to show only top 5 values "labels" in chart? just only top 5 values,,

    maybe this pict can explain what i mean.. :D
    Top5.jpg

    i need that chart can change automatically when i change the tables data

    btw, sorry for my bad english :p

    Thanks..
    Last edited by pociners; 01-22-2014 at 08:37 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: Top 5 Values Labels in Chart

    same as your other thread. post example file as picture does not allow us to see what is really happening.
    Cheers
    Andy
    www.andypope.info

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

    Re: Top 5 Values Labels in Chart

    Quote Originally Posted by Andy Pope View Post
    same as your other thread. post example file as picture does not allow us to see what is really happening.
    hahaha.. i'm sorry..because i think it just a simple data..

    this is the file..

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

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

    Re: Top 5 Values Labels in Chart

    i'm sorry.. case closed again, i just found the answer...haha,,

+ 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. Hide data labels with low values in a chart
    By Gert Van Dessel in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-02-2013, 03:27 AM
  2. Replies: 5
    Last Post: 01-27-2009, 11:22 AM
  3. Pie Chart - Extra values in data labels
    By mcaballes in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-20-2007, 09:16 PM
  4. Negative values in bar chart overlap axis labels.
    By Bonny in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-17-2006, 03:40 AM
  5. Replies: 1
    Last Post: 01-09-2006, 03:15 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