Thursday, April 26, 2012 2:15 PM
I have recently changed from office 2007 to 2010, in an office of mixed pcs. I am having issues with data labels which work in excel 2007 but do not in 2010. I'm getting an error " the maximum number of data labels that can be displayed is 1000. Some labels will be omitted from th chart" Is there a fixed to allow more labels since it worked in Excel 2007?
Thursday, April 26, 2012 2:44 PM
2007 limits here:-
2010 limits here:-
- Marked As Answer by Max MengMicrosoft Contingent Staff, Moderator Friday, May 04, 2012 9:21 AM
Monday, April 30, 2012 9:13 AMModerator
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.Sincerely,
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 firstname.lastname@example.org.
- Edited by Max MengMicrosoft Contingent Staff, Moderator Monday, April 30, 2012 9:14 AM
Friday, May 04, 2012 9:21 AMModerator
Sunday, July 29, 2012 11:15 PM
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