This seems like it should be so simple, but I'm not having any luck. Apologies if this is on the site somewhere - if so, I'm not finding it.
I'm trying to create a simple bar chart. I want only one bar showing the percent of programs that have been completed, let's say it's 22%. On the left axis I want units to be 0% (floor), 25%, 50%, 75% and 100% - this represents how many programs have been completed vs. how many are planned (planned = 100%, completed in this example = 22%). I can get these two steps done with no problem - my bar and my left axis.
Now I want to have a secondary vertical (right) axis with units Q0 (floor), Q1, Q2, Q3, Q4, corresponding to the percentages in the left axis. It's just a visualization to see that by Q1 we should be at 25% completion, by Q2 we should be at 50% completion, etc.
I cannot figure out how to get that right axis in and showing the units I need.
Any help would be greatly appreciated!
I'm trying to create a simple bar chart. I want only one bar showing the percent of programs that have been completed, let's say it's 22%. On the left axis I want units to be 0% (floor), 25%, 50%, 75% and 100% - this represents how many programs have been completed vs. how many are planned (planned = 100%, completed in this example = 22%). I can get these two steps done with no problem - my bar and my left axis.
Now I want to have a secondary vertical (right) axis with units Q0 (floor), Q1, Q2, Q3, Q4, corresponding to the percentages in the left axis. It's just a visualization to see that by Q1 we should be at 25% completion, by Q2 we should be at 50% completion, etc.
I cannot figure out how to get that right axis in and showing the units I need.
Any help would be greatly appreciated!
