Welcome to your weekly Excel tips from DataMinded. This Friday I’ll show you quick steps to creat charts from Pivot Tables, using Pivot Charts, how to move to the end of the sheet using a keyboard shortcut, and how to use the SEARCH function in Excel to find characters and words within a cell.
How to create a Pivot Chart
Pivot charts are an easy way to create graphs and charts directly from a pivot table. If you’ve already used a Pivot table to summarise your data, it’s quicker to use pivot charts, rather than regular charts To create a pivot table chart, let’s consider the following data and pivot table.
Click on the pivot table and the PIVOTTABLE TOOLSsection will be added to the toolbar. Click on ANALYZEand PivotChart:
In the Insert chart dialogue box, choose the chart type and press OK:
You will see that the chart will be created:
An easy shortcut to move to the end of the sheet
To find the last cell with data in a sheet, you can use the shortcut CTRL+End.
This shortcut will select the cell that is in the last row and last column with data.
How to use the SEARCH function in Excel.
The SEARCHfunction is excel is used to find the position of a character in a string.
The syntax for this function is as follows:
find_text – this is the character that we are looking for
within_text – this is the string that contains our character
start_number – with this we can decide from which character to start looking. It is an optional argument, if you don’t enter anything, it will start looking from the first character.
If we take an example, and find in which position is the space in the following string:
This formula will return 7, the space is in the 7thposition from the beginning of the string.
Now let’s try and find the “n” in the same string:
This will return 2, so it will find the first “n”, not the second. If we want the position of the second, we can start searching from position 3, so the first “n” is omitted:
This formula will give us the position of the second “n”.