With your data prepared and mapped, you can now use Excel’s SUMIFS formulas to aggregate the data based on specific headings and date ranges.

How to create data bars in Excel 1. Select the cells you want to apply the data bars to. You can select a single cell, a range of cells, a table, or the entire sheet. 2.

2. Click the Data tab. 3. In the Get & Transform Data group, click From Table/Range. If you haven’t formatted the data as a Table, Power Query will prompt you to do so.