+ Reply to Thread
Results 1 to 1 of 1

Problem with displaying 1000+ labels

  1. #1
    Registered User
    Join Date
    06-01-2016
    Location
    Slovenia
    MS-Off Ver
    2010
    Posts
    6

    Problem with displaying 1000+ labels

    Hello!

    I have a problem displaying data labels. I guess Excel has a limit of how many labels can be displayed on a chart, which is set to 1000.

    I would now like to ask, if there are any alternatives so I could display more labels. If you look attached file there are lots of observations in sheet "podatki", soon will be more then 1000 and when it will be, it woun't work as it is now (tested). I use sheet "podatki" to filter some basketball player (PRIIMEK and IME (surname and name)), and for that filtered player then I can find nice chart of improvement in sheet "Graf_16". So here is the problem, when I will have more then 1000 observations, I woun't see labels for those players from 1000+.

    Is there any solution? Maybe increste this limit, or maybe somehow only show first 10 labels of data, but those 10 count from when filtered (hope understood), or any other thing, just if there is any solution, I will be more then thanful!

    Thank you a lot,
    Nejc
    Attached Files Attached Files

+ 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. Displaying labels for error bars only
    By tuph in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-02-2016, 12:57 AM
  2. Creating and displaying 16 frames on a userform each frame two labels.
    By josaah in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-20-2016, 10:56 AM
  3. Excel 2010 not displaying all X-axis labels
    By jo_b in forum Excel Charting & Pivots
    Replies: 9
    Last Post: 06-21-2013, 09:23 AM
  4. Issue with Excel 2010 not displaying all X-axis labels
    By rjallison in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 12-15-2012, 07:49 AM
  5. Category x axis labels not displaying
    By tezread in forum Excel General
    Replies: 12
    Last Post: 10-21-2010, 06:30 AM
  6. Displaying data labels only from separate column
    By brendenguy in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-22-2010, 06:33 PM
  7. Bar Chart Labels Displaying Outside Graphing Area
    By sasquatchbill in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-27-2007, 07:37 PM

Tags for this Thread

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