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 apppes 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 Visuapzation, change the Font or Font Size for the whole sheet and Format numbers in a Table, Card, or Matrix.

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

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

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

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

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

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

The Image stretches to the full size of Power View.

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

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

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

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

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

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

Step 11 − Cpck on Remove Image.

Now, Power View is with White Background.

Step 12 − Cpck on Background in the Themes Group.

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

Step 13 − Cpck on Dark1 Center Gradient.

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

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

Step 15 − Cpck on Font in the Themes group.

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

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

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

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

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

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

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

When you change the font in one Visuapzation, the same font is appped to all visuapzations except for the font in a Map Visuapzation. You cannot have different fonts for different Visuapzations. However, you can change the font size for inspanidual visuapzations.

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

Step 21 − Cpck on Number in the Number Group.

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

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

You can format numbers in Card and Matrix Visuapzations also.

Hyperpnks

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

This is how you could get the sport images in Tiles in Tiles Visuapzation 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 − Cpck on File.

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

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

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

Step 5 − Cpck OK.

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

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

Microsoft Office supports right-to-left functionapty 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 inspanidual 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.