 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
Mac Forum / Applications / Excel / May 2008combination charts in excel
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: intel How to create a column chart for a set of data, then create a line chart for a different set but within the column chart. Using the same time frame. An example would be stock trading volume is column and stock price would be the line. > Version: 2008 > Operating System: Mac OS X 10.5 (Leopard) [quoted text clipped - 4 lines] > example would be stock trading volume is column and stock price would be the > line. IT's not easy, at least in OfficeX or 2004. About the most direct way I found is to load both sets of data into one of the existing 'combination charts' via the chart wizard. Then click on one of the data lines, or bars, in the chart and go to Chart Type and select the type of chart you want for that data set. Ditto for the other if you want to change both. Once you have it the way you like, be sure to save it as a Custom Chart Type so you don't have to recreate it. I hope :-) other experts have a faster or easier way to do this. Carl  SignatureTeam EM to the rescue! http://www.team-em.com |
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.