D
DaveM
Hello;
I have a very simple chart (line) that I want to plot one series of data
which comes from a large range of stock symbols (6000). Col A is the symbol
in Alpha order, while col B, C, D, E, F....is the stock price at the end of
the week closing price. The first row of the range is the weekending date.
The data range looks like this...
A B C D.......
Symbol 7/17 7/10 7/3 .......
AA 5.43 6.00 6.23 ....
ABC 22.10 22.55 23.01.....
How could i input the stock's symbol on a worksheet where the chart is, have
it lookup that symbol and then plot the values in a line chart type? The y
axis on the chart is price while the x axis is the weekending dates
Thanks
DaveM
I have a very simple chart (line) that I want to plot one series of data
which comes from a large range of stock symbols (6000). Col A is the symbol
in Alpha order, while col B, C, D, E, F....is the stock price at the end of
the week closing price. The first row of the range is the weekending date.
The data range looks like this...
A B C D.......
Symbol 7/17 7/10 7/3 .......
AA 5.43 6.00 6.23 ....
ABC 22.10 22.55 23.01.....
How could i input the stock's symbol on a worksheet where the chart is, have
it lookup that symbol and then plot the values in a line chart type? The y
axis on the chart is price while the x axis is the weekending dates
Thanks
DaveM