{"id":197481,"date":"2021-03-08T11:00:55","date_gmt":"2021-03-08T08:00:55","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-use-excels-quick-analysis-to-visualize-data\/"},"modified":"2021-03-08T11:00:55","modified_gmt":"2021-03-08T08:00:55","slug":"how-to-use-excels-quick-analysis-to-visualize-data","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-use-excels-quick-analysis-to-visualize-data\/","title":{"rendered":"#How to Use Excel\u2019s \u201cQuick Analysis\u201d to Visualize Data"},"content":{"rendered":"

“#How to Use Excel\u2019s \u201cQuick Analysis\u201d to Visualize Data”<\/strong><\/p>\n

\n\"The<\/p>\n

Creating a chart in Excel is neither easy nor intuitive for inexperienced users. Luckily, there\u2019s a feature called Quick Analysis that can create charts, tables, and more with just a click.<\/p>\n

First, we\u2019ll make a chart in order to understand our data better. In this example, this is a table of the types of drinks purchased at a fictional restaurant. To get started, we\u2019ll select the cells we want to group by clicking and dragging.<\/p>\n

\"select<\/p>\n

Next, click the small \u201cQuick Analysis\u201d icon. You\u2019ll find it at the bottom right of the selected data.<\/p>\n

\"quick<\/p>\n

From the pop-up window, click \u201cFormatting.\u201d This is just one of many analysis types, though it\u2019s a great one to start with for our fictional example.<\/p>\n

\"formatting<\/p>\n

Move the cursor over each option to preview it. Let\u2019s take a closer look at Data Bars.<\/p>\n

\"\"<\/p>\n

This option, Data Bars, turns each cell into a progress bar. The highest value in our table covers the width of the cell with each additional bar being scaled proportionally.<\/p>\n

\"data<\/p>\n

The next visualization, Color Scale, changes each cell\u2019s color according to their value. This is, of course, editable as well if you\u2019d prefer a different color.<\/p>\n

\"color<\/p>\n

The Icon Set option displays an icon next to each cell. These can also be customized to your liking.<\/p>\n

\"icon<\/p>\n

For our use case, we\u2019re going to choose Charts. This will insert a graphic representation of our text-based data.<\/p>\n

\"chart<\/p>\n

Upon selecting Charts, you\u2019ll see that there are a number of recommendations. You can choose the one that fits your needs best, but we\u2019re going to click Stacked.<\/p>\n

\"stacked<\/p>\n

Once the chart has been created, our data is now a graphical representation. We can resize it by dragging the corners.<\/p>\n

\"resize<\/p>\n

Before we forget, let\u2019s rename the file. To do that, you\u2019ll just double-click the chart name and type in one of your choosing.<\/p>\n

\"rename<\/p>\n

While our chart is almost perfect as it is, let\u2019s change the color of coffee so that it matches the color often associated with it: brown. To do that, we\u2019ll right-click anywhere inside that color area on the chart to bring up some new options.<\/p>\n

\"fill<\/p>\n

To pick your color, click \u201cFill,\u201d then pick your desired swatch.<\/p>\n

\"color<\/p>\n

We could certainly stop here, but what if we wanted to know the total of each type of drink we sold this year? First, we\u2019ll select the data again.<\/p>\n

\"select<\/p>\n

Then, click the Quick Analysis button. This time, we\u2019re going to choose the \u201cTotals\u201d tab, and then select \u201cSum.\u201d<\/p>\n

\"\"<\/p>\n

And now, we\u2019ve changed our visualization to include the total of each type of drink sold. Aside from our monthly totals, we now have the sum of all 12 months for each type of drink.<\/p>\n

\"chart<\/p>\n

There are a number of ways you can use Excel\u2019s Quick Analysis feature, though this should get you started. It\u2019s definitely a feature best learned by experimenting with different types of visualizations.<\/p>\n<\/div>\n