Graph Type

[stevens157]

This is an example of a graph I received in a financial presentation. KNow I want to create a few like it but can't seem to figure it out. Can any one point me in the right direction. Sorry for the image quality. it is the best I can do at work.

[/img]

 

[Seti]

Check out the stock graphs. It looks like the bottom left choice, Volume-High-Low-Close.

 

[stevens157]

It looks like it but I can't make them work. You have to use specific labels for the stock graphs.

 

[Seti]

Here is how I set up my data. I was able to exactly recreate the example you showed. I just got rid of the legend and the 2nd y-axis, added a data table, changed colors and line weights.

Book1
	A	B	C	D	E	F
1		A	B	C	D	E
2	H	$5,539	$8,885	$8,680	$3,038	$8,377
3	Min	$2,225	$4,781	$4,651	$1,633	$4,651
4	Max	$6,407	$9,930	$9,916	$3,432	$9,391
5	Average	$4,677	$7,126	$6,884	$2,657	$6,663
Sheet2