Learn how to show charts with hidden data cells in Excel. When there is data that is hidden in your table, Excel will not show that information in the chart.

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

This article will be handy if you want to rename or edit the data series name in a Microsoft Excel graph or chart without changing the row or column name. The data series is the data that appears at ...

While static Excel charts are adequate for basic data analysis, they fall short when you want to explore trends, compare scenarios, and truly interact with your information. Here is where dynamic ...

How to Change Series Data in Excel. To update your Microsoft Excel worksheet, you can add a data series to the source data and also update the worksheet chart to make your data meaningful to your ...

When the relationship between the charted entities is less important than the individual entities, try using these two chart techniques to highlight important details in Microsoft Excel.

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.

You can easily make a pie chart in Excel to make data easier to understand. The process only takes 5 steps.

To create data bars in Excel, select your cells and then choose data bars from Conditional Formatting. Data bars are a kind of conditional formatting, with the bar length based on the value of the ...

Got a whole bunch of data in a row or column that needs to be sorted alphabetically? You can do it with just a few clicks in Excel.