How To Make, Create, Insert, Construct A Basic Histogram In Excel Explained скачать в хорошем качестве

How To Make, Create, Insert, Construct A Basic Histogram In Excel Explained

In this video we discuss how to quickly make or create a basic histogram in excel. We go through a detailed example step by step of the process, and also cover some basic modifications. Transcript/notes In this video we are going to create a basic histogram based on the number of gifts cards sold for the employees, which is in column D. To do this, make sure you are on the insert tab near the top of the worksheet. From here, left click on the column D letter, to highlight the data in the column. Next, in the charts section near the top of the worksheet, left click on this Insert Statistic Chart Icon, and some options will pop up. In here, left click on this first histogram icon, and now the histogram chart has been created. A couple of notes, you can left click in an open area on the chart and move the chart. To change the title, left click on the title and make the change. For the class widths, the open parenthesis means the number, here 4.7 is not included in the section, and a closed bracket, here 9.4, means the number is included in the section. And to modify the class widths, or number of classes, left double click on the bottom section of the chart, as you see here, and a panel will open. In this panel, you can make modifications. I will change the bin width to 4, and you see the change made. Chapters/Timestamps 0:00 How to create a basic histogram in excel 0:31 How to make some chart adjustments 0:53 Adjust classes and class widths