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.

Follow the steps below on how to ignore blank cells in Excel: Select a blank cell next to the values that you want to use to create the chart and type the formula =IF(ISBLANK(C2), #N/A, C2).

Refresh or change the data source of your pivot table If you have updated the original database with new details, you need to refresh the generated pivot tables.

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

Here is a better way to change the automatic axis settings: Open the Excel file containing the chart. Click a value in the chart’s vertical axis to select it. Right-click the selected vertical axis.

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.