Hello,
I am implementing some formulae of stock market in excel and trying to get graphs of them.
I am attaching the workbook where I have some problems.
1. In the workbook attached, I want to draw both graphs (sheets named as II Dimension, III Dimension in attachment) in same sheet one below another for comparative study.
2. In the graph (II Dimension, III Dimension) I want to change the color of each vertical bar(high-low line) as green, red or grey depending upon the values.
For ex, in the AO column, if say, (n+1)th element has higher value than that of nth element of the same column, it's corresponding high-low line will be green.
3. The graph ( sheet named as I Dimension) is stock chart with columns high low and close represented by high-low line. Can I add one more column 'open' to it such that this 'open' value will be represented by horizontal small bar on the high low line itself?
Please let me know the solution to these problems.
Bookmarks