Graph Type

stevens157

New Member
Joined
Aug 3, 2005
Messages
27
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]
 

Some videos you may like

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
Check out the stock graphs. It looks like the bottom left choice, Volume-High-Low-Close.
 

stevens157

New Member
Joined
Aug 3, 2005
Messages
27
It looks like it but I can't make them work. You have to use specific labels for the stock graphs.
 

Seti

Well-known Member
Joined
May 19, 2002
Messages
2,916
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
ABCDEF
1ABCDE
2H$5,539$8,885$8,680$3,038$8,377
3Min$2,225$4,781$4,651$1,633$4,651
4Max$6,407$9,930$9,916$3,432$9,391
5Average$4,677$7,126$6,884$2,657$6,663
Sheet2
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,455
Members
412,595
Latest member
slim313
Top