building a stats. from pivot table

Hi,

I'm attaching a starter Pivot Table for you to play with. Unfortunately there is no easy way to describe how to use a PT you just need to experiment.

In general though you can drag fields around within the pivot table and from the fields shown above the main table, and of course you can use the PT File list window to choose and position fields for analysis.

Difficult to comment without seeing the workbook. Attach it so that we can see what you've done. When you say the chart has disappeared, do you mean the Pivot Table has disappeared? Unless you've managed to select the whole chart and then actively chosen to delete it it will still be there.

As I said you need to play around by dragging and dropping various fields to various Row/Column positions to see the effect. This requires a certain amount of study and there are numerous youtube examples out there to show you, just google excel pivot tables.