Create a Column Column Chart by combining a clustered column chart for individual category data with a totals series using Excel’s combination chart feature.

Once your categories are defined, create a table in Excel or Google Sheets to organize your data. Formatting the data as a table ensures that it dynamically updates when new entries are added.