HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC HOW TO
HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC PC
HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC WINDOWS

HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC PC

Then press the button office hour located in the upper left, select the item Save as from the bar that appears on the side and click the button Save as to save the file to OneDrive or the button Download a copy to download it offline to your PC (as an XLSX file). When you are satisfied with the result, you can choose save the file online on OneDrive or download it locally on your PC. Then select the cells that contain the data you want to display on your chart (the data should be arranged in two columns: i data to be analyzed and I bin data, which represent the intervals to measure the frequency), click the button histogram contained in the card enter Excel Online (the one with three vertical bars ) and select the type of graph you want to use from those available.įinally, go to the tab Graphical tools to customize the appearance of the newly inserted chart in Excel Online and use the mouse to move or resize it. Now all you have to do is follow the same procedure that I explained before for the classic version of Excel (Windows and macOS).

HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC WINDOWS

As it is easy to understand, it does not include all the functions of Excel for Windows or macOS, but for the creation of simple histograms it is more than enough.

HOW TO ADD HISTOGRAM IN EXCEL 2016 MAC HOW TO

To access it, just have a Microsoft account (if you don't already have one, you can fix it by reading my tutorial on how to create a Microsoft account) and log in with the latter. chrome, Firefox o safari ) and does not require any type of payment. Create a histogram with Excel OnlineĪs already mentioned at the beginning of the publication, Excel is also available in a web version, called Excel Online, which can be used directly by the browser (eg.

To begin data analysis, you must instead select the item Analysis of data of menu instruments excel. To activate the data analysis tool in the form of histograms in Excel 2003, select the article Additional components of menu instruments the program, put the check mark next to the item Analysis tools - VBA and click on the button good. In the window that opens, select the item histogram From the left sidebar, click on the type of chart you want to create and click first siguiente for three consecutive times and then up final To complete the operation. If you would like to make a histogram with Excel and use Office 2003 or before, you must select with the mouse all the cells that contain the data to be inserted in the graph and click on the button graphic assistant present in the program's toolbar (the one with the color bar graph icon). In the window that opens, select the data of input range and at class interval by clicking the button with the red arrow next to these items, place the check mark next to the item Output table and click good to get your histogram. If you use a Mac, to activate the analysis tools you have to go to the menu Tools> Excel Add-ins located at the top, you must put the check mark next to the item Analysis tools and you have to press the button good.Īt this point, go to the card data from the Excel toolbar click the button Analysis of data (bottom right) and select, by double-clicking on it, the item histogram from the list that appears. In the window that opens, select the item Additional components from the left sidebar, click on the button vai (below), put the check mark next to the item Analysis tools - VBA and click on the button good to activate data analysis in the form of histograms. If you do not want to create a simple histogram but want to analyze the data and frequencies contained in a spreadsheet using this type of graph, you must click the button office hour located in the upper left and select the item Options from the menu that appears.

You can move the chart and resize it freely with the mouse, while to customize it (for example, change the colors of the bars) you must click on it and use the form tools Graphical tools that appears on the Excel toolbar. At this point, almost like magic, your graph will appear in the spreadsheet with the selected data in the cells.

Then click on the button histogram contained in the card enter Excel (the one with three vertical bars ) and select the type of graphic you want to use through the box that appears.

The data should be organized in two columns: on the one hand, i data to be analyzed and on the other i bin data, which represent the intervals to measure the frequency. At this point, you must hold down the left mouse button and select all the cells that contain the data you want to display in the box (for example, the answers given to a survey and how often they were given).

How to add histogram in excel 2016 mac