topic Re: Creating Bar Graph (Total Open and Close Cases) and Line Graph (Time to Close Trend) in Discussions

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

Fwied — Sun, 11 Jun 2023 11:18:52 GMT

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?

Here are the raw data:

Hopefully, I provide enough information.

Thank you!

ih — Wed, 03 Nov 2021 17:06:36 GMT

I think this will do what you are looking for:

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.
Right click in the top chart area and select Add > Line
Right click in the top chart area and select Bars > Remove
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.