Merging 2 Graphs

[Guest]

I have a table as follows:

Branch Amt Qty Rate
A 100 20 10%
B 200 15 12%
C 400 12 11%

with a bar chart showing two "BARs" for Amt & Qty, and a line graph for Rate.

Can I merge the graphs in one with two bars and one line?

Thanx in advance

 

[Guest]

make a bar chart with all three variables
Select the rate bar and chart-chart type-select line. you will probably also
have to double click on the line and select axis secondary to get the y axis
how you want it.