Graph Style

[chris8877]

Experts
Please help me that which style is used in the attached graph showing lines and vertical bars in one graph at a same time?
I tried to find out the style and shape in excel2007 but could not.
How can I draw this type of graph?
Looking forward your immediate response
Thanks
Chris

[MrShorty]

It looks like a pretty standard combination column/line chart http://office.microsoft.com/en-us/ex...in=HA001233737 It looks like you will have 2 series as a column chart type and 3 series as line chart type.

[chris8877]

Thanks Shorty. if you/someone could just upload a snapshot of that style from excel 2007 which shows 2 series as a column chart type and 3 series as line chart type, it would be really appreciated.

[Andy Pope]

Just create a clustered collumn chart on your data.
The select the series you want plotted as line. Change the Chart type to line for the series. repeat as necessary for other series.

Your picture also shows a secondary value axis so you may also need to format the line series changing it to the secondary axis

[chris8877]

Thanks Andy

[chris8877]

Dear Experts
Once again I need your guidance. Please help. I desperately need it.
Please see attachment ... how to draw this type of graph i.e 3 items on one graph
a)Vertical bars
b)S curve line one
c)trend
please list down the steps that which style I need to adopt first i.e clustered column chart or any other and then how to proceed further for Scurve line one and finally go to trend.
Please if you have any such graph in excel please upload it so I can see its construction
Waiting please

Thank you.