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)

Is it something like the attached?

Attached Files

AverageChart.xlsx (19.1 KB, 10 views)