Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using two Block Charts for a side by side comparison of market versus sales - how can I align the axis of each chart so that the block sizes are comparable?
Regards
Marty.
Perhaps a bar chart will work better. Or perhaps you can use the Trellis option on the Dimensions tab.
Hi,
Or maybe a grid chart (3 dimensions here, the minimum - 1 synthetic assuming your market & sales are in different fields);
Otherwise I think you are looking at macros to manipulate the size of the object.
Cheers,
Chris.
Hi,
While putting off doing something I really ought to I took a look at the macro … so the attached manipulates the sizes of the objects. It does not take into account the white space, so you get a slightly distorted sizes, that could probably be fixed by tweaking the formulae, but the effect is Ok;
Cheers,
Chris.
Perhaps use Market/Sales as the first dimension. That would render two blocks in the same chart with the same scale.
-Rob