I recently created a Macro for attaching data labels to a scatter graph (this is the 1st time I've ever done this). It appeared as though it was working but then after I looked at it, I realized that it is not pulling the X axis values onto the graph, it is simply assigning a (1, 2, 3, 4...) to the x axis and graphing the Y axis only. Also, I was only wanting the Country Name "label" to pull through, but instead on the graph as the label it is showing the Country name and X axis (that is not being graphed).
I have attached a copy of the file in question with the chart and data file (and macro - "Alt 11" to get to Macro)...if anyone out there can help me to fix this problem, I would really appreciate it. It's really frustrating not being able to get this to work.