I have a data table that tracks the probabilistic forecasts of the Federal Reserve interest rate changes. Each day there is a probability that the rate go lower by a certain data...that it will stay the same...or that it will go higher.
So I have three rows:
HigherEvery day I add a column for that day's probabilities, and enter three probabilities. And I created a bar chart that shows the relative percent of each probability.
Same
Lower
The problem is that the bar chart shows the "Lower" portion at the top of each bar, and the "Higher" portion at the bottom of each bar. Here is an image.
Interest Rate Forecasts.png
As you can see, the blue "Higher" is at the bottom of each bar, and the green "Lower" at the top.
I have tried everything that I can think of, to no avail. I am using Excel 2011 for Mac.
Bookmarks