Excel offers a few ways to stack or cluster data series in a chart, depending on the desired visual representation:

1. Stacked Column Chart:

This is the most common way to show how parts contribute to a whole.

* Select your data range.
* Go to the "Insert" tab.
* In the "Charts" group, click the "Stacked Column" chart icon.

2. Clustered Column Chart:

This compares values across different categories while keeping the series separate.

* Select your data range.
* Go to the "Insert" tab.
* In the "Charts" group, click the "Clustered Column" chart icon.

3. Combo Chart for Stacking and Clustering:

Excel doesn't have a built-in "stacked and clustered" chart type. However, you can create a combo chart to achieve this effect.

* Select your data range.
* Go to the "Insert" tab.
* In the "Charts" group, click the "Insert Chart" dropdown menu.
* Choose a chart type for your clustered data (e.g., Clustered Column).
* Right-click on one of the data series you want to stack and select "Change Series Chart Type".
* Choose "Stacked Column" from the available options.

This will create a chart where some series are clustered (represented by bars next to each other) and others are stacked on top of each other within the same bar.

Additional Tips:

* You can customize the appearance of your stacked or clustered chart by right-clicking on chart elements and selecting formatting options.
* Ensure your data is organized correctly for stacking or clustering. Each category should have separate columns with values for each data series.
* Experiment with different chart types (e.g., stacked bar, line) to see which best represents your data.