When a ribbon tab is selected, these keys navigate the tab buttons. Using a drop-down list for data validation makes data entry easier, prevents data entry errors, and restricts the number of locations for entering data. select(): "Select this tab. xlsx sheets or edit your worksheets with ease. Hope after reading the article you are able to recover your missing sheet tabs in Excel. You can use the three tabs grouped under Chart Tools to modify your chart. Recently I received an e-mail query from one of my readers. To change the color of two or more contiguous worksheet tabs, click the first tab you want to select and then press Shift and click on the last tab you want to select. A tab body is the tab page where you associate your components, such as report and graph objects, images, and lines. It also lists CTRL combination shortcut keys, function keys, and some other common shortcut. Standard or Add-in: PMO. Charting tab - allows you to modify charting options. Here you will see a big-fat-"Switch rows and columns" button. With the new chart selected, on the Excel Ribbon, click the Design tab, under Chart Tools; Click Select Data, to open the Select Data Source window; Click any cell in the pivot table, and click OK. active cell. Select the data to appear to appear in the chart (with labels if relevant) Use the Insert tab and Charts Group and click on the relevant chart in this group. Again, you may only drag in one direction at a time. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button. Select the data to appear to appear in the chart (with labels if relevant) Use the Insert tab and Charts Group and click on the relevant chart in this group. Should it be closed, go to View in the menu bar at the top of the trading platform and select Strategies. Consequently, if you hide. To open the Strategies tab and launch a strategy: By default, the tab is open. / Microsoft Project Print To PDF Options Explored January 21, 2015 By Ten Six If you are looking for a way to create an adobe pdf file of your schedule that clearly displays an outline of your project tasks and corresponding Gantt chart, then you should check out the many great print options available in Microsoft Project 2013. About the Rate Tab. One benefit of a gantt chart is that it's easy to create. If you choose the Column, Line, or Area chart types in the Chart Options section, then you may choose either Column, Line, or Area as the Chart Type for your chart. The main types of chart used in analysis of economcis data are: Column chart: for comparing data across categories. Check the dependencies. Using a drop-down list to create a dynamic chart creates a professional look in your dashboard and the drop-down gives a visual reference to the user where they should click. It automatically synchronizes the selected tab with the currently displayed view and vice versa. The worksheet cell that contains the cell cursor. The graph includes two lines: h-index and the 450 line:. Auto trading orders on TPO Chart Type. graphs, pie charts, and frequency histograms. Experiment a bit with the different options in the drop-down menu if you like. >> Dynamic Excel Chart with Series Selection Check-box Apart from being super cool, Excel dynamic charts are really helpful in presenting a comparative analysis from the data. Select Production Report tab…select detailed or summary…select date range…OK. Provides a palette on the right side of the dialog box to define a custom color. On the Format tab, do any of the following: For any selected chart element: Click Format Selection in the Current Selection group, and then select the formatting options that you want. However, multiple Worksheets can be selected at once. , a formula, text value, numeric value, or date value. Slide Transition Effects. Select the data you would like to use for your chart. If it's turned on, the chart appears after each group (page field in the case of a cross-tab report), showing the data for just that group. I have used the column chart. Click Apply. The graph will have the budget total cost (cost) and remaining cost. Select a Paper Size. From the pull-down menu under the Graphs option at the top of the data view or variable view screen, select "Legacy Dialogues. Format Data Labels in Excel: Instructions. Your selection appears in the Selected Color field. To open the Strategies tab and launch a strategy: By default, the tab is open. The Show Selection Only option is not enabled for Chart 1. The selected cell in which data is entered when you begin typing. Go to the Insert tab and click Recommended Charts. In the Workflow tab, a newly created workflow only includes the tasks "START" and "END". This will create a copy of chart objects. To make a chart sheet or worksheet the active, or selected, sheet. To insert a chart, navigate to the Insert tab and click the Chart button. One part of the fluid new experience is the Formatting Task pane. Use an icon to represent the dialog type. A list of project fields is shown. CHART BASICS. On the Layout tab at left, specify border style and color, background color and opacity, or padding size in pixels. Figure 2: Sparklines must be located in a single column or row. To name your chart, double click the Chart Title text in the chart and type a title. Once you create your Excel chart, you can also use the Design tab to refine and modify the chart for your needs. Make sure you select Vector Charts under View->Chart Type menu. If only one of the width and height options is specified, the other one will be calculated according to the aspect ratio. Click the All Charts tab and select the Combo category. When you press and hold the ALT key, the task will be added as an external dependency. Context tabs are tabs that only appear when you need them. AddChart Method in Excel VBA. Object model diagram for Microsoft Access. The following steps contain everything you need to help you with the Customer and Supplier Record Graphs tab. Only the selected categories will be displayed on the chart. Blender can do a lot of 'stuff' so having a chart of some sort to 'map' all those keyboard shortcuts would be handy, especially if it were printable. Select the data and insert the chart; Click the chart. When the Change PivotTable Data Source window appears, change the Table/Range value to the new data source that you want for your pivot table and then click on the OK button. From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis. The color of the selected chart bar changes to indicate it's included in a filter. Clear, reset, or auto-fill button captions. Upon click, Insert Slicers dialog will appear, containing fields of the Pivot table. If it's turned on, the chart appears after each group (page field in the case of a cross-tab report), showing the data for just that group. Specifies that the dashboard will appear in the specified module and view for all users belonging to the teams selected in the Teams field Note: Only admin users can check or modify the Default Dashboard checkbox. Alternatively use the Recommendations engine and mark the columns Value and Category 1 and then double click on the waterfall chart. If your chart has fewer columns/rows than are displayed in the sample datasheet, click on the lower right corner and drag the mouse up/to the left to eliminate any extraneous columns/rows. Apply the same chart string to multiple line items, simultaneously The following procedure begins at the point of entering chart strings. WordArt A feature of Word used to transform text into a drawing object. I'm personally using angular-ui bootstrap tabs, so when I tab back to the original tab, the elem variable has a 0px height, although the actually element it is referring to no longer does. What is an Excel Pivot Table and Chart? A pivot table is a program tool, that is a built-in feature of MS Excel, allowing you to organize and summarize selected columns and rows of data in a spreadsheet to obtain a desired report, helping in visualization of data. Click the Dependencies tab. Then drop it into the slide area. How to Make Bar Chart in Excel. How to Print Only a Selected Area of An Excel Spreadsheet. In other words, a user can change the values display by double-clicking on any column header and making that column the primary sort. The name of the contextual tools for the selected object appears immediately above the tab or tabs associated with the tools. PAGE LAYOUT. This tab is similar to the Recommended Pivot Table. Should it be closed, go to View in the menu bar at the top of the trading platform and select Strategies. Backtesting and Data Playback. Suppose you have the financial data for a company ABC Ltd, and you want to see how the revenue has grown over the quarters. Insert Symbol, Chart, and Comment are all suddenly greyed out all the time. Stevie only B. No: Insurance option will NOT be provided for the selected shipping method. Start studying Excel Unit D. Dashboard Series: Creating Sexy Scrolling Charts In Excel Last month, I promised a series on creating dashboards in Excel. Image Formatting: Only available when the image options have been selected above. If you don't see a Chart tab in the Page Setup dialog box, then you don't have a chart sheet displayed. This will allow you to know which option has been selected by the dashboard consumer. Unlike the menus -- such as File, Edit and View -- in many other programs, Microsoft Office programs display tabs on a ribbon bar. Thereafter, click the Select Data button (highlighted in blue within Figure 2). A checkmark will appear next to any indicators you have selected and all selected indicators will show directly on your chart, not in the indicator window. The filter box as well as the item type groups assist in finding specific item types to show within the overview. To use See Records , select a visualization, then select See Records in the Data/Drill tab in the Visual Tools section of the ribbon, and then select a data point or row on the visualization. Step 10: Click "OK" and Excel will create the histogram. With the Home tab selected, click the arrow under New Slide and select a Title Only slide. And then, simply select the summary table, go to the Insert tab > Charts group and choose the chart type you want. Check the checkbox to have the custom filter section appear at the top of the tab displaying the report. I often use this feature in dynamic Excel reports to select dates, regions, products, and other settings. That’s it—she’s just created her chart. Insert Symbol, Chart, and Comment are all suddenly greyed out all the time. Deselect this option for calculating inventory pricing for all the warehouses combined. This tutorial covers the steps for creating pie charts in StatCrunch with summary data. After your chart appears, you will see that two new tabs. Click Add Another Itemization. As purpose "Organization chart" is selected. The Comfort Chart Definition dialog box appears. Then, in Excel 2003, choose Row or Column from the Format menu and select Unhide. Threats Chart The Threats chart on the Threats tab of Dashboard displays the total percentage of messages detected as threats. You should now have a dashboard that changes sheets and is driven by a user interface element such as a shape instead of using a parameter!. With enabled gridlines, the grid will appear only within the canvas (which we'll get to next) when it is selected, but when any other part of the Word document outside the canvas is selected, the grid will be displayed over the entire document. In this article, we will provide an overview of how to insert and format Smart Art, pictures, clipart, shapes and objects in PowerPoint 2007. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format. The Insert Tab is used to insert different features such as tables, pictures, clip art, shapes, charts, page numbers, word art, headers, and footers into a document. If true, the geochart will be drawn at the largest size that can fit inside the chart area at its natural aspect ratio. If duration of dock commitment is >= 26 minutes. Right-click the selected chart, from the context menu, choose the Edit Data option (highlighted in red within Figure 2) to open a sub-menu. The Insert Tab is right next to the Home Tab in Microsoft Word 2007. On the Ribbon, select the Chart Tools Format tab, then click Format Selection. The resulting chart is almost perfect. Which tab appears only when a chart is selected?. The Absence Letter dialog box appears: Click Run to. Follow the below steps to preview the selected color palette over different chart types. When the mouse is moved over a tab, a "hint" will be displayed showing either the description of the plot (that can be entered by right-clicking on the tab) or the names of the variables that are plotted on the X and Y axes. a sales channel or name, and see the chart update. Select a chart type from the list on the left You only need to include a legend when you are. Check out how to create an Excel 2019 chart. Note that these contextual tabs appear only when you have selected a graphic. This toy data set contains only two columns of data. The custom format feature in Excel allows the user to “paint” or mask a number, text, date or time value in a user defined custom format. In this entire list, I have marked some of my. In the dialog box under Legend. If you are in an unstable environment, you are unlikely to ever have population growth to the point where density dependent factors come into play. From the pull-down menu under the Graphs option at the top of the data view or variable view screen, select "Legacy Dialogues. To filter entire rows or columns of data from your view, select the header in the view. You can change the name. The name of this status bar reflects the names of the two analysis fields in the chart, if there is only one matrix chart in the visualization project. You should now have a chart that looks like below:. 10, when this is checked, a short phrase accompanies the target lines. To change the chart type: Select the Design tab. One of the things I really like in Microsoft Office 2010 is the redesigned Print tab in the Backstage view. In this video, we'll show you how to work with visible cells only. When a magnifying glass icon appears in the e-doc, you can click it to look up information from a list. Click the Insert tab at the top of the window, then click the type of chart that you want to create from the various options in the Charts section of the ribbon. Once you make your chart big enough, your labels should show. Select cells L1:M303. hide or display chart title, display chart legend, add. To check the problem, David should first select cell E14 and look at the _____ to check the formula. [ Download our Excel 2016 cheat sheet: Ribbon quick reference guide] To use Simple Sharing, first save the file to a OneDrive, OneDrive for Business, or SharePoint account. AU Bar Chart The “Display Options” tab allows you to display the chart variable, stratification variable, the page-by variable, and the numeric variable to be charted for the entire time period selected. It automatically synchronizes the selected tab with the currently displayed view and vice versa. Now, carefully right-click the Chart Area-- from the resultant menu, select the Format Chart Area option, highlighted in red within Figure 1. Using this with only one cell selected will perform the operation only on the cell directly above:. Check the checkbox to have the custom filter section appear at the top of the tab displaying the report. Your selection appears in the Selected Color field. The next step can vary: If you want to use intercompany transactions, the Intercompany Setup screen is the next step. On the tooltip that appears, select to Exclude or Keep Only the selected data. Group/Button Description Pages Group Cover Page. Called Chart Tools, there are three chart context tabs: Design, Layout, and Format. 4 side you only have the resolution. Chart area B. Select "Scatter. Which tab appears only when a chart is selected?. Custom Color Palette. The graph includes two lines: h-index and the 450 line:. Pro tip: Create a Gantt chart in Excel by Susan Harkins in Microsoft on April 21, 2014, 8:14 AM PST You don't need specialized or expensive software to create a simple Gantt chart. When a ribbon tab is selected, these keys navigate the tab buttons. Viewing Charts Interactive Flash-based charts let you view market value and volume for a single stock, future or index for one of seven time periods (1 or 5 days, 1, 3 or 6 months, 1 or 5 years). The number of counters currently selected to add to the chart and the number of counters that can be added to the chart to reach the total of 50 is displayed next to the Add button when counters are being added. Regardless of which worksheet your chart is on, it will be grabbed and saved to a PDF. If you want to show trend line in a chart only, you just need add trendline for this chart firstly, and then hide original data series (color bricks) from the chart. On the New Itemization tab, select the expense type that applies to the first itemization. Excel 2016 and 2019 cheat sheet Get to know the key features in Microsoft Excel 2016 and Excel 2019 for Windows. Select Hide Selected Items from the sub menu. Who is/are correctly adding a chart? A. Select Format Data Series at the bottom of the list. Each value in a cell you select for your chart is a data point. The final chart is shown at the bottom of Figure 3. Alternatively, you can also get started from a template to save time. Click through to that article for detailed information on how to get the most out of Word 2013. This cannot be on the worksheet just added for reasons that will become apparent below; Next, create a hyperlink that links to the worksheet just added (it doesn't matter which cell you choose); The text to display selection is critical. When you select a detail line in the chart of accounts, the Account Detail Definition tab appears at the bottom of the screen. Learn how to add a secondary axis to your Excel charts on a Mac, PC, or in a Google Doc spreadsheet. If you don't see a Chart tab in the Page Setup dialog box, then you don't have a chart sheet displayed. some categories make up “a lot” or “a little” of the whole thing). Excel Unit D Concepts Review. A report is made up of a collection of widgets that display your data as charts, graphs, and tables—widgets are the building blocks of reports. Remove Mappings: When clicked, deletes the selected mappings and opens a dialog box that allows you to confirm deletion. Metric list : Double-click a metric to populate the chart window. Figure 2: Sparklines must be located in a single column or row. On the Scale tab, do one or more of the following: Important The following scaling options are only available when a value (y) axis is. Select the data to appear to appear in the chart (with labels if relevant) Use the Insert tab and Charts Group and click on the relevant chart in this group. Click the desired chart sub-type. Click on the Timing tab. I have selected "Show all" and this is what the map chart looks like. The selected cell in which data is entered when you begin typing. Set up an insurance rate chart, handling fee option and additional packaging settings in the Insurance and Options tab. The chart types are arranged along the left side of the window. a sales channel or name, and see the chart update. Click "Close" to close the Format Data point window. The following hotkey chart shows the basic shortcuts available for Blender. Display title for tab UI elements to include within the tab. A pie chart shows the value as parts of a whole, this only graphs one column or row at a time. I was working in Excel 2010 on a workbook with multiple sheets when I suddenly couldn't interact with the Insert or Data menus (they were entirely greyed out), I also couldn't interact with my PivotCharts at all. Apparent, true equator, equinox and epoch of the date This is the true apparent position for the equinox of date of the chart, including correction for proper motion, precession, nutation, aberration, light deflection. Step 9: Check the "Chart Output" box. Repairing a corrupted workbook, Excel File through all series in the chart and write their values to AutoRecover for this workbook only check box is not selected. CTRL + click on the chart to select it, then choose Format > Object. And there is no event to capture the change of Drop-Down Form Field. In this case, we want to set clearing the selection to "leave the filter" so that only one chart shows. At the top of the dialog you will see a couple pre-canned combo charts to get you started and Clustered Column - Line is the default. Here offers two methods to find out the Chart Tools in Microsoft Excel 2007, 2010, 2013, 2016, 2019 and 365. In that program, a contextual tab is a tab along the top that only appears when you have selected a certain. For example, entering dates along the x-axis gives your clients a view of your sales over time. About the Rate Tab. To create a line chart from the duplicate data range: Select the data and headings in the duplicate data range -- cells B8:H11; On the Ribbon, click the Insert tab; Click the Insert Line Chart command, then click 2-D Line Move and resize the chart, if necessary, to fit on the worksheet. By default, gridlines don't appear on a printed worksheet or workbook in Excel 2007. Note that the options in the Chart Values area apply only to bar charts and pie charts. With enabled gridlines, the grid will appear only within the canvas (which we'll get to next) when it is selected, but when any other part of the Word document outside the canvas is selected, the grid will be displayed over the entire document. When multiple Worksheets are selected only the "top-most" Worksheet is considered active (the ActiveSheet). To do so:. On the tooltip that appears, select to Exclude or Keep Only the selected data. ) The line items you selected are now checked. Allocation: Returns 1/ Occurrences. Those of you that enjoyed using the feature called Data Form in earlier versions of Excel may be unhappy when you can't find it anywhere in the new 2007/2010 Ribbon interface. Click the Pie option and choose a type, either 2D or 3D, depending on your requirement. Right-click, then select Format where is the axis, series, legend, title, or area that was selected. If only one of the width and height options is specified, the other one will be calculated according to the aspect ratio. Display chart after each group: if this setting is turned off, the chart appears at the end of the report, showing the data for the entire report. Click the Daily Office, Daily Roster, or Daily History side-tab. These tasks aren't displayed on the chart because they are either filtered out (if the “Displayed tasks only” option is selected) or they are placed in a location that isn’t included in this Workload chart. Selected Sheets vs ActiveSheet. Excel 2010 automatically embeds new charts on the same worksheet as the source data, but you may find it easier to work with a chart if you move the chart to its own chart sheet in the workbook. The list can be pre-populated with values from the accounting system if allowed. Select the Chart Animation tab. Select Worksheet. To do so:. SmartArt: What option makes entering text into a SmartArt graphic. The chart preferences are used to customize the appearance of the chart such as titles, colors, legend position, etc. How to select series names for legend from chart data (Excel 2007) In Excel 2007, I want to set the names of the series (that appear in the legend) using data in the chart. To insert a chart, navigate to the Insert tab and click the Chart button. Note: The Design tab under Chart Tools is not the same as the default Design tab in PowerPoint. To delete tabs in PowerPoint for a selected paragraph, click and drag a tab stop from the horizontal ruler. Include description. There used to be a tab that would show up when i selected a chart, but now nothing appears. com, Adobe ConnectNow, and Adobe FormsCentral to help you distribute the form to the masses and get the information into a usable form. This will allow you to know which option has been selected by the dashboard consumer. tab appears,, offering you ways to adjust the selected image. Consequently, if you hide. The next step can vary: If you want to use intercompany transactions, the Intercompany Setup screen is the next step. Click Plot to plot the chart of the selected property vs the elements in the table. About Text Entry Questions Text Entry questions allow you to collect open-ended responses from your respondents. graphs, pie charts, and frequency histograms. Now, carefully right-click the Chart Area-- from the resultant menu, select the Format Chart Area option, highlighted in red within Figure 1. Notes: • If a shortcut requires two or more keys at the same time, the keys are separated by a plus sign (+). Secondary horizontal and vertical labels can only be used when dual axes charts are selected. With the Task bar selected in the top half of the dialog box, click the Text tab and click inside the position you want to display the multiple fields. The Absence Letter dialog box appears: Click Run to. Metric list : Double-click a metric to populate the chart window. Recommenders, in turn, can create and upload recommendations for the applicant to the WizeHive system. active cell. Other versions of Excel: Click the Insert tab, click Bar Chart, and then click Clustered Bar (in 2016 versions, hover your cursor over the options to display a sample of how the chart will appear). Just click it and thump your chest. Use Team Roles tab to provide a list of project team roles in the Team Role column on the Team tab in Project Analyzer. In Excel 2007/2010. 3 Create an Organizational Chart in Human Resources Management 4 Make a Company Chain of Command Graph The workplace has evolved from traditional office work to today's remote location possibilities. The name appears in the title bar of the dashlet. Until now, precise adjustments to chart elements were made in the Format dialog box. With the cell still selected, on the Home tab, click the arrow beneath Paste, and then the first icon in the Paste Values area - Paste Values. Absence Letter. David has a small business and is working on an Excel worksheet to help manage his inventory. In the dialog box under Legend. Last updated Tuesday, July 2, 2019, at 4:21 p. To select multiple sheets in a Tableau workbook, hold down the Ctrl key as you select sheet tabs along the bottom of the Tableau workbook. Close the chart editor by clicking File | Close, or by clicking on the X in the upper left corner of the window or Alt-F4. The Auto Correct options "Include new rows and columns in table" and "Fill formulas in tables to create calculated columns" are checked. Left Arrow or Right Arrow selects the tab to the left or right when the ribbon is selected. The Panel Button Configuration tab appears when a touchpanel port is selected in the IP Link ® Tree window and functions include: Adding a layout. ul#tabs li a. Current Status. The patient's imaging page opens to the history view, and the most recent image or series (such as a full mouth series or bitewings) is selected by default on the Images tab. In Excel 2007+, select the chart and go to "Design" tab. Mini Chart Settings: Only available when Mini Chart has been selected as Display Option for an expression in the table. We can only change the selection of Drop-Down Form Field by moving item position. The Profile tab, created when you ran capture_tpu_profile, appears in TensorBoard only after you have captured some model data. The h-index value appears on the tab label. Note: To view the red, green, and blue levels at particular points in your preview image as you make adjustments, click the densitometer icon in the Preview window and move your cursor over an image area. Step 9: Check the "Chart Output" box. The line chart appears with the selected settings. " - Daniel Kvist Oct 26 '15 at 22:15. Delete the other fields from the fields list. Introduction Samsung's Galaxy Tab 4 tablets come fresh from the oven, and the Galaxy Tab 4 7. Select your strategy from the list. New to version 7. On the Format tab, do any of the following: For any selected chart element: Click Format Selection in the Current Selection group, and then select the formatting options that you want. Jane wants to add a chart to her presentation so she'll click the Insert tab and in the Images group, she'll click the Chart button. One benefit of a gantt chart is that it's easy to create. Miscellaneous. The activity in focus can be selected in various ways, e. How to Show and Hide the Worksheet Tabs in Excel Lori Kaufman @howtogeek June 24, 2015, 10:24am EDT If you're short on screen space, you may want to hide parts of the Excel window, such as the ribbon and the worksheet tabs. Click the Roster side tab. Excel’s online help for charts provides excellent suggestions on what chart types are especially appropriate to display. Right click on one of them (doesn't matter which) and select Format Control, and on the Control tab, click in the Cell Link box, and select cell K1. Open two apps with Multi Window for multitasking on the go. So far we have only seen charts on the same worksheet as the source data (embedded charts). There are some differences between Regular and TPO chart types with regards to order generation in real time and backtesting. New to version 7. On the tooltip that appears, select to Exclude or Keep Only the selected data. Then use the drop down boxes in the "Edit the Rule Description" section to (1) Select Specific Text, (2) Containing , and then ty. The line chart appears with the selected settings. You can also add the population number, right click on map and click on "Add Data Labels", see chart below. This dialog box is actually our old Insert Chart dialog box. First, go to Charts and select Drawings>Arrow, then move your cursor to the desired location and click to place the drawing. >> Dynamic Excel Chart with Series Selection Check-box Apart from being super cool, Excel dynamic charts are really helpful in presenting a comparative analysis from the data. Only options that are applicable to the chart being modified can be changed. Historical Usage tab: Displays a line chart that shows storage usage for the volume. Chart shift — shift the chart from the right edge of the window to the shift mark. Table/View Owner - Select the owner of the table on which you are building the chart. Upon click, Insert Slicers dialog will appear, containing fields of the Pivot table. Next select the Sheet tab in the Page Setup windows that appears. If your chart has fewer columns/rows than are displayed in the sample datasheet, click on the lower right corner and drag the mouse up/to the left to eliminate any extraneous columns/rows. Sorry for the confusion. To populate the chart window with a separate chart for each of the metrics in the group, double-click a metric group. With the chart selected, on the Chart Tools: Layout ribbon tab in the Labels tab group, click on the button Axis Titles. They represent a numeric scale, usually located on the left side of a vertical chart. The chart would be a series of lines and points but I would be selecting only one of the points on the series. Flashcards. Answer to Which tab appears only when a chart is selected?a. To kick off the series, I started with a tutorial on how to create. The client configuration settings are grouped into categories under the Configuration menu in the WebFOCUS console. Switch Row/Column D. Suppose you have the financial data for a company ABC Ltd, and you want to see how the revenue has grown over the quarters. 4 Legends Tab The fourth tab in the Chart Options window is the Legends tab, which allows you to place the key to the graph symbols and colors at different places around the graph. A menu appears with only two choices. Close the Slide Layout pane. graphs, pie charts, and frequency histograms. Select the data and insert the chart; Click the chart. This process shows you how to hide values in the pivot chart. The sub-type menu displays.