Graph data points and output

[Joe Schmoe]

Hi guys,

First of all, I would like to thank the contributors on this forum for their immense help to me in the past.

As to the question. I am using Office Pro 2013. I want to make a graph (inside Word preferably) that looks like this:

Now unfortunately, I am able to do only one of two things:

1)- In Word 2013 I am able to get the scatter graph up and have a single line that follows the graph nicely. However I am unable to make intercept lines (going horizontal and vertical to the points). I am unable to make each of the data points on the graph projection incrementally increase their label instead of just showing "x,y" coordinates. I am unable to make the data points (which I wish to label "A", "B", etc, incrementally) show up beneath the graph image as shown in the picture above in the box below the graph.

2) - When I try it to excel, it comes out as two separate lines (one for "guns", one for "butter) and I can't figure out how to make them go together, forget about anything else I want to do.

I'm sorry if I'm not clear enough, but after hours of Googling (none of which helped for Office 2013) and Macros, I'm at my wits end.

Thanks for reading.

 

[Joe Schmoe]

Bump for desperation