The X marks the mean (average) value. Dots represent outliers.

Select Insert from the menu, and in the charts group, select the type of chart you want to add to the report sheet. In the Chart Design menu, in the Data group, select Select Data.

Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart. Click "Select Data" to open the ...

Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

To experience the breadth of Excel’s data visualization offerings, let’s take a tour of some of the most useful charts, starting with the basic ones and moving to the more advanced. To follow along, ...

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

How to Format a Color Chart in Excel. Microsoft Excel gives you a boatload of options for changing the format of color charts. You can change the layout of a chart, then customize that layout to ...

Once Excel has generated the chart, click on the front area to select it. Choose Format: Selected Data Series, and click on the Patterns tab. Click on the Fill Effects button and then on the ...

When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...

Learn how to create amazing Waterfall Charts in Microsoft Excel spreadsheets to easily convey your data analysis or reports in a more ...

A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.