Jump to content

Data Label - Only Display First or Last Value

Dimitri Critsinelis

Recommended Posts

I have a scatter plot that disctintly shows tesdI have a scatter plot (image attached) that shows multiple points that segment into distinct lines. If you look at the image you can see that each line has its own unique identifier (X, Y, Z, etc.). However, when I add a data label to this scatterplot, it shows the identifier for every point on that line. So, each unique line has its data label duplicated. How can I get the data label to only show one unique label for each of these, preferably the first or last value.
Link to comment
Share on other sites

Some calculated columns will help you.

When you can group your lines into X,Y,Z then you can also rank your datafor X,Y,Z. And then you can also check for min (=first) or max (=last). Use this info within an if clause to place your label into a calculated column only for min and/or max. Than use this column as label information.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...