 |
 | 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 / April 2008Combination chart - Column + Line with reverse category on Office
Hi, Need help on the following: Able to create a combination chart of Column (Primary vertical axis) and Line (Secondary vertical axis). When I select reverse categories for the horizontal axis, only the data for Column is reversed, the line remain the same. How can I circumvent this ? Thanks very much ... EK Hi, Assuming xl2007. It would appear you need to add a secondary category axis and also set that to be in reverse order. Cheers Andy  SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info > Hi, > [quoted text clipped - 6 lines] > How can I circumvent this ? > Thanks very much ... EK Hi, Andy, Thanks very much. I am using xl2007. Cool .. it worked. If I used a 100% stacked column, is it possible to display the % share inside the column similar to that of the pie chart without having to calculate it and if so, how ? EK > Hi, > [quoted text clipped - 15 lines] > > How can I circumvent this ? > > Thanks very much ... EK You need to calculate the %'s. and then either plot those values or use this free addin to link data labels with cells. Rob Bovey's Chart Labeler,http://appspro.com Cheers Andy SignatureAndy Pope, Microsoft MVP - Excel http://www.andypope.info > Hi, Andy, Thanks very much. I am using xl2007. Cool .. it worked. > [quoted text clipped - 26 lines] >> > How can I circumvent this ? >> > Thanks very much ... EK |
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
|
©2009 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.