Select the numbers you would like to format, right click the selection then select the Numbers tab. Select Currency in the Category list, then choose the number of decimal places and currency format. This video takes a look at the Format Task Pane, a formatting control added in Excel 2013 to format and configure chart elements. The Format Task Pane was added in Excel 2013 and provides detailed controls for most chart elements. Previously, this sort of formatting was done with the Format dialog box. The main idea behind the Format Task pane is to provide a more complete set of controls to format things like charts without obscuring the worksheet below. The easiest way to display the Format Task Pane is to double-click on a chart. This will open the Format Task Pane with Chart Options selected. You can also select a chart element first, then use the keyboard shortcut Control + 1. For example, if I select the data bars in this chart, then type Control + 1, the Format Task Pane will open with with the data series options selected. The Format Task pane stays open until you manually close the window. There are two other ways to open the task pane. You can select element, and then click the Format Selection button on the Chart Tools Format tab, or, easier, right-click any element and choose the format option from the shortcut menu. Notice when you right-click a chart element, you'll see a shortcut menu and something called the mini-toolbar, which provides quick access to common formatting tasks, plus a small menu to browse and select chart elements. The content in the Format Task Pane varies a lot depending on what element is selected. For example if I select the chart title, I get options to format the title, with two menu tabs at the top: one for Title options, one for text options. Under the title tab, you'll find options for line and fill, special effects, and size and properties. Under text options you'll find text fill, text effects, and text box controls. If I select the data bars, I get controls to format the Data Series. Once the Format Task Pane is open, you can use the element selector at the top to move between different chart elements. Again notice that the pane continues to update with specific controls, as different chart elements are selected. You can undock the Format Task Pane if you like. Just click and drag the title area, and resize the window as you like. Now the pane will appear floating when invoked. To re-dock the pane, just drag to the edge of the window. The Format Task Pane is a detailed control that takes some getting used to. We're going to use it a lot in upcoming videos. Outlook for mac. Outlook 2011 Update: We released the fix for Outlook 2011 hang on El Capitan with update 14.5.6. Some users reported issue persisting and this was isolated to El Capitan users, please update to the latest OS X 10.11.1 that Apple released today. Thanks, Sunder. Program Manager| Outlook for Mac. Yesterday I upgraded to El Capitan, and Office 2011 no longer works at all (version 14.5.7). I personally don't use Outlook, but live and die with Word and They both crash on the startup screen as soon as the font menu starts loading. I see that Microsoft is working for a fix for Outlook 2011. On El Capitan, connecting to Exchange email servers causes Outlook 2011 to freeze and display a beachball cursor. If you’re planning to upgrade to OS X El Capitan and you use Outlook 2011 to get email from Microsoft Exchange, you may want to delay upgrading. Excel 2016's many new features include six new chart types. We'll go over three of them here and talk about how they could be used with your data. The best applications for this chart design are data with categories/groups and subcategories/subgroups. Examples would include organizational charts, product inventory; numbers per capita, percentages per area; budgets, sales; battery, disk, or memory usage. Open your spreadsheet, select the target data, and click Insert > Insert Hierarchy Chart > Treemap. 01 Insert the Treemap chart. The chart drops in and opens the Chart Tools/Design Ribbon menus. Scroll across the Design options and select one that fits your project. 02 Treemap chart Design options 2. Click the + sign to edit the Chart elements: Chart Title, Data Labels, or Legend. Then click the paintbrush to change the chart's design, such as location of the legend, or font attributes. 03 Modify chart elements. ![]() Right-click any of the rectangles on the chart and select Format Data Series. 04 Format Data Series on the Treemap chart. In the Format Data Series pane, click Series Options (the chart icon).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |