dnicholsby
New Member
- Joined
- Jan 24, 2017
- Messages
- 26
hi,
I am trying to create a chart that contains both a clustered and a stacked bar chart. The stacked bar chart contains balance sheet data of two segments of a company in 2017. I also have the combined data as at 2018 so I want the 2017 and 2018 data to be a clustered bar chart for comparison. Is this possible? Data is attached
<tbody>
</tbody>
So the GWM and GSG data needs to be combined in a stacked column and you will have 6 different bar charts for each row. I then want to add the 2018 data next to the 2017 data for comparison.
I am trying to create a chart that contains both a clustered and a stacked bar chart. The stacked bar chart contains balance sheet data of two segments of a company in 2017. I also have the combined data as at 2018 so I want the 2017 and 2018 data to be a clustered bar chart for comparison. Is this possible? Data is attached
2017 | 2017 | 2018 | |||||
GWM | GSG | Combined | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | 0 | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
So the GWM and GSG data needs to be combined in a stacked column and you will have 6 different bar charts for each row. I then want to add the 2018 data next to the 2017 data for comparison.