wendy823
New member
- Joined
- May 17, 2021
- Messages
- 3
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- office 365
*****hey all, this was the only place that seemed relevant. if there is a better place to post this, please feel free to move it******
Each week I update the target prices for 75-100 stocks. I need to see over time how these target prices are trending. I've attached a s'sheet of one example I put together. BUT do I need to create a separate graph for each of the 75-100 stocks? I would prefer a graph, but if I could do it through some lookup function that returns a calculation that shows me the price change, that might suffice.
Each week I update the target prices for 75-100 stocks. I need to see over time how these target prices are trending. I've attached a s'sheet of one example I put together. BUT do I need to create a separate graph for each of the 75-100 stocks? I would prefer a graph, but if I could do it through some lookup function that returns a calculation that shows me the price change, that might suffice.