I am working on a school project and i need some help creating graphs on Microsoft excel. There is a set of data similar to: Date Close High Low 1-4-06 35 37 33 5-4-06 33 37 31 9-4-06 36 39 32 13-4-06 34 36 32 This is a graph about stock prices and I need to create a graph that looks like this in MS Excel: I want to know how to create a craph like that where the close price is plotted and connected with a line and the high and low of the corresponding date are connected to each other with a straight line. Thanks for any help!
I would help, but all we do in my school on excel is calculations and regular graphs. Sorry. I would love to see someone tell you though
maybe these will help? sorry I'm not good with graphing on excel! http://www.ncsu.edu/labwrite/res/gt/gt-menu.html http://www.mrexcel.com/archive/Chart/index.html