LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 371
Default Clustered column with secondary y-axis

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Label Max Value on Secondary Y-Axis Stacked Column Rutabaga Charts and Charting in Excel 4 August 24th 07 03:10 PM
Stacked/clustered column graph with secondary y axis [email protected] Charts and Charting in Excel 0 March 15th 07 02:57 PM
Stacked Column with Secondary Axis Mallik Rao Charts and Charting in Excel 1 March 6th 07 11:36 AM
Can I put a secondary axis on a 3-D column chart in MS Excel? jk432897 Charts and Charting in Excel 1 April 7th 06 12:57 AM
Align Clustered Column Chart Category Axis Labels Stephanie Charts and Charting in Excel 1 April 7th 05 03:21 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"