Prev: Pivot Table-Change Data Source? Excel 2007
Next: Plot area changed after reopen document
From: Jamal on 20 May 2010 01:11
I am trying to create a cost abatement curve where a bar represents a project
(eg. Electricity reduction) and:

- the length of the bar indicates the cost
- the width of the bar indicates the CO2e emission savings for the project

I am hoping to have multiple bars side by side to create a CO2e cost
abatement curve. I'm trying to create it in a way so that anyone can input
data and it would automatically update the chart. Any ideas anyone?
From: Luke M on 20 May 2010 11:06
Check this out for regular columns:
http://peltiertech.com/WordPress/variable-width-column-charts/

If you need variable width & stacked:
http://peltiertech.com/WordPress/marimekko-charts/

--
Best Regards,

Luke M
"Jamal" <Jamal(a)discussions.microsoft.com> wrote in message
news:ECDC76BC-8464-40AD-9DA3-64F695930E42(a)microsoft.com...
>I am trying to create a cost abatement curve where a bar represents a
>project
> (eg. Electricity reduction) and:
>
> - the length of the bar indicates the cost
> - the width of the bar indicates the CO2e emission savings for the project
>
> I am hoping to have multiple bars side by side to create a CO2e cost
> abatement curve. I'm trying to create it in a way so that anyone can input
> data and it would automatically update the chart. Any ideas anyone?


 | 
Pages: 1
Prev: Pivot Table-Change Data Source? Excel 2007
Next: Plot area changed after reopen document