maximum number of data labels

All Replies

• Thursday, April 26, 2012 2:44 PM

   

   
  

  1

  2007 limits here:-

  http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010073849.aspx

  2010 limits here:-

  http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=1

  • Marked As Answer by Max MengMicrosoft Contingent Staff, Moderator Friday, May 04, 2012 9:21 AM
  •  
  • Reply
  • Quote

   
• Monday, April 30, 2012 9:13 AM

  Moderator

   

   
  

  0

  Hi,

  Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

  Sincerely,

  Max Meng
  Forum Support

  ---

  Come back and mark the replies as answers if they help and unmark them if they provide no help.
  If you have any feedback on our support, please contact tnmff@microsoft.com.

  • Edited by Max MengMicrosoft Contingent Staff, Moderator Monday, April 30, 2012 9:14 AM
  •  
  • Reply
  • Quote

   
• Friday, May 04, 2012 9:21 AM

  Moderator

   

   
  

  0

  Hi,

  I'm marking the reply as answer as there has been no update for a couple of days. Please let us know if you would like further assistance.

  ---

  Max Meng

  TechNet Community Support

  

  • Reply
  • Quote

   
• Sunday, July 29, 2012 11:15 PM

   

   
  

  0

  Hi,

  I have exactly the same problem.  In excel 2007 you could notionally "label" a large number of points which have the value #N/A [eg as derived from a formula that returns =NA() ].  In Excel 2010, these #N/A values (which don't display of course) are apparently counted towards an upper limit on the number of labels that can be displayed.

  The links to the 2007 and 2010 limits, don't seem to be relevant as they don't seem identify any label count limitations, any in any case don't identify how to work around this limitation of Excel 2010.

  Thanks, in anticipation, for your assistance

  SD

  • Reply
  • Quote