Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2007

Tip: Looking for answers? Try searching our database.

Clustered column with secondary y-axis

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Geoff - 27 Dec 2007 17:51 GMT
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!)
Jon Peltier - 27 Dec 2007 18:13 GMT
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

>I am comparing two attributes...say height and mass...of six different
> supplied products...say widgets.
[quoted text clipped - 22 lines]
>
> (and Happy New year too!)
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.