 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / September 2004Help! Combination Column Chart
I have three data series: A, B and C. B is a subset of A. I want to stack An and B have a separate column for C. I don't need, and prefer not to have, a separate Y axis for C. Have tried everything and can't figure it out Thanks Group! If you stagger your data, you can create side-by-side stacked columns. Bernard Liengme has an example and instructions on his site: http://www.stfx.ca/people/bliengme/ExcelTips/Columns.htm and Jon Peltier has links to other sites with information: http://peltiertech.com/Excel/ChartsHowTo/ClusterStack.html > I have three data series: A, B and C. B is a subset of A. I want to > stack An and B have a separate column for C. I don't need, and prefer > not to have, a separate Y axis for C. Have tried everything and can't > figure it out Thanks Group!  SignatureDebra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html If the only reason for not using a secondary Y axis is that you don't want it to be visible, do you know that you can but make it not visible? (Format the axis: using the Patterns tab, select none, none, none, none.) Al >-----Original Message----- >I have three data series: A, B and C. B is a subset of A. I want to >stack An and B have a separate column for C. I don't need, and prefer >not to have, a separate Y axis for C. Have tried everything and can't >figure it out Thanks Group! >. In fact, you can tell Excel to plot a series on the secondary axis, then use Chart Options to clear the secondary axis. The chart still knows the series in in the secondary axis group, so it will not be plotted as a member of the first axis group. This means you don't have to keep unhiding the secondary axis to make its scale match the primary scale. This isn't how I'd do the stacked clustered column chart, though. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > If the only reason for not using a secondary Y axis is > that you don't want it to be visible, do you know that you [quoted text clipped - 18 lines] >>figure it out Thanks Group! >>. |
Reply to this Message |
 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.