Here is my issue: We create income charts for clients that plot (using a stacked area chart) their future income (wages, social security, etc.) over time through the end of life. The left y axis shows income in hundreds of thousands of dollars.
My goal: to show tax brackets on the secondary (right) y-axis so that clients can see in any given year what bracket they are in (and over time, what brackets they may be pushed into depending on their plan). I don't care much whether the brackets show tick marks or dashed lines across the horizontal length of the chart (whatever easier).
Here is my data for the tax brackets:
Married Filling Jointly tax brackets
$0 10%
$17,850 15%
$72,500 25%
$146,400 28%
$223,050 33%
$398,350 35%
$450,000 39.60%
Now I can't figure out how to chart this data. I've gotten as far as charting a line from left to right and then displaying the bracket percentiles as labels, but I want to percentiles to show up like a secondary axis, not as data points in the chart.
Any ideas would be greatly appreciated.
Bookmarks