Microsoft Excel charts transform raw numbers into visualizations that clarify the relationships among your data and help reveal underlying trends. Some worksheets combine values that interrelate but that include more than one type of information.
![Create Create](/uploads/1/2/5/5/125574188/687323724.png)
This tutorial walks you through how to take columns of data and calculate the average and standard deviation from raw data. It then shows how to plot those data with a vertical bar (histogram). In the Excel sheet, you are presented with 3 series. Drag the lower right corner of the range so that only one series is included.
Whether you want to highlight a set of values for emphasis or for contrast, use Excel's combination charts to achieve your objective. As their name makes clear, these multifaceted data presentations enable you to use more than one type of chart together, sharing the same X and Y axes. Tip. If your chart data includes more than two series, you can create a combination chart that uses three different chart types, one for each series. If you combine two charts of the same type, your results may be difficult to understand because of the lack of visual differentiation between them. For the same reason, if you combine two chart types that present information similarly but in different orientations - for example, a column and a bar chart - you may be unhappy with your output.
![Mac Mac](/uploads/1/2/5/5/125574188/587508512.jpg)
Each time you redefine a data series as a contrasting combination chart type, Microsoft Excel displays it behind the series you previously defined. If you try to turn a data series into a chart type that requires more than one series, Excel adds the new chart using the data in all your data series. For example, if you create a three-series chart in line format, turn one data series into a column chart and try to transform the third series into a doughnut chart, the result shows your first series as a line, the second as a column behind the line and all three series as a doughnut behind the other two data series. In this scenario, the third series does not display as a separate chart type by itself.