Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might ...

For the sunburst chart to work, you must order your data by the largest category (the innermost circle). So, in the example above, the table is sorted by the continent column.

Enter the relevant data into a table with the categories in the left column and the sub-category headings along the top row. For example, you might enter salesperson's names in the left column and ...

As well, you can simply create a chart from an existing pivot table (as you would with any data table in Excel). Quick Tip: Select any cell in a pivot table and click F11.

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.

The Excel application automates the process of generating charts from existing data sets. If a spreadsheet already contains updated data, the chart function can transform this data into a chart ...

But a hidden benefit is the magic it affords your charts. For instance, add a new column of data to the end of a table, and the linked chart automatically expands to add the new data series. Nice.

Select cells E3:L16. Go to Data, click the dropdown arrow next to What-if Analysis within the Forecast group, and choose Data Table. The Data Table window will open, asking for inputs into Row input ...

Once you have your data ready, you can use Excel’s built-in features to create a Gantt chart. You will find that Excel’s conditional formatting and bar chart tools are particularly useful for ...

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.