Advanced Excel - Format Reports



In Excel 2013, Power View has 39 additional themes with more varied chart palettes as well as fonts and background colors. When you change the theme, the new theme applies to all the Power View Views in the Report or Sheets in the Workbook.

You can also change the text size for all of your Report Elements.

You can add Background Images, choose Background Formatting, choose a Theme, change the Font Size for One Visualization, change the Font or Font Size for the whole sheet and Format numbers in a Table, Card, or Matrix.

Step 1 − Click on the Power View tab on the ribbon.

Step 2 − Click on Set Image in the Background Image group.

Background Image

Step 3 − Click on Set Image in the drop-down menu. The File Browser opens.

Set Image Drop-down

Step 4 − Browse to the Image File you want to use as Background and click open. The image appears as background in the Power View.

Background Image Appear

Step 5 − Click on Image Position in the Background Image group.

Background Image Position

Step 6 − Click on Stretch in the Drop down menu as shown in the image given below.

Stretch

The Image stretches to the full size of Power View.

Stretch Background Image

Step 7 − Click on Transparency in the Background Image group.

Transparency Background Image

Step 8 − Click on 80% in the Drop down box.

Transparency 80%

The higher the percentage, the more transparent (less visible) the image.

More Transparency

Instead of images, you can also set different backgrounds to Power View.

Step 9 − Click on Power View tab on the ribbon.

Step 10 − Click on Set Image in the Background Image group.

Step 11 − Click on Remove Image.

Remove Image

Now, Power View is with White Background.

Step 12 − Click on Background in the Themes Group.

Background Themes Group

You have different backgrounds, from solids to a variety of gradients.

Different Background

Step 13 − Click on Dark1 Center Gradient.

Dark1 Center Gradient

The background changes to Dark1 Center Gradient. As the background is darker, the text turns into white color.

Step 14 − Click on the Power View tab on the ribbon.

Step 15 − Click on Font in the Themes group.

Theme Group Power View

All the available fonts will be displayed in the Drop down list.

Font List

Step 16 − Click on Tahoma. The font of the text changes to Tahoma.

Tahoma Font

Step 17 − Click on Text Size in the Themes group.

Text Size

The percentages of the font sizes will be displayed. The default font size 100% is highlighted.

% Of Text Size

Step 18 − Select 150%. The font size changes from 100% to 150%.

Font Size Change

Step 19 − Switch Stacked Bar Chart Visualization to Table Visualization.

Stacked Chart to Table Visualization

The changed font and font size are retained in the Table Visualization.

Table Visualization

When you change the font in one Visualization, the same font is applied to all visualizations except for the font in a Map Visualization. You cannot have different fonts for different Visualizations. However, you can change the font size for individual visualizations.

Step 20 − Click on a Cell in the Column containing Numbers.

Step 21 − Click on Number in the Number Group.

Number Group

Step 22 − Click on Percentage in the Drop down menu.

Number Group Percentage

The entire column containing the selected cell gets converted to the selected format.

Selected Cell in Column

You can format numbers in Card and Matrix Visualizations also.

Hyperlinks

You can add a Hyperlink to a text box in Power View. If Data Model has a field that contains a Hyperlink, add that field to the Power View. It can link to any URL or email address.

This is how you could get the sport images in Tiles in Tiles Visualization in the previous section.

Printing

You can print Power View sheets in Excel 2013. What you print is what you see on the sheet when you send it to the printer. If the sheet or view contains a region with a scroll bar, the printed page contains the part of the region that is visible on the screen. If a sheet or view contains a region with tiles, then whichever tile is selected is the one that prints.

Support for right-to-left languages

Power View in Excel 2013 supports right-to-left languages. Power View takes the setting for default direction from Excel. You can change those settings.

Step 1 − Click on File.

Step 2 − Click on Options. The Excel Options window appears.

Step 3 − By default, the direction has two options Right-to-left and Left-to-right.

Excel Options

Step 4 − Set the default direction to Left-to-right.

Step 5 − Click OK.

Left-to-right

Step 6 − Change the default direction to Right-to-left.

Right-to-left

Step 7 − Click OK. You can see that the columns are now starting from the right side of the screen as shown in the image given below.

Column Starting Right Side

Microsoft Office supports right-to-left functionality and features for languages that work in a right-to-left or a combined right-to-left, left-to-right environment for entering, editing, and displaying text. In this context, "right-to-left languages" refers to any writing system that is written from right to left and includes languages that require contextual shaping, such as Arabic, and languages that do not. You can change your display to read right-to-left or change individual files so their contents read from right to left.

If your computer does not have a right-to-left language version of Office installed, you will need to install the appropriate language pack. You must also be running a Microsoft Windows operating system that has right-to-left support — for example, the Arabic version of Windows Vista Service Pack 2 — and enable the keyboard language for the right-to-left language that you want to use.

Advertisements