How to create Pivot Charts in Excel

1.png

 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.

1png.png

Click on the pivot table and the PIVOTTABLE TOOLSsection will be added to the toolbar. Click on ANALYZEand PivotChart:

2.png

In the Insert chart dialogue box, choose the chart type and press OK:

3.png

You will see that the chart will be created:

4.png

Read more about this functionality here.

 

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. 

To get a full list of Excel shortcuts, check out the Microsoft help article

 

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:

5.png
 

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:

6.png
 

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:

7.png
 

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:

8.png
 

This formula will give us the position of the second “n”.

Read more about this function here.

Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit