A Microsoft Excel spreadsheet is among the most versatile business tools. Here’s a full guide on how to create a simple and effective Gantt chart in Excel.

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

How to change the layout of the Excel chart Select the chart, then go on the Chart Design tab and select the Quick Layout button in the Chart Layouts group and select an option from the menu.

In this guide, I'll walk you through the different ways to format your chart, with Excel's main chart-formatting actions written in bold so you can find them more easily.

We explain how to make a Lollipop Chart in Excel. A Lollipop Chart resembles a Bar Chart but with a line on a point at the end.

Use Excel’s combination chart feature to layer the total column behind the individual columns, creating a visually distinct representation of cumulative data.

How to create an interactive dashboard in Microsoft Excel Now that you have a basic idea about interactive dashboards in Microsoft Excel, let’s check them out in action.

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.

Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in Microsoft Excel.

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.