Microsoft Excel 2013 lacks a utility for creating such control charts, but you can manually construct one by properly organizing your data.

The Run chart and the Control chart are similar, but there is some difference. A Run chart will help to monitor data over time to detach shifts, trends, or cycles.

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

Step 2: Make an Excel Bar Chart To start to visualize your data, you’ll first create an Excel stacked bar chart from the spreadsheet. Select the “Start date” column, so it’s highlighted.

The Sunburst chart is a much better visual chart for showing that. How to create a Treemap chart in Excel Follow the steps below to create a treemap chart in Excel: Select the data in your table.