| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Help in Developing a Multi-Level Gross Margin Chart
Gross Margin (GM) is a component of two primary variables, Revenue and Cost
(COGS). I wish to plot a Line chart with months at the bottom (X-axis) and GM $'s or % on the Y-axis and at the same time reflect changes in both Revenue and COGS per the value of GM per that month. This way one I can plot another Line chart with historical GM (Rev & COGS) and show both components within one data point. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering formulas gross margin % divide by Week Total Sales | Excel Worksheet Functions | |||
| Calculation of Gross Margin in a pivot table | Excel Worksheet Functions | |||
| Developing custom chart add-in | Charts and Charting in Excel | |||
| gross profit margin formula | Excel Discussion (Misc queries) | |||
| How do I make a column that calculates gross margin percentage | Excel Worksheet Functions | |||
Linear Mode
