Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Marginal Abatement Cost - Creating a column chart
I want to create a marginal abatement cost (MAC) column chart in Excel 2003.
The data I am using is sorted for cost ($/tonne/year). Then I have a marginal abatement (tonnes of CO2-e) and cumulative marginal abatement (also tonnes of CO2-e). On the x axis I will have cost. The y axis shall be marginal abatement, the width of the columns shall represent the marginal abatement, and their location on the axis will be determined by the cumulative marginal abatement. Since the data is sorted for cost, the chart shall show increasing cost with an increasing cumulative marginal abatement. Can anyone suggest a way of creating this column chart in Excel 2003? Thanks |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Marginal Abatement Cost - Creating a column chart
Hi,
I don't think it is possible in Excel to control the column widths based on a value, in any version. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ErinC" wrote: I want to create a marginal abatement cost (MAC) column chart in Excel 2003. The data I am using is sorted for cost ($/tonne/year). Then I have a marginal abatement (tonnes of CO2-e) and cumulative marginal abatement (also tonnes of CO2-e). On the x axis I will have cost. The y axis shall be marginal abatement, the width of the columns shall represent the marginal abatement, and their location on the axis will be determined by the cumulative marginal abatement. Since the data is sorted for cost, the chart shall show increasing cost with an increasing cumulative marginal abatement. Can anyone suggest a way of creating this column chart in Excel 2003? Thanks |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Marginal Abatement Cost - Creating a column chart
This might help:
http://peltiertech.com/Excel/Charts/VarWidthColumn.html Eric "ErinC" wrote: I want to create a marginal abatement cost (MAC) column chart in Excel 2003. The data I am using is sorted for cost ($/tonne/year). Then I have a marginal abatement (tonnes of CO2-e) and cumulative marginal abatement (also tonnes of CO2-e). On the x axis I will have cost. The y axis shall be marginal abatement, the width of the columns shall represent the marginal abatement, and their location on the axis will be determined by the cumulative marginal abatement. Since the data is sorted for cost, the chart shall show increasing cost with an increasing cumulative marginal abatement. Can anyone suggest a way of creating this column chart in Excel 2003? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating a mix of column and scatter chart on one chart. | Charts and Charting in Excel | |||
Creating a clustered column chart | Charts and Charting in Excel | |||
Creating a Utility Cost calculator | Excel Discussion (Misc queries) | |||
Creating lookup formulas for material cost spreadsheet | Excel Worksheet Functions | |||
Help creating a cost range | Excel Discussion (Misc queries) |