dual scale chart--How to set goal on second scale
Set goal on second scale:
I have a dual scale chart (Grouped bar + line)
I want the goal to be set on the right axis (the grouped bar).
Right now the only the Y-axis field (the line) offers the goal option.
I know that I can set the goal based on the left axis.
2 issues with that:
a) The scales are thousands:single digits
b) The thousands scale is constantly shifting with dataset updates. I don't want to have to baby sit that computation.