Data manipulated in Excel to calculate percent changes.
Chart designed in Microsoft PPT.
I really like the variable width bars for situations where the weights are different. I have not persuaded Excel to generate such a figure based on width and height columns in the spreadsheet. What is the secret?
Bear in mind the majority of the housing component is a synthetic number known as “owners equivalent rent” which attempts to quantify the value of a home on the rental market. Since the majority of American households own homes with a 30yr fixed mortgage this number can be quite divorced from reality. The OER number for a house may go up 50%.. but the owners actual payments don’t increase at all.
I liked this one — the ordering of the bars doesn’t appear to have a reason, though, and I’d go with importance (width) high to low (with other last).
What’s wage inflation in the same period?
Good visual. Clean simple and gets the point across efficiently.
![[OC] Weighted Change in CPI Categories since January 2020](https://www.europesays.com/wp-content/uploads/2024/07/5n0l3n3wloed1-1920x1024.jpeg)
6 comments
SOURCE: Data Sourced From FRED and BLS:
[Median Earnings](https://fred.stlouisfed.org/series/LES1252881500Q)
[Relative Weights](https://www.bls.gov/cpi/tables/relative-importance/2021.htm)
[CPI Categories](https://fred.stlouisfed.org/release/tables?rid=10&eid=34483)
TOOLS:
Data manipulated in Excel to calculate percent changes.
Chart designed in Microsoft PPT.
I really like the variable width bars for situations where the weights are different. I have not persuaded Excel to generate such a figure based on width and height columns in the spreadsheet. What is the secret?
Bear in mind the majority of the housing component is a synthetic number known as “owners equivalent rent” which attempts to quantify the value of a home on the rental market. Since the majority of American households own homes with a 30yr fixed mortgage this number can be quite divorced from reality. The OER number for a house may go up 50%.. but the owners actual payments don’t increase at all.
I liked this one — the ordering of the bars doesn’t appear to have a reason, though, and I’d go with importance (width) high to low (with other last).
What’s wage inflation in the same period?
Good visual. Clean simple and gets the point across efficiently.