2 Charts in 1

[mycon73]

Hi,

I have 2 tables & trying to merge the data into 1 chart.

Table A completion totals broken down by week in which I would like to display later either as montly review, with week ending durations. I woulld also liketo have the Completion Totals.

I would also like to add Table 2 into my chart - On the left, as a stacked bar of back log tasks.

How can I merge these table to have a 2 in one chart?

Please see example file.

Thanks

[mycon73]

Hi,

Can anyone help?



Please help....

Thanks

[mycon73]

Hi,

Is it possible to have a stacked bar & side-by-side in 1 chart? Would I need to creat individually & later combine? If so how?

Thanks

[mycon73]

Can anyone assist?

Feel free to modify data table or charts in sample file. I'm still looking to see how this can be done.


Thanks

[lmp]

Hello

I woulld also liketo have the Completion Totals.

The label selection for that series only extends to column I.

=SERIES(Sheet1!$B$9,Sheet1!$C$5:$I$6,Sheet1!$C$9:$J$9,3)

Change that to $J$6 and the label will show.

I would also like to add Table 2 into my chart - On the left, as a stacked bar of back log tasks.

A chart area can only show one chart. You can position another chart next to it and then draw a border around the two charts, so that they appear as one.

see attached