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
|
|||
|
|||
Combo Stacked column/column/line
I need to create a chart that shows series 1 & 2 as a stacked column, series
3 as it's own column, and series 4 as a line on a different axis. Example: I sell series 1 under my name Another person sells series 2, but it is considered my business. I want those 2 elements to be stacked so I can see total business I am getting credit for, and breakdown between who seels how much Series 3 is total company sales (coulmn) Series 4 is the percentage of my sales vs total sales. Can this be done? |
#2
|
|||
|
|||
Combo Stacked column/column/line
Have a look at
http://peltiertech.com/WordPress/clu...column-charts/ and http://people.stfx.ca/bliengme/ExcelTips/Columns.htm best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "TGags" wrote in message ... I need to create a chart that shows series 1 & 2 as a stacked column, series 3 as it's own column, and series 4 as a line on a different axis. Example: I sell series 1 under my name Another person sells series 2, but it is considered my business. I want those 2 elements to be stacked so I can see total business I am getting credit for, and breakdown between who seels how much Series 3 is total company sales (coulmn) Series 4 is the percentage of my sales vs total sales. Can this be done? |
Thread Tools | |
Display Modes | |
|
|