Graphs combination in excel

[Lorderon]

Hi,
I want to create a graph, combining bar graph and line graph into one. It is
commonly called S-curve graph. My data is shown below:

Apr-08 May-08 Jun-08 July-08
Number of Frogs 100 200 30 0
Number of Snake 50 20 60 0

Cumulative total 150 370 460 460

So the bar graph (histogram) is for the number of frogs and snake per month
while the line graph is for the cumulative total per month.


Pls help. Thanks!

 

[Fia]

Hi Lorderon,

Include the cumulative total as the third bar graph, right click on the bar
graph for cumulative total, click on chart type, choose Line graph as your
chart type, then click OK.

The result should show the cumulative total as a line graph while the number
of frogs and snake remain as bar graphs.

Thanks,

 

[Lorderon]

Thanks Fia, never thought it will that easy or obvious!