Excel can do many things than you think !
Use your tricks to make nice plots !
Examples provided are regular menu driven - no programming skills needed.
Think about extending your graphical capabilties in science and business.
Comments and shares are welcome !
Excel has very nice functions to plot stocks. Here is an example on how to plot Open-high-low-close type stock plot. We need the columns in same order - date, followed by open-high-low-close. Under stock select stock and subtype: open-high-low-close .
Now we got the plot:
Now policing the plot to get final product. Now we can format the data series display and color etc. We might want to get rid of legend.
In similar way we can create High-low-close type stock chart.