How to add an average line to a bar plot

[#1]

I am trying to add an average line to a bar plot and create a plot similar to the following picture:

So far I can only plot the bars and  when I am adding an extra column for average values to add to the plot, they will be plotted as an extra bar plot next to the original and I don't know how to change the format for this specific data set. Any help is appreciated. 

[#2]

Do you want something like this?

• Select Graph > Graph Builder.
• Drag response to Y drop zone.
• Drag category to X drop zone.
• Select the Bar element.
• Right-click on response data column in list and select Aggregate > Mean.
• Drag new Mean response column to frame just inside Y scale.
• Right-click Y scale and select Move Right > Mean.
• Right-click a bar and select Bar-right > Change to > Line.

[#3 · Accepted solution]

Mark, not surprisingly, beat me to it. But since I had a response ready, here is another approach:

Graph > Graph Builder.

Drag response to Y zone.

Drag category variable to X zone.

Select the bar element.

Hold the shift key and select the Line element.

In the Line properties, click the Variables gray triangle and remove the checkbox for the X category variable.