Excel Bar Graph Grouping. Insert Column or Bar Chart. After arranging the data select the data range that you want to create a chart based on and then click Insert.
See below screen shot. Right click the data series bar and then choose Format Data Series see screenshot. A dialog box for grouping will open.
This is how the group dates in Pivot Table by week will be displayed.
The complicating issue the that your sub categories are mutually exclusive so formatting the graph to group sub categories together will cause your boat category to have a space on the bar graph for 1 engine Car sub category which by definition will be 0. Create a stacked clustered column chart in Excel. Use ChartGroups index where index is the chart-group index number to return a single ChartGroup object. The complicating issue the that your sub categories are mutually exclusive so formatting the graph to group sub categories together will cause your boat category to have a space on the bar graph for 1 engine Car sub category which by definition will be 0.
