Navigate to the “Insert” tab in the Excel ribbon and click on the bar chart icon. Choose between 2D or 3D bar chart types. For simplicity, we recommend starting with the 2D column chart.

Learn how to add a watermark in Excel. 3. Create Different Tabs. Create your dashboard on a separate worksheet (or tab). This way, you can process your raw data without worrying about layout mistakes.

This will unlock a ‘Data Analysis' option under the Data tab on the ribbon: Step 2: ... Since we only selected the data to create a histogram, Excel automatically calculated bin sizes, which were ...