Merle Haggard
New Member
- Joined
- Dec 5, 2007
- Messages
- 3
I'm have a Stacked Bar graph using this data.
MW
Wind 27
Hydro 3,579
Nuclear 12,070
Coal 32,875
Renew 103
Gas 45,443
LOil 351
When I set this up in Excel, it looks fine, the data is set to columns and the x-axis gives accurate representation and scale from 0 to 10,000 MW. I have a line graph that I'm attempting to overlay in front of the stacked bar graph, but I can't get the axes setup correctly. I'm trying to get the Marginal Cost on the right axis and have the points plotted based on the Cumulative Capacity, but show only the axis used by the bar chart and still have it plotted correctly along the bottom axis. Btw, I have 1,000 data points for this line. Any thoughts?
Cumulative
Capacity
MW Total Marginal Cost $/MWh
0.12 0
0.24 0
0.243 0
0.245 0
0.365 0
4.985 0
11.705 0
17.105 0
27.185 0
38.585 0.48
54.185 0.48
... ...
94448.409 358.8300174
MW
Wind 27
Hydro 3,579
Nuclear 12,070
Coal 32,875
Renew 103
Gas 45,443
LOil 351
When I set this up in Excel, it looks fine, the data is set to columns and the x-axis gives accurate representation and scale from 0 to 10,000 MW. I have a line graph that I'm attempting to overlay in front of the stacked bar graph, but I can't get the axes setup correctly. I'm trying to get the Marginal Cost on the right axis and have the points plotted based on the Cumulative Capacity, but show only the axis used by the bar chart and still have it plotted correctly along the bottom axis. Btw, I have 1,000 data points for this line. Any thoughts?
Cumulative
Capacity
MW Total Marginal Cost $/MWh
0.12 0
0.24 0
0.243 0
0.245 0
0.365 0
4.985 0
11.705 0
17.105 0
27.185 0
38.585 0.48
54.185 0.48
... ...
94448.409 358.8300174