-
1. Re: Showing % Difference on Dual Axis
Shawn Wallwork Feb 7, 2012 1:16 PM (in response to randallmiller)Randall, you can do it if you can live with a fixed axis. (See attached.) Your sample data has one value at -24.71% so when the axis is set to Auto the scale goes low enough to show all the values. If your actual data only has -5% that will be the start of your scale. Or you can fix it a -5% either way. To get the image you posted the important thing is to fix the thousands scale. Hope this can work for you.
--Shawn
-
RollingSalesEx-SW.twbx.zip 1.1 MB
-
-
2. Re: Showing % Difference on Dual Axis
randallmiller Feb 7, 2012 1:22 PM (in response to Shawn Wallwork)Exactly what I wanted. Didn't think of fixing the other axis. Thanks!
One more quick question: If I fix this axis to a maximum value... I am guessing if sales start growing above that Max I would need to re-adjust?
-
3. Re: Showing % Difference on Dual Axis
Shawn Wallwork Feb 7, 2012 1:45 PM (in response to randallmiller)Yep, that's the only down side to a fixed axis. You can fix it higher than the highest value in your chart so you can account for anticipated growth. It would be nice if you could fix the start and leave the end to float with the data. If you put this in ideas forum I'd vote it up
--Shawn