There are two main ways to create a chart with multiple data series in Excel:

1. Using the Chart Wizard:

1. Select your data: Highlight the range of cells that includes your data for both the x-axis (categories) and y-axis (values) for each series. This should include your data labels (headers) as well.
2. Insert Chart: Go to the "Insert" tab on the Excel ribbon. In the "Charts" group, click the "Recommended Charts" button or the specific chart type you prefer (e.g., Column, Line, Bar).
3. Choose a Chart Type: A variety of chart types will be displayed. Choose the one that best represents your data. Consider factors like comparing trends over time (line chart) or comparing categories (column chart).
4. Multiple Series: By default, Excel will often try to create a chart with multiple data series if it detects them in your selected data range.
5. Customize (Optional): Once the chart is created, you can customize its appearance using the options on the "Chart Design" and "Format" tabs on the ribbon. You can change colors, add data labels, modify the legend, and more.

2. Manually Adding Data Series:

1. Create a basic chart: Start by creating a chart with a single data series using the method above or another chart type.
2. Select the Chart: Click on the chart to activate the "Chart Tools" contextual tab on the ribbon.
3. Select Data: Go to the "Chart Design" tab. In the "Analyze" group, click the "Select Data" button.
4. Add Data Series: In the "Select Data Source" window, click the "Add" button.
5. Define Series: Specify the cell range for the new data series values in the "Series values" field. You can also adjust the series name in the "Series name" field.
6. Repeat (Optional): Click "OK" to add the series. You can repeat steps 4-6 to add additional data series to your chart.
7. Formatting (Optional): Similar to method 1, you can customize the chart appearance using the "Chart Design" and "Format" tabs.

Tips:

* Ensure your data is organized correctly with labels and corresponding values for each series.
* Experiment with different chart types to find the best visual representation for your data.
* Use clear and concise data labels and a legend to enhance readability.
* Customize chart elements like colors and formatting to improve visual clarity.

By following these steps, you can create effective charts with multiple data series in Excel to showcase comparisons, trends, and relationships within your data.