Thread: Data Labels Issue with 2010

Hi,

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 (64bit).

I have a simple set of data as follows:

KP CP FG Flag Anode Flange
-0.022 -1062 0
-0.021 -1062 0 a -1062
-0.02 -1061 0
-0.019 -1062 0
-0.018 -1061 0
-0.017 -1062 0
-0.016 -1061 0
-0.015 -1062 1
-0.014 -1061 1
-0.013 -1062 1 s -1062
-0.012 -1061 1
-0.011 -1062 1
-0.01 -1061 1

Where KP is my x axis, and is a position, CP and FG are values to plot on Yaxis (primary and secondary). The Flag column is used, with if commands in anode and flange columns, to set values into the anode and flange columns.

What i do is plot an xy scatter for CP and FG, then also plot anode and flange ontop of CP, with no lines just markers. So i get a clean line chart of CP, and markers just where the flags are.

In excel 2007, i can add data labels to my entire chart of 'anode' and 'flange', and have a data range far exceeding the actual data (say 32000 samples) - so i can set a template chart and just copy data into it. All data labels are shown (say maximum 100 labels).

In excel 2010, the same charts opened up no longer show all data labels. If i mess around with data ranges, i can select upto line 2000 and it shows all data labels, if i set it to 2001 or higher it stops showing all lables and just shows markers. It also warns me the maximum number of labels is 1000 and it will not show all, even if i only have say 10 points to show.

The actual file i am using is attached.

it looks like excel is assuming that all my points in my 'anode' and 'flange' columns are going to need labels, even if they are blank.

Anyway to fix this without having 10 charts each 2000 samples long?

i take it i cant attach files till i get a post count / reputation?

nope that still doesnt work, if you change data selection range to over 2000 some disappear.

In fact delete the formulas and the values still disappear over 2000 lines...hmm

another work around which is perhaps neater, i could extract all the ones with flags to a seperate sheet, so i end up with :

column L Column M
-0.021 -1010
0.5 -1020
0.75 -1030
1 -1040
1.25 -1050
1.5 -1060
1.75 -1070
2 -1080
2.25 -1090
2.5 -1100

in another part of the sheet, and then plot that - that works so far. I used to have a macro for doing an extraction like that, but wouldnt know where to start now.

Oh and ignore the trendline i didnt mean for that to be there.

I also discovered the same problem. I have been doing something similar for years and various versions of Excel, at least back to 2003.
I would define a series with data collected from a physical occurrence. Then I write a formula in a third column, second series, that compares the value of series 1, with those around it, say plus or minus 10 points. If it meets the formula criteria for "significantly larger" the value in the second series is the same as the first, if not I generate an #N/A error via another function. I might have 10,000 points in series 1, however series 2 might have 5 points. I then plot series 2 with markers & data lables, that is at least until Excel 2010 came along. It apparently counts all those #N/A's and gives me an error message referencing a maximum of 1000 labeles. Finally got over the 32000 point limit, only to get another..