G
Geoff
I am comparing two attributes...say height and mass...of six different
supplied products...say widgets.
I would like to make a clustered column chart so that each product is
side-by-side on the x-axis and that the attributes are indicated on the
y-axis.
The attributes, though, have different scales. For example, heights may
range from 20 to 40 cm and masses may range from 250 to 500 grams. So if they
are on the same y-axis, it is difficult to discern the difference in heights
of the products (without perhaps dividing all masses by 10 which I'm not to
keen on).
No problem. I add a secondary y-axis for mass (or height). However, when I
do this, one attribute gets superimposed over another. I've tried changing
the overlap and gap width of the columns, but this only changes the column
width and not their position on the x-axis.
Any ideas?
TIA...Geoff
(and Happy New year too!)
supplied products...say widgets.
I would like to make a clustered column chart so that each product is
side-by-side on the x-axis and that the attributes are indicated on the
y-axis.
The attributes, though, have different scales. For example, heights may
range from 20 to 40 cm and masses may range from 250 to 500 grams. So if they
are on the same y-axis, it is difficult to discern the difference in heights
of the products (without perhaps dividing all masses by 10 which I'm not to
keen on).
No problem. I add a secondary y-axis for mass (or height). However, when I
do this, one attribute gets superimposed over another. I've tried changing
the overlap and gap width of the columns, but this only changes the column
width and not their position on the x-axis.
Any ideas?
TIA...Geoff
(and Happy New year too!)