Microsoft Excel has more dataviz capabilities than you may realize. Find out how to make your data stand out with charts, PivotTables, sparklines, slicers and more.

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.

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

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.

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.

Excel 2016’s many new features include six new chart types. We’ll go over Histogram, Pareto, and Waterfall and talk about how they could be used with your data. We covered Treemap, Sunburst ...

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

Learn how to change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name.

If you want to add labels to the bubbles in an Excel bubble chart, you have to do it after you create the chart. Mary Ann Richardson explains what you need to do to add a data label to each bubble.

Excel Sparklines are mini charts that live in a single cell, giving you a quick visual of your data. With just a glance, you can ...