Long time excel user, first time trying to make a graph. I'm trying to make a scatter plot to compare costs for projects. I want costs on the Y axis and the task on the X-axis. Then I'm trying to create a combo graph that has a line graph to represent the average.

First problem I'm having is that instead of the Task Name on the X-axis, I'm getting numerical values 1-n.

Second problem is when I create a combo graph, the scale then adds .5 values and not all of the points are lined up properly with (what is supposed to be task Name).

I attached a sample example. Am I just using the wrong type graph for what I'm trying to do? Any help appreciated!

Attached Files

Sample.xlsx (14.5 KB, 11 views)