Pivot Table and Pivot Chart

Chart

We just need data for the chart. Go to insert, click charts then choose your desired type of chart. You can modify the chart area and put title and on the chart area there's different layout, layout with table values with chart and you can change the color. You can switch between row and column. You can move into a new worksheet and edit your chart according to your want.