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.

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

The bar chart will visualize your Gantt chart’s most important data points Step 3: Input Duration Data The next step is to add another series to your Excel chart to reflect each task’s duration.

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.

To create a Mind Map in Excel, you can use Shapes, Text Boxes, and Connectors, or use SmartArt for a more structured approach.

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.

You can also choose a 3-D chart to add some aesthetic texture to the graph. These different graph options are relatively easy to create in Excel when you're looking to visually represent a data range.

Chart the Summary Data Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

Figure D The people chart is based on the survey data in the Table. How to customize Excel’s people chart The original settings are adequate, but you might want to customize the chart a bit.