Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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!) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Label Max Value on Secondary Y-Axis Stacked Column | Charts and Charting in Excel | |||
Stacked/clustered column graph with secondary y axis | Charts and Charting in Excel | |||
Stacked Column with Secondary Axis | Charts and Charting in Excel | |||
Can I put a secondary axis on a 3-D column chart in MS Excel? | Charts and Charting in Excel | |||
Align Clustered Column Chart Category Axis Labels | Charts and Charting in Excel |