Graph with columns and lines

Regis Thermo

Hi everyone - I hope that everybody is fine out there. I am asked to produce graphs with a blend of stacked columns and unstacked columns. Here are the 3 pieces of information that I need to graph:

1) Cumulative monthly targets

2) Actual monthly completes stacked on top of monthly Planned to be completed

So far, I can only do 1) and the sum of 2) with unstacked columns. I can also do 2 with stacked bars.

Can somebody help me?

Thanks,

Kind regards,☺️

Paul Newcome

Are you able to provide screenshots of what you do have so far for reference?

Regis Thermo

Here you go, Paul. I'd like to have only one graph with Cumulative Target, Cumulative Complete+Cumulative in-Flight/Planned. Thanks in advance for your help. Kind regards,

Paul Newcome

You would have to create three rows for each month and have you table three columns wide (labels plus two).

First data column would house your values from the top chart and the first set of values from the bottom chart. Second column would be left blank for the labels in the top chart and then the second values from the bottom chart would go in the second column.

Regis Thermo

Paul - thanks for your answer. I need more directions. This what I understand from your message: see below. Am I correct? What am I missing? Thanks for your time and support.

Month 2nd col 3rd column

January Target Blank

January Complete Planned

January

Paul Newcome

The highlighted rows are what will generate the stacked columns.

Regis Thermo

Paul - thanks for the direction but I will welcome more. Here what I created following your directions:

Which commands on my dashboard should I do in order to get: (1) one column with Target (first line of each month); (2) one stacked columns with Complete (2nd row for each month) and Planned (3rd line for each month)? Thanks in advance.

Paul Newcome

You would select all 3 columns when setting up a stacked column chart widget.