Creating Chart

Hi Uday

I believe I have come up with a solution.

What you need to do is create a Pivot Chart from the table in order to create a summary. This will in turn generate a Pivot Table which can serve a useful source of information. Here's how to do it:

1. Select any cell in the table and go to Insert > PivotChart

2. Select 'Existing Worksheet' then click in the 'Location' field and select a cell in the sheet so the cell is not next to the table. Click OK

3. In the PivotChart panel on the right, put a tick in the 'Name' and 'Date' fields to create Name/Month breakdown

4. Drag the 'Results' field to the 'Legend' box in the panel

5. Drag the 'Results' field again this time to the 'Values' box

6. Finally go to to Design > Change Chart Type and select a 'Stacked' column from the chart options

I hope this has answered your question. Please let me know if it has and if it hasn't then I will try to arrive at an alternative solution

Kind Regards
Martin