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.

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 ...

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.

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.

How to Create a Summary Chart in Excel. Excel spreadsheets can often contain large amounts of data ranging across broad categories. For example, a sales spreadsheet might record sales of products ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.

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 Gantt charts in Microsoft Excel spreadsheets to provide visual representations of your data for easy analysis and ...

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 2016's many new features include six new chart types. Here we cover Histogram, Pareto, and Waterfall, which cover statistical, trend, and other relationships.