topic Re: How to add an average line to a bar plot in Discussions

How to add an average line to a bar plot

faraz — Tue, 07 Jan 2020 19:05:49 GMT

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.

Re: How to add an average line to a bar plot

Mark_Bailey — Tue, 07 Jan 2020 19:53:41 GMT

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.

Re: How to add an average line to a bar plot

Dan_Obermiller — Tue, 07 Jan 2020 20:13:41 GMT

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.