Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Input a Value to Lookup the Data Series for a Chart
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cant input series data | Charts and Charting in Excel | |||
chart with two data series and two colors for each data series | Charts and Charting in Excel | |||
Lookup function with condition in time series data | Excel Worksheet Functions | |||
automatically expand chart data series as data is added | Charts and Charting in Excel | |||
chart data series -- plot a table as a single series | Charts and Charting in Excel |