Categories option not available in combination chart

You can't in standard chart using Excel range/table as data source/range. Using filter option, you can only add or remove series (i.e. not axis values).

You could use pivot table to summarize data and use pivot chart. It will give you option to filter on axis values (categorical or linear type).

Alternately, you could use formula and named range to create dynamic range to supply to the chart, or create intermediate table using formula to feed data to the chart.