Excel Solutions

3 Methods to Set Data to Percentage Format in Your Worksheet

Percentage is a very common data form in Excel. To make things easier, Excel has the feature of setting data to the percentage format. There are 3 different methods to change the format. But you may also need to pay attention to some of the details. In this image below, we need to input the growth rates of sales volume manually. There are a lot of data that we need to input. Thus, if Excel can change the form into percentage format automatically, the task can be much easier. Method 1:...

Read more »

How to Present Your Data in an Excel Bubble Chart

You cannot create a column chart or line chart with three data series in an Excel worksheet. Thus, the bubble chart can be your first choice. The major difference of bubble chart is that the bubble itself also represents a set of data. Therefore, in such a chart, it actually contains three data series. And the following will introduce how to create such a chart. Create a Bubble Chart In this worksheet, there are three data series about the sales volume. And now you can create a bubble...

Read more »

3 Useful Tips on Creating and Managing Calculated Fields in Excel Pivot Table

Pivot table can sum up the values of columns when it is created. And to calculate the values of rows, you can use the calculated fields manually. The image below shows the sales volume of two products. To make things easier, we have created a pivot table in a new worksheet. You can see that the total sales volume of the months will be automatically calculated. But the total sales volumes of two products of each month don’t appear in this table. Hence, you can add the calculated...

Read more »