Create pivot chart on same worksheet

In this example, we’re going to analyze voting results with a pivot table. In the data, we have the fields: Name, Gender, Age, and Vote. And, you can see, that there are 3 voting options, A, B, and C. First, how many people voted? By counting Name, you can see that we have 300 votes total. Next, …

In this example, we’re going to use a Pivot Table to analyze instrument measurements. This data consists of Temperature readings taken in a greenhouse over a period of days. We have Date, Time, temperature in Celsius, and temperature in Fahrenheit. So, first, how many readings do we have? You can …

In this example, we’re going to look at sales data by salesperson. In the data, we have the fields: Name, Date, Amount, and Region. To start off, let’s look at total sales by region. This would be easy to graph in a Pivot Chart as well. Next, what are total sales by month and year? To answer this, …