I have been monitoring my power usage in Excel. But I notice I have forgotten some of the graph tricks to get the data presented to my liking.
I have two sets annual data for power purchased and power sold. So in total there are 4 rows for 12 months. Now I would like to convert this to a something I would call a double stacked chart where the 2021 monthly stacks are seperate from the 2022 stacks.
This is the regular chart without stacking (for 2021 the return is 0):
So basically the grey column should be below the orange column.
I have been googling for a while but most of the examples are for sales data for a just few quarters that include a lot of empty cells and when I try to apply it as a combined chart with secondary axis it becomes a bit of a mess.
Any tips?
I have two sets annual data for power purchased and power sold. So in total there are 4 rows for 12 months. Now I would like to convert this to a something I would call a double stacked chart where the 2021 monthly stacks are seperate from the 2022 stacks.
This is the regular chart without stacking (for 2021 the return is 0):
So basically the grey column should be below the orange column.
I have been googling for a while but most of the examples are for sales data for a just few quarters that include a lot of empty cells and when I try to apply it as a combined chart with secondary axis it becomes a bit of a mess.
Any tips?
