Now it is plain to see that the longer people have been employed, the more sales they make. For this task, we are going to use a scatter plot. You can hover over each of the recommended options to see a preview of the chart it will output. Note that the chart recommendations have changed. To do this, we will highlight both the “Years Employed” and “Sales” columns and open up quick access. Now it is easy to see that we are going to need to order plenty of chocolate ice cream for the party.Ĭounting ice cream flavors is simple, but what if you want to go a little deeper? Our next assigned task is to see if there is a relationship between the years of employment at our imaginary company everyone has, and their sales. We could also select “More…” to view other chart options.Ĭlicking on the bar graph option populated a new sheet with a pivot table and graph. Notice that Excel has made a suggestions for a clustered bar graph for me based on the highlighted data. Feel free to play around with these other functions, but for our ice cream task we want to use the charts. Now you can see that when the button is clicked it brings up a menu of different options.
This is the quick analysis button and we are going to click on it to open the menu. Notice that to the bottom right of our highlighted area there is a button that looks like a chart with a lightning bolt. In this case, we want to highlight the “Favorite Flavor” column to get what we’re looking for. We are going to find our counts using a bar graph from the quick analysis tools in Excel.įirst, highlight the data set you want to analyze. That is a lot of counting (and a lot of ice cream). In this sample set it would be easy enough to hand count, but imagine if you were doing things for hundreds or even thousands of records. Let’s say you have been tasked with identifying how much of each flavor ice cream needed for an office party so you need to find out which flavor is most popular. Here there is a sample set of data to use: You don’t have to be an Excel wizard to have tailor-made insights at your fingertips. Homeless Management Information System BlogĮxcel provides a way to quickly create visualizations and analyze your data in just a few clicks.
0 kommentar(er)
