How to combine two graphs with the same data source into one graph

[YuyangG]

Hi everyone,

Am working on a project which requires combining two graphs with the same data source into one graph.

Details are as follows.

There are three tables. Table Dept, Table A, and Table B.

Based on the tables and data above, I have already created Graph 1 and Graph 2.

Graph 1, grouped by the Dept column of Table Dept, shows the amount difference of each dept (total amount of each dept from Table A minus total amount of the corresponding dept from Table B).

Graph 2 is a compound bar graph, also grouped by the Dept column. It shows the total Amount of each Dept from Table A and Table B.

The problem I am facing is creating Graph 3 which is a joint graph of Graph 1 and Graph 2.

The image of Graph 3 is attaced below.

Anyone with good ideas?

If any further information is needed pls feel free to contact.

Thank you very much.

[lbendlin · Accepted solution]

Is it a problem when you are showing two charts side by side?

[YuyangG]

Hi Ibendlin,

Thank you for your reply.

Yeah and they share the same and the only one Y-axis.

[lbendlin]

Maybe I didn't phrase my question right.  Showing these charts side by side seems like an acceptable option to me.  What prevents you from choosing that option?

[YuyangG]

You know.. requirements from clients... so am looking for a way to implement this.

If you have any ideas to share, it would be great. Thank you a lot.

[lbendlin]

Sometimes it is okay to push back on the requirements and offer alternatives.