Format Reports in Excel

Excel 2013 introduces the Format pane. It offers advanced formatting choices in clean, bright new task windows, and it is also highly useful. When you alter the theme, it is applied to all Power View Views in the Report and Sheets in the Workbook. You may also modify the size of the text in all of your Report Elements. You can add Background Images, alter the Font or Font Size for One Visualization, change the Font or Font Size for the entire page, and Format numbers in a Table, Matrix, etc.

Dataset

This is the major dataset that will be used in this case.

Table Formatting

Step 1: Formatting a report, begin with a table. Choose the following options: Months, Percentage of sales, Quarter, and Sales in billion. In Power View, a table with these fields is displayed.

Step 2: Select any number and then go to the Design tab on the top of the ribbon and then select a percentage from the dropdown list.

Step 3: You can now see that the entire column containing the selected cell is transformed into a percentage.

Step 4: You can also change the font, Theme, and size of the table in power view. For that just go to the Power View tab on the top of the ribbon and from the theme section, you can change it.

Step 5: Here you can see from the theme section we have changed the theme of the table and from the font, we have changed the font from Arial to Georgia.

Step 6: We can also change the size of the table from the Text size on the Themes group. Here, we select the size 150%. By default, the text size is 100%.

Except for the font in a Map Visualization, when you alter the font in one visualization, the same font is applied to other visualizations. Distinct fonts cannot be used for different Visualizations. Individual visualizations, on the other hand, can have their text size changed.

Chart Formatting

Step 1: Now Switch from table Visualization to line chart Visualization.

Step 2: Now you can see the line chart visualization appears. Here you can see the updated font, theme, and font size are all kept in the Line Chart Visualization.

Step 3: Now in chart visualization we are going to set the background image. Just go to the Power View on the top of the ribbon and then in the background image group select a Set image.

Step 4: Navigate to the Image File you wish to use as your background and choose it. In the Power View, the image shows in the background.

Step 5: Set the image position by going to the power view at the top of the ribbon, then selecting the image position in the background image group, and then selecting tile from the dropdown list.

Tile repeats the background image to fill the entire canvas while maintaining the original size and aspect ratio.

Step 6: Here you can see after selecting the tile it will look like this.

Step 7: Use transparency by going to the power view at the top of the ribbon, then selecting the transparency in the background image group, and then selecting 90% from the dropdown list of transparency.

The higher the percentage, the less visible the picture. The lesser the percentage, the more visible the picture.

Step 8: Here you can see after selecting the 90% transparency it will look like this.

Step 9: In addition to images, you may change the background of Power View. On the ribbon, select the Power View tab. In the Background Image group, under a set image, select Remove Image.

Step 10: Now you can see it clear the background image.

Step 11:  Now in chart visualization we are going to set the background theme. Just go to the Power View on the top of the ribbon and then in the themes group select a Dark 2 center gradient.

Step 12: As you can see, the background has now changed to a Dark 2-center gradient. As the background darkens, the writing becomes white.