Creating Bar Graph (Total Open and Close Cases) and Line Graph (Time to Close Trend)

[#1]

Hi,

I have this bar graph below, which indicates total escalation cases for each month (YearMo).

I would like to create two similar bar graph, but with a line graph representing a trend. How can I add a line graph on top of this to show:

Line Graph 1. A mean line graph representing time to close trend (in days) for each YearMo?

Line Graph 2. A line graph representing total cases closed for each YearMo?

Fwied_0-1635901746476.png

Here are the raw data:

Fwied_2-1635902205056.png

Fwied_1-1635902163400.png

Hopefully, I provide enough information.

Thank you!

[#2]

Hi @Fwied,

I think this will do what you are looking for:

1. Drag the new variable (time to close or total cases closed) to the y axis above the current value - experiment with the different drop zones to see what each ones does.
2. Right click in the top chart area and select Add > Line
3. Right click in the top chart area and select Bars > Remove
4. Depending if you want the overlay variable to show up on the line chart, you might need to look under the column list for Line settings, open the variable list, and uncheck the overlay variable.