How to Hide Empty Data in Excel Graphs. If you have an Excel spreadsheet that contains empty data, such as empty rows or columns, and plot a graph from the spreadsheet, Excel plots all empty data.

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.

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.

Charts in Excel can also be altered after they have been initially generated, by selecting a chart and choosing from the available options to amend the chart type, data or other details.

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.

You can make a bar graph in Excel by first selecting the range you want to depict, and then using the dropdown menu to select the desired chart.