Marginal Abatement Cost - Creating a column chart

E

ErinC

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
 
S

Shane Devenshire

Hi,

I don't think it is possible in Excel to control the column widths based on
a value, in any version.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top