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.

How to Create Target Lines in Excel Charts. Microsoft Excel allows you to create charts and graphs tailored to your specific business needs using features and details that make it unique. For ...

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.

What Is a Clustered Chart in Excel?. A cluster chart is like a bar chart except that it clusters several bars into a category and displays each cluster separately from the rest. For example, you ...

When plotted on an Excel Scatter Chart, these data points will form a total of four circles, effectively converting a scatter chart into a bull’s-eye chart. Your updated table containing the ...

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

Goal Seek is a What-if Analysis feature in Excel. Learn how to use it to calculate the changing value in cell, and more!

This month’s column shows how to use Excel’s Goal Seek for data analysis.

How to prepare the data in Excel A burndown chart is easy to create in Excel, but setting up the data takes a good understanding of what the chart represents.

Goal seeking is the process of calculating in reverse to find the right method when only the desired outcome is known.