Hey folks, I'm new here, but I have an issue. First of all, I know there's no adequate way to add a third axis in Excel. Buuuuut maybe there's another elegant way to solve my issue. Please, check this out:
6rmRD9f.jpg
See how I already use two axis to display percentage of the change between 2016 and 2017 to give the smoother feel of what it really looks like.
My concern, obviously is that because I did that "hack" in red, now all the other bars got moved to the right of their corresponding areas on the graphs. Sure enough, if I have the red bar on another axis, the issue kinda disappears.
Maybe there's an elegant way to stop Excel from putting the placeholder for the red bar in each month?
Thanks!
Bookmarks