Add or remove titles in a chart - Microsoft Support
You can add a title to each axis in a chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth (series) axes in 3-D charts. Some chart types (such as radar charts) have axes, but they cannot display axis titles.
Using IF with AND, OR, and NOT functions in Excel
In Excel, the IF function allows you to make a logical comparison between a value and what you expect by testing for a condition and returning a result if that condition is True or False. =IF (Something is True, then do something, otherwise do something else)
Add or remove data labels in a chart - Microsoft Support
Add data labels to a chart. Click the data series or chart. To label one data point, after clicking the series, click that data point. In the upper right corner, next to the chart, click Add Chart Element > Data Labels. To change the location, click the arrow, and choose an option.
Change the display of chart axes - Microsoft Support
Display or hide axes. Click anywhere in the chart for which you want to display or hide axes. This displays the Chart Tools, adding the Design, and Format tabs. On the Design tab, click the down arrow next to Add chart elements, and then hover over Axes in the fly-out menu .
Move data labels - Microsoft Support
Move data labels. Applies To. If data labels you added to your chart are in the way of your data visualization—or you simply want to move them elsewhere—you can change their placement by picking another location or by dragging them to the location you want.
Create a memory-efficient Data Model using Excel and the …
Create a memory-efficient Data Model using Excel and the Power Pivot add-in. In Excel, you can create data models containing millions of rows, and then perform powerful data analysis against these models. Data models can be created with or without the Power Pivot add-in to support any number of PivotTables, charts, and Power View visualizations ...
Convert your SmartArt graphic into shapes - Microsoft Support
Applies To. You may want to have a single piece or shape of a SmartArt graphic fly in from off a slide. (Currently you can only do this with the entire SmartArt graphic.) Or you may want to reuse a piece of your SmartArt graphic in other ways.
Create a parameter query in Microsoft Query
Parameters are used in the query’s WHERE clause – they always function as a filter for retrieved data. Parameters can prompt the user for an input value when the query is run or refreshed, use a constant as the input value, or use the contents of a specified cell as the input value.
Get started with 3D Maps - Microsoft Support
Microsoft 3D Maps for Excel is a three-dimensional (3D) data visualization tool that lets you look at information in new ways. 3D Maps lets you discover insights you might not see in traditional two-dimensional (2D) tables and charts.
Create a Map chart in Excel - Microsoft Support
Create a Map chart with Data Types. Map charts have gotten even easier with geography data types. Simply input a list of geographic values, such as country, state, county, city, postal code, and so on, then select your list and go to the Data tab > Data Types > Geography.
Relationships between tables in a Data Model - Microsoft Support
Jan 7, 2010 · A relationship is a connection between two tables of data, based on one column in each. A workbook can store each piece of data in a single place, but display it in multiple places, by storing data into multiple tables with relationships between them.