randomwalker
Board Regular
- Joined
- Feb 22, 2007
- Messages
- 169
Hi,
I have a data table. C42 to C46 are growth rates (g) while D41 to H41 are WACCs(weighted average cost of capital). The rates in C42 to C46 are 2.0%, 2.5%, 3.0%, 3.5% and 4.0% while that rates in D41 to H41 are 6.0%, 7.9%, 9.5%, 9.9% and 10.9%. From D42 to H46 are stock prices. For example, D42 is 5.50, E43 is 3.40, etc. My question is that if I plot the values in C42 to C46 as the Y axis and the values in D41 to H41 as X axis, what can I do to plot the values in D42 to H46 in the graph? That's to say there are 25 data points (not including X axis and Y axis) in the graph. For example, the data point 5.50 corresponds to the 2.0% on X axis and 6.0% on Y axis.
Thank you guys!
I have a data table. C42 to C46 are growth rates (g) while D41 to H41 are WACCs(weighted average cost of capital). The rates in C42 to C46 are 2.0%, 2.5%, 3.0%, 3.5% and 4.0% while that rates in D41 to H41 are 6.0%, 7.9%, 9.5%, 9.9% and 10.9%. From D42 to H46 are stock prices. For example, D42 is 5.50, E43 is 3.40, etc. My question is that if I plot the values in C42 to C46 as the Y axis and the values in D41 to H41 as X axis, what can I do to plot the values in D42 to H46 in the graph? That's to say there are 25 data points (not including X axis and Y axis) in the graph. For example, the data point 5.50 corresponds to the 2.0% on X axis and 6.0% on Y axis.
Thank you guys!