432331_en-US

liliconcom

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

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!

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

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.