Joining two charts

[RobSA]

Hi Folk,

This may seem like a crazy question. I am wanting to join two charts together.

That is, I have a Gantt chart, reflecting progress over tome, using stacked bar and I have a rainfall chart where I use a scatter chart with curves. The measurement of the rainfall is shown in the vertical axis on the right of the lower chart.

I have treid using a combo chart option, and played with secondary and primary options to no success.

Do you have any suggestions on how I can acomplish this process?

 

[sandy666]

try drag lower chart onto upper chart

test on copy not original

 

[RobSA]

try drag lower chart onto upper chart

test on copy not original

Hi Sandy, Thanks for the prompt reply - I have tried that but it messes all the formatting up and hence me playing with the primary and secondary options, to no success.

 

[sandy666]

sometimes it works, but you need to play with scales.
this is not golden advice

 

[RobSA]

sometimes it works, but you need to play with scales.
this is not golden advice

Hi Sandy - I will endevour forward - Thaks for the reply

 

[RobSA]

sometimes it works, but you need to play with scales.
this is not golden advice

Hi Sandy - I have succeded to some extent - thank you. Iam howver having some difficulty getting the units in the x axis to reflect correctly -perhaps you have some advice

 

[sandy666]

from the picture I can do nothing except to say try secondary axis

 

[sandy666]

maybe it will help a bit: Peltier Blog