3 D Graph for 3 sets of data points

[kaushik123]

Hello

I need to plot a cumulative chart that incorporates 3 different scenarios each having 3 data points (last scenario has 1 additional data point). Putting up the data here. The columns are years.


[TABLE="width: 705"]
<tbody>[TR]
[TD="colspan: 5"]Scenario 1 Power Consumption by Location[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"]2013
[/TD]
[TD="align: right"]2014
[/TD]
[TD="align: right"]2015[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]2019[/TD]
[TD="align: right"]2020
[/TD]
[TD="align: right"]2021[/TD]
[TD="align: right"]2022[/TD]
[/TR]
[TR]
[TD]Site 1[/TD]
[TD="align: right"]475[/TD]
[TD="align: right"]1075[/TD]
[TD="align: right"]1271[/TD]
[TD="align: right"]2346[/TD]
[TD="align: right"]3600[/TD]
[TD="align: right"]3780[/TD]
[TD="align: right"]3969[/TD]
[TD="align: right"]4167[/TD]
[TD="align: right"]4292[/TD]
[TD="align: right"]4421[/TD]
[/TR]
[TR]
[TD]Site 2[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Site 3[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]731[/TD]
[TD="align: right"]860[/TD]
[TD="align: right"]1032[/TD]
[TD="align: right"]1135[/TD]
[TD="align: right"]1238[/TD]
[TD="align: right"]1342[/TD]
[TD="align: right"]1445[/TD]
[TD="align: right"]1548[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 705"]
<tbody>[TR]
[TD="colspan: 5"]Scenario 2 Power Consumption by Location[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]Site 1[/TD]
[TD="align: right"]475[/TD]
[TD="align: right"]1091[/TD]
[TD="align: right"]440[/TD]
[TD="align: right"]536[/TD]
[TD="align: right"]880[/TD]
[TD="align: right"]968[/TD]
[TD="align: right"]1056[/TD]
[TD="align: right"]1144[/TD]
[TD="align: right"]1232[/TD]
[TD="align: right"]1320[/TD]
[/TR]
[TR]
[TD]Site 2[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]158[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Site 3[/TD]
[TD="align: right"]912[/TD]
[TD="align: right"]738[/TD]
[TD="align: right"]1728[/TD]
[TD="align: right"]2214[/TD]
[TD="align: right"]2700[/TD]
[TD="align: right"]2970[/TD]
[TD="align: right"]3240[/TD]
[TD="align: right"]3510[/TD]
[TD="align: right"]3780[/TD]
[TD="align: right"]4050[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Scenario 3 Power Consumption by Location[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Site 1[/TD]
[TD="align: right"]475[/TD]
[TD="align: right"]708[/TD]
[TD="align: right"]1236[/TD]
[TD="align: right"]1236[/TD]
[TD="align: right"]800[/TD]
[TD="align: right"]880[/TD]
[TD="align: right"]960[/TD]
[TD="align: right"]1040[/TD]
[TD="align: right"]1120[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD]Site 2[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]390[/TD]
[TD="align: right"]326[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Site 3[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]654[/TD]
[TD="align: right"]731[/TD]
[TD="align: right"]860[/TD]
[TD="align: right"]1032[/TD]
[TD="align: right"]1135[/TD]
[TD="align: right"]1238[/TD]
[TD="align: right"]1342[/TD]
[TD="align: right"]1445[/TD]
[TD="align: right"]1548[/TD]
[/TR]
[TR]
[TD]Site 4[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]0[/TD]
[TD="align: right"]2700[/TD]
[TD="align: right"]2970[/TD]
[TD="align: right"]3240[/TD]
[TD="align: right"]3510[/TD]
[TD="align: right"]3780[/TD]
[TD="align: right"]4050[/TD]
[/TR]
</tbody>[/TABLE]

I need to build one chart that incorporates this analysis. X axis being time, Y axis being power consumption and the z-axis being the grouping of locations (need to have individual locations called out in the grouping)

Can anyone help give me some ideas? I have Excel 2013

Thanks

 

[Steve=True]

Hi kaushik123,
Welcome to the forums

I think if you rearrange your data slightly and then graph it, Excel will group it for your. Here is how I would set up the data and my sample chart for you.

Let me know what you think.
You can make it 3D if you like, but it may cause more confusion than it is worth.

Steve=True

 

[kaushik123]

Steve,

Thank you so much! THis is great! Is there a way to make the scenarios as the grouping as opposed to the sites? Meaning I'd like individual sites displayed in each scenario as opposed to scenario. Basically the X-axis would be scenario1 (site 1, site 2, site 3) then scenario 2 (site 1, site, 2 and 3) and so on

Hi kaushik123,
Welcome to the forums

I think if you rearrange your data slightly and then graph it, Excel will group it for your. Here is how I would set up the data and my sample chart for you.

Let me know what you think.
You can make it 3D if you like, but it may cause more confusion than it is worth.

Steve=True

 

[Steve=True]

Hi kaushik123

You just need to rearrange your data.

Here it is redone in that order.

Here is a linek that shows you a little more on axis groupings:Dashboard Design for Excel Chart Templates using Groupings | Excel Dashboard Templates
Let me know if it helps.

Steve=True