Hi,
I am trying to create a graph using the below two data points -
1. Balance sheet amount (in USD)
2. Rate of Return (in basis points)
These two data points are calculated for each business day on a daily basis. Each file contains only two values (balance sheet and rate as of that business day only). I want the graph to-
1. Plot the Balance sheet amount as a bar column and the corresponding rate of return as a line (on the 2nd Y axis).
2. Plot the data points for only the last 30 days at any given point in time in the same graph (though each day's file does not contain historical data for these two data points).
I assume there would have to be another sheet to store historical data for the graph.
Appreciate if anyone could provide any insights.
Thanks
ardent_guy
Bookmarks