Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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, -- Fia Fiji Islands "Lorderon" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to prepare combination chart in excel | Charts and Charting in Excel | |||
Combination Bar Graphs | Charts and Charting in Excel | |||
Are there better GRAPHS within EXCEL or Add-on graphs? | Charts and Charting in Excel | |||
Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
How can you change an Excel spreadsheet from a combination od Upp. | Excel Discussion (Misc queries) |