Adding Data Sets One at a Time Launch Excel and load the spreadsheet containing the data you want to plot. Select the first set of X and Y axis data for your chart.

How to Make an X-Y Scatter Plot in Microsoft Excel. Two columns or rows of data in Microsoft Excel may contain useful information, but you'll just have a set of numbers.

How to create a Line Chart in Excel To create a line chart in Excel, the procedure is as follows: Select the data across both the columns (from A3 to B12). Go to Insert > Line Chart.

Excel won't display hidden data in a chart unless you flip the switch. Learn which option controls this behavior.

You may think you already know all about them, but Excel keeps adding more, including some that can handle complex information. To experience the breadth of Excel’s data visualization offerings, let’s ...

Each of these new column pairs will be used to plot a series of smaller concentric bull’s-eye circles. When plotted on an Excel Scatter Chart, these data points will form a total of four circles, ...

Displaying values on a map chart is more meaningful than handing someone a sheet of data. Thanks to Microsoft Excel's Geography data type, creating a map chart is easier than you might think.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

Learn how to create a Pie Chart in Excel with percentages, without numbers, with words, multiple data or columns, etc. A pie chart helps understand data spread.

Graphs in Excel help break down your data into an easily digestible format. Here’s how to make a graph in Microsoft Excel.

Excel 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.