How to create a Chart in Excel 2010 and Excel 2007
First arrange your data
Type your data into the spread sheet, making sure that it is arranged in a grid.
To Create a Column Chart
- Select the data you wish to chart
- Click the Insert Ribbon
- Select Column Chart from the Charts Group
- Your chart will appear on the work sheet
Pie Chart
Select the data you wish to chart (in this case just the January and the fruits and their data)
- Click the Insert Ribbon
- Select a Pie from the Charts Group
Your pie chart will appear
To select a different region for the Pie – February for example:
- Select the Range for February
- Hold down the Control key
- Select the Range showing the fruit labels
- Click the Insert Ribbon
- Select the Pie chart from the Charts Group
- Your new Pie chart will appear
Let me know if this was helpful
What things do you need to create a chart for?