Ask Your Question

Data labels on data series [closed]

asked 2014-03-25 02:01:16 +0200

ChrisOfBristol gravatar image

updated 2014-03-25 02:03:41 +0200

I have a simple XY Scatter (lines only) graph, all the data comes from a separate sheet. There are two data series - see the two attached pictures.

I have selected Data Labels - Show Category. It doesn't seem to use column B properly to supply the labels. If I choose B2:B4 for VW (to get A, B, C) then try to change the Audi range to B6:B8 (to get AA, BB, CC), I find that the VW range has changed to that as well. It seems to use the same set to apply to both series. In the example here I have set it to B2:B8 hoping it will sort it out itself but as you can see it just starts at the beginning with A for each series. Perhaps I don't understand data ranges properly.

image description

image description

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-20 15:37:59.932062

1 Answer

Sort by » oldest newest most voted

answered 2014-03-25 02:13:18 +0200

mahfiaz gravatar image

Restructure your data to columns as follows and select "First row as labels" and "First column as labels": Data labels, power (X), VW (Y), Audi (Y). See the attached file example.ods

edit flag offensive delete link more



That's it and it looks so easy! I have spent hours trying to work this out. Thanks very much! I've just noticed the Legend with the makers' names. That is something else I will use.

ChrisOfBristol gravatar imageChrisOfBristol ( 2014-03-25 02:25:52 +0200 )edit

This is a fantastic help to me. I know Estonians are good-looking, but I see they are smart and helpful too. I had made a scatter plot of 100 integrated circuit parts, showing the speed and power of each. 10 years ago in Excel 2000 I made a plot where each of the parts was a data series. Then the plot points were a different shape and color and the legend would spell out the part number. Back then I wanted to have the part number by the data point but failed. Now I see to make one series+labels.

SportsterPaul gravatar imageSportsterPaul ( 2016-06-08 02:59:15 +0200 )edit

Question Tools

1 follower


Asked: 2014-03-25 02:01:16 +0200

Seen: 4,741 times

Last updated: Mar 25 '14