I would like to make a grouped bar chart with multiple levels of grouping as shown below -
I would like to have the character 'AR' in the graph. The data for the graph is attached with the post.
Col1 Col2 Col3 Col4
AR 1
AR 1100 0.5 2
AR 1100 1 3
5 1000 0.5 4
5 1000 1 5
5 1050 0.5 4
5 1050 1 5
5 1100 0.5 4
5 1100 1 5
15 1000 0.5 4
15 1000 1 5
15 1050 0.5 4
15 1050 1 5
15 1100 0.5 4
15 1100 1 5
Data from column 1 to 3 should be used for grouping on the X-Axis and the data on column 4 to be used for the height of the bars.
Is it possible to add prefixes or suffixes to the grouping like 0.5h or 1000 C or 5% ?