Abstract Transcript In this video, we’ll take a closer look at data series. In the Select Data Source window, data series are listed on the left. You’re free to edit this information manually. So what are the values listed on the right side of Select Data Source window? In short, this chart pulls data series names from columns, and axis labels from rows. If I grab the Switch Row/Column button, this is reversed....
Pivot charts are an extension of pivot tables. To illustrate this connection, I’ll start by creating a new pivot table and pivot chart. The first thing to notice is that both pivot tables and pivot charts change Excel’s interface when selected. When I click away, this list disappears, and when I click back it reappears. Row Labels are called Axis fields, and Column Labels are referred to as Legend Fields....
Related videos The videos below demonstrate this shortcut.
About This Shortcut This shortcut will ungroup selected pivot table items.
About This Shortcut This shortcut will ungroup selected rows or selected columns. Select whole rows or columns first before using. Related videos The videos below demonstrate this shortcut. Shortcuts to group, ungroup, and outline
About This Shortcut Unhide any hidden columns that intersect the current selection. Notes: (1) May not work in Excel 2010 on Vista or Windows 7. Discussion and fix is here: http://superuser.com/questions/183197/whats-the-keyboard-shortcut-to-unhide-a-column-in-excel-2010 (2) May not work in Excel 2007. See http://www.techrepublic.com/blog/microsoft-office/office-solution-keyboard-shortcuts-for-hiding-and-unhiding-columns-and-rows/ (3) In Windows 10, there is a conflict with a keyboard-switching shortcut. you might resolve this by unassigning the keyboard layout hot key. You may need to unassign the input language as well....
About This Shortcut Unhide any hidden rows that intersect the current selection. Related videos The videos below demonstrate this shortcut. Shortcuts to hide/unhide rows and columns
To illustrate, the Euro symbol () has a code point of 8364 in decimal notation. This numeric value is referred to as a “code point”. Code points are typically represented by the “U+” notation followed by hexadecimal numbers. Because Unicode is a superset of other character sets, it is very large. The first 128 code points in Unicode align exactly with the ASCII characters. Unicode can be implemented in different encodings, most commonly UTF-8 and UTF-16....
The result is a number in decimal notation. Unicode numbers Unicode assigns each character a unique numeric value and name. This numeric value is referred to as a “code point”. Code points are typically represented by the “U+” notation followed by hexadecimal numbers. Because Unicode is a superset of other character sets, it is very large. The first 128 code points in Unicode align exactly with the ASCII characters. Unicode can be implemented in different encodings, most commonly UTF-8 and UTF-16....
The result is a dynamic array of unique values. If this array is the final result (i.e. The UNIQUE function takes three arguments:array,by_col, andexactly_once. The first argument,array, is thearrayorrangefrom which to extract unique values. This is the only required argument. The second argument,by_col, controls whether UNIQUE will extract unique values by rows or by columns. By default, UNIQUE will extract unique values in rows. To force UNIQUE to extract unique values by columns, setby_colto TRUE or 1....
The easiest way to do this is to use theUNIQUE function. By default, UNIQUE will extract unique values in rows, so there is no special configuration needed. The result is the same array, sorted by Group: UNIQUE is adynamic function. If any data in B5:C15 changes, the output from UNIQUE will update immediately. Dynamic source range UNIQUE won’t automatically adjust thesource rangeif data is added or deleted. Values can be sorted by one or more columns....
Explanation This example uses the UNIQUE function, which is fully automatic. UNIQUE is a dynamic function. If any data in B5:B16 changes, the output from UNIQUE will update immediately. Dynamic source range UNIQUE won’t automatically adjust the source range if data is added or deleted.
Explanation This example uses the UNIQUE function together with the FILTER function. you might see amore basic example here. This array is returned to FILTER as theincludeargument, used to filter the data. FILTER returns another array as a result: This array is returned directly to the UNIQUE function as thearrayargument. Notice of the 12 original values, only 8 survive. The output from FILTER is dynamic. If source data or criteria change, FILTER will return a new set of results....
