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

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.

When you are organizing data for your company in a spreadsheet using Microsoft Excel, you do not have to manually edit the information, if you want to sort it alphabetically. Instead, you can use ...

You can filter data in Excel based on either certain parameters in columns or over the whole sheet, and you can later unfilter the sheet.

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

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.

Learn how to build amazing Excel graphs the not only look professional but also feature your company's brand and aesthetics ...

Not all sort tasks in Microsoft Excel begin with the characters to the left, but getting around that issue is easier than you think. Susan Harkins shows you how.

With Excel's versatile chart tool, putting together data visualizations is as easy as pie (groan).

To make McKinsey charts interactive, integrate dynamic Excel formulas that update the chart in real-time as the underlying data changes, transforming static visuals into interactive tools.

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.

Here’s how to make a Gantt chart in Excel to accommodate complex agile project management within the familiar tool.