Hi,
I am trying to create an Excel 2003 stock chart and it is working fine if I just enter random values for the open, high, low and close.
However I want to point to another cell for the correct values. For example =A1 for Open, =B1, for High, ect. Because in those cells are values determined by a formula, and they change based on some things.
However it is not working. And I know it is exactly that which is not working. Because if I just erase the =A1, =B1, ect and put instead random values like 1, or 2 then the chart works.
What can I do to make this work? I would also like to point out that the chart is not going to be dynamic in that the number of bars used will be different. They will always be the same amount, and the values always taken from the same location.
Any help would be greatly appreciated!
The only thing that comes to my mind is to create some kind of macro that copy pastes the values from A1, B1, ect. To the cells that the chart uses. And somehow make it do that over and over again when the values change.
Bookmarks