官术网_书友最值得收藏!

Using the design menus to custom format a cell

There are two design menus that can appear when you right-click an object on the layout. They are:

  • Order: This is applicable to all objects, and this menu has a submenu that allows you to adjust the Layer of an object.
  • Custom Format Cells: This is applicable only to the three grid objects (Table Box, Straight Table, and Pivot Table), and this menu allows you to apply your own custom color, border, and font options to a cell.

These menu items do not appear by default. There are two ways of making them available. You can either turn on the Design Grid option (from the View menu), or you can turn them on by changing your User Preferences, which we will do in this recipe.

Getting ready

Load the following script:

Load * Inline [
  Country, Sales, Costs
  USA, 1203, 1043
  UK, 987, 995
  France, 1118, 1022
  Germany, 876, 754
];

How to do it…

Use the following steps to custom format a cell in the table:

  1. Create a straight table with Country as dimension and add the following three expressions:
  2. Click on Finish to save the chart.
  3. From the Settings menu, select User Preferences and click on the Design tab.
  4. Click on the Always Show Design Menu Items option and click on OK.
  5. Right-click on one of the Total Margin values for a country (for example, 160 for USA) and select Custom Format Cell from the menu.
  6. Click on the Background Color button and change the Base Color, Fixed to an RGB value of 245, 245, and 245. Set the Apply change to option to Current Expression and click on OK.
  7. Right-click on the total value for Total Margin (in this case, 370) and select Custom Format Cell. Set the Text Size to 120 % and turn on the Italic checkbox. Click on OK to make the change.
  8. Similarly, right-click on one of the countries (for example, Germany) and select Custom Format Cell. Turn on the Bold option and click on OK:
  9. Edit the properties of the chart and go to the Style tab. Note that the Current Style is set to [Custom].

How it works…

This is quite simple, turning on the option in the User Preferences allows us to see the menu and that then allows us to make custom format changes to our tabular chart.

There's more…

If you change the Current Style option in the chart properties to one of the preset styles, it will remove all your custom settings.

主站蜘蛛池模板: 伊吾县| 卓资县| 重庆市| 上栗县| 马关县| 万安县| 万山特区| 越西县| 云林县| 东乡| 通州区| 军事| 怀来县| 涿鹿县| 军事| 远安县| 界首市| 墨玉县| 简阳市| 东台市| 孟村| 德庆县| 尉犁县| 昌邑市| 崇明县| 静宁县| 冕宁县| 新泰市| 汶川县| 清原| 吕梁市| 马关县| 蓝田县| 威远县| 黔西县| 革吉县| 九龙城区| 宜宾市| 万盛区| 吴堡县| 会宁县|