Click and drag to highlight the data in your table
Click on F11 on your keyboard
A simple barchart appears!!
Creating a Chart using Chart Wizard
Click & drag to highlight area to be charted.
Include: Row & Column Labels and (of course) data. See the example below.
Click on Chart Wizard Icon
Now Chart Wizard is activated and takes you through the 4 steps of chart creation:
Chart Wizard Step 1: Chart Type
You can choose from either standard chart types or custom chart types. To use the standard chart types:
Click on The Standard Types Tab.
Click on the Chart Type required.
Click on the Chart Sub-type required.
Click on
You can view what your chart will look like.
Click and hold on .
Chart Wizard Step 2: Chart Source Data
Your chart is displayed, based on the data that you have used: Look at the picture of the graph you have created. Is it what you expected? You may need to change some of the settings, if not.
Data Range
Check that you have used the correct data range for your chart.
Series in
If the X axis labels are in the legend and visa versa, you can swap them around with this. Try clicking on Rows or Columns to see how it affects your sample chart
Series Tab
You can add or delete series of data and check that the correct cell range for each series has been chosen.
Click On when finished here
Chart Wizard Step 3: Chart options
You can use the options available with each tab to add final touches to your chart.
Titles
Add titles to the chart and the X and Y axes
Axes
Displays or hides the X and Y scales on the chart.
Gridlines
Adds or removes gridlines to your chart
Legend
Adds or removes a legend and changes its position
Data Labels
Adds or removes labels to points on the chart.
Data Table
Adds or removes a table containing the data from which the chart was created.
Click On when finished here
Chart Wizard Step 4: Chart Location
Finally Excel asks where you would like to place the new chart: in a new worksheet or as an object in an old one.
Click on Finish.
Working With A Chart If It Is Inserted As An Object In A Sheet
Moving A Chart
Click on chart to select it Square boxes should appear around edges
Click and drag the chart to the new location
Copying A Chart
To create a second copy of a chart (possibly to use the same data and change the display):
Hold down the CTRL key on the keyboard
Click and drag the chart to the second location You Can Also Use Cut, Copy And Paste See page 46 - “Moving And Copying Things”
Sizing A Chart
Select the chart (by clicking on it) Black squares will appear around it
Click and drag on the squares to size the chart
Deleting A Chart
Select the chart (by clicking on it) Black squares will appear around it
Press Delete on the keyboard
Using The Chart Toolbar
Seeing The Chart Toolbar
The toolbar should appear as soon as you click on the chart. If it doesn’t select View Menu : Toolbars : Chart
T
Show / Hide Data table
Show / Hide Legend
Click here to slope text. he Chart Toolbar
Click here to change the chart type.
Click here to select a chart object.
Click here to change the data series from rows to columns and vice-versa.
Click here to alter the format of the chart object selected.
Tearing The Chart Type Selector Off The Toolbar
If you want you can keep the Chart type selector on screen at all times. You can then use it as a quick way to create or change a chart
Click on the downward arrow next to the chart type icon.
Click on the topmost bar and drag downwards.
Click and drag the toolbar about by clicking and dragging on the title bar (“Charts”)
Close the toolbar by clicking on the sign in the top right