How to

How to Use Excel’s “Quick Analysis” to Visualize Data

Creating a chart in Excel is neither simple nor intuitive for inexperienced users. Luckily, there’s a feature called Quick Analysis that can develop charts, tables, and more with just a click.

Initially, we’ll make a chart in order to understand our data better. In this example, this is a table of the kinds of beverages purchased at an imaginary restaurant. To start, we’ll pick the cells we wish to group by clicking and dragging.

Next, click the small “Quick Analysis” icon. You’ll find it at the bottom right of the chosen data.

From the pop-up window, click “Formatting.” This is just among numerous analysis types, though it’s an excellent one to begin with for our fictional example.

Move the cursor over each option to preview it. Let’s take a more detailed take a look at Data Bars.

This choice, Data Bars, turns each cell into a development bar. The greatest worth in our table covers the width of the cell with each extra bar being scaled proportionally.

The next visualization, Color Scale, changes each cell’s color according to their worth. This is, obviously, editable too if you ‘d prefer a various color.

The Icon Set choice displays an icon next to each cell. These can likewise be personalized to your taste.

For our use case, we’re going to choose Charts. This will insert a graphic representation of our text-based data.

Upon selecting Charts, you’ll see that there are a number of suggestions. You can choose the one that fits your requirements best, but we’re going to click Stacked.

As soon as the chart has actually been developed, our information is now a visual representation. We can resize it by dragging the corners.

Prior to we forget, let’s rename the file. To do that, you’ll simply double-click the chart name and enter one of your choosing.

While our chart is practically ideal as it is, let’s change the color of coffee so that it matches the color often associated with it: brown. To do that, we’ll right-click anywhere inside that color area on the chart to bring up some new options.

To choose your color, click “Fill,” then select your desired swatch.

We could certainly stop here, however what if we wished to know the overall of each kind of beverage we sold this year? First, we’ll pick the data once again.

Then, click the Quick Analysis button. This time, we’re going to pick the “Totals” tab, and then choose “Sum.”

And now, we’ve changed our visualization to include the total of each kind of beverage offered. Aside from our regular monthly overalls, we now have the sum of all 12 months for each kind of beverage.

There are a variety of methods you can use Excel’s Quick Analysis function, though this must get you started. It’s definitely a function best found out by explore various types of visualizations.

We’ll make a chart in order to comprehend our data better. For our use case, we’re going to choose Charts. Upon picking Charts, you’ll see that there are a number of suggestions. When the chart has been created, our information is now a graphical representation. While our chart is practically best as it is, let’s alter the color of coffee so that it matches the color frequently associated with it: brown.

Leave a Reply