If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Combination Charts
I am trying to build a chart that contains stacked columns and standard
columns. I have two sets of data: 1) 2005 sales by month for 6 categories (need for stacked chart) 2) 2006 total sales projection by month (need for standard columns). I want to put the like monthly columns (ie: stacked January 2005 sales, standard January 2006 sales projection) side by side for the entire year. I checked out the custom chart option but couldn't determine how to get to the above. Any suggestions? Mark |
#2
|
|||
|
|||
Combination Charts
See Stephen Bullen's Funchrt4.zip at
http://www.oaltd.co.uk/excel/SBXLPage.asp#Charting -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I am trying to build a chart that contains stacked columns and standard columns. I have two sets of data: 1) 2005 sales by month for 6 categories (need for stacked chart) 2) 2006 total sales projection by month (need for standard columns). I want to put the like monthly columns (ie: stacked January 2005 sales, standard January 2006 sales projection) side by side for the entire year. I checked out the custom chart option but couldn't determine how to get to the above. Any suggestions? Mark |
#3
|
|||
|
|||
Combination Charts
This page has links to a few examples of clustered-stacked column charts:
http://peltiertech.com/Excel/ChartsH...sterStack.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "excel_user123456" wrote in message ... I am trying to build a chart that contains stacked columns and standard columns. I have two sets of data: 1) 2005 sales by month for 6 categories (need for stacked chart) 2) 2006 total sales projection by month (need for standard columns). I want to put the like monthly columns (ie: stacked January 2005 sales, standard January 2006 sales projection) side by side for the entire year. I checked out the custom chart option but couldn't determine how to get to the above. Any suggestions? Mark |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How lines in combination charts treat #N/A values | Bernard Harris | Charts and Charting | 1 | February 16th, 2006 04:15 AM |
combination charts - multiple columns | Colin Whiston | Charts and Charting | 1 | January 25th, 2006 11:54 AM |
Combination Charts | Cindy Garcia | Charts and Charting | 3 | June 2nd, 2004 10:34 PM |
Combination charts | ischnura | Charts and Charting | 1 | January 24th, 2004 06:07 PM |
Combination line and stacked bar charts | Ian | Charts and Charting | 2 | October 15th, 2003 05:28 PM |