Can't plot the line graph based on the data in the table

Hello!

My system Mac OS 10.11.6, Excel 14.7.5

Very unexpectedly I came across numerous issues with plotting graphs based on the data in the table. I am trying to plot the same graph I have in the file (it is from the text book), but my one comes out ugly and unreadable. First, I wanted to show in the file my attempts, but then I simply deleted all of them because they are incorrect and don't add any value.

I will be very grateful if you can guide me through the process of creating the same graph I have in the attached file:

- how did they get all these lines crossing at one point;
- how did they set x-axis values to the range -0.45% to 0.45% if they choose the range from the table that has only -0.30% to 30%;
when I open "Format axis" window, I can't select such ranges;
- how did they set all labels at the right end of each line?

The only things I seem to know here is how to delete initial grids, and to change the color.

Thank you very much for your time and help!

Originally Posted by MrShorty

I will disagree, I think it would have been useful to see what you were trying.

1st response. What chart type are you wanting to use? Your title suggests a line chart, as does your second bullet point. The chart in your sample file is an XY scatter chart. My first guess at your problem is that you are confused or unclear about the differences and similarities between line and scatter chart types. A couple of resources:
http://peltiertech.com/line-charts-vs-xy-charts/
http://peltiertech.com/Excel/ChartsH...ValueAxis.html

Thank you very much for your reply, and for these links. I will now study them to make sure that I don't confuse two types of charts.

Originally Posted by MrShorty

1st bullet point -- the NPV for each data series at X=0% is 1048, which is why they all cross in the middle.

Oh, of course. I definitely understand this. The graph I tried to create didn't look like the one on the picture - it was far from it. I will now try it again upon reading the articles you suggested. My main goal is to create exactly the same graph as the one I showed, and I don't understand how to do that (quite a few attempts showed that I can't).

Originally Posted by MrShorty

3rd bullet point -- By adding a data label to a single point in the data series and formatting that label to show the series name.

So I thought, but no, I couldn't get the same result, but most likely because my graph didn't work out the way it should.

Originally Posted by MrShorty

If you are still around, I came back to see how you were doing. I am not certain what question, if any you still have. You still show data labels on each point, which is how Excel adds data labels when you add them. It looks like the only thing left to do is to delete the extra data labels. Select each individual data label (you will often need to click on a data label twice, as the first click will select all of the data labels for that series) and press delete. Repeat for all of the unwanted data labels.

Thank you very much for coming back to me with this issue. Yes, it is exactly the one you addressed. But is it normal to manually delete those additional labels? Is it all right that those labels are displayed a few times instead of just one time? It seems that I make some basic mistake, but I truly don't see it. I checked all series' data in my file and in the original file, all look the same.

Originally Posted by MrShorty

It depends on how you added the labels and all of that.

If you select the chart and then click on add data labels, then Excel will add data labels to all points in all series within the chart.
If you select a single data series and click on add data labels, then Excel will add data labels to all points in that series.
If you select a single data point (as I noted in the last post, you usually need to click on a point twice to get a single point selected) and click on add data labels, then Excel will add the data label to the point selected.

If you did either of the first two, then, yes, it is normal to need to delete the extra data labels.

I see. Thank you very much for your help! )