Jan 18 2007, 06:50 AM
I am trying to combine two charts into one (see chart1 and chart2), using the values in the Data Worksheet.
Please advise on what chart, or method to use to combine both?
Many Many thanks
Jan 18 2007, 07:22 AM
Plot all 4 series on one graph (stacked bar). Select one of the series you want as a line, so that all the points are highlighted. Right click and select Chart Type, then you can select the line graph. Repeat for the second series you want as a line.
Jan 18 2007, 07:43 AM
You are a legend, thank you very much