Advanced Microsoft Excel
Part 22 - 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.
Step 3 − Click 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 click open. The image appears as background in the Power View.
Step 5 − Click on
Image Position in the
Background Image group.
Step 6 − Click on
Stretch in the Drop down menu as shown in the image given below.
![Stretch](https://www.tutorialspoint.com/advanced_excel/images/stretch.jpg)
The
Image stretches to the full size of
Power View.
Step 7 − Click on
Transparency in the
Background Image group.
Step 8 − Click on
80% in the Drop down box.
![Transparency 80%](https://www.tutorialspoint.com/advanced_excel/images/transparency_80_percent.jpg)
The higher the percentage, the more transparent (less visible) the image.
![More Transparency](https://www.tutorialspoint.com/advanced_excel/images/more_transparency.jpg)
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](https://www.tutorialspoint.com/advanced_excel/images/remove_image.jpg)
Now, Power View is with White Background.
Step 12 − Click on
Background in the
Themes Group.
![Background Themes Group](https://www.tutorialspoint.com/advanced_excel/images/background_themes_group.jpg)
You have different backgrounds, from solids to a variety of gradients.
Step 13 − Click on
Dark1 Center Gradient.
![Dark1 Center Gradient](https://www.tutorialspoint.com/advanced_excel/images/dark1_center_gradient.jpg)
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](https://www.tutorialspoint.com/advanced_excel/images/theme_group_power_view.jpg)
All the available fonts will be displayed in the Drop down list.
Step 16 − Click on
Tahoma. The font of the text changes to Tahoma.
Step 17 − Click on
Text Size in the
Themes group.
![Text Size](https://www.tutorialspoint.com/advanced_excel/images/text_size.jpg)
The percentages of the font sizes will be displayed. The default font size 100% is highlighted.
Step 18 − Select 150%. The font size changes from 100% to 150%.
Step 19 − Switch
Stacked Bar Chart Visualization to
Table Visualization.
![Stacked Chart to Table Visualization](https://www.tutorialspoint.com/advanced_excel/images/stacked_to_table_visualization.jpg)
The changed font and font size are retained in the
Table Visualization.
![Table Visualization](https://www.tutorialspoint.com/advanced_excel/images/table_visualization.jpg)
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.
Step 22 − Click on
Percentage in the Drop down menu.
![Number Group Percentage](https://www.tutorialspoint.com/advanced_excel/images/number_group_percentage.jpg)
The entire column containing the selected cell gets converted to the selected format.
![Selected Cell in Column](https://www.tutorialspoint.com/advanced_excel/images/selected_cell_in_column.jpg)
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.
Step 4 − Set the default direction to
Left-to-right.
Step 5 − Click
OK.
Step 6 − Change the default direction to
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](https://www.tutorialspoint.com/advanced_excel/images/column_starting_right_side.jpg)
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.
No comments:
Post a Comment