Happy Computers Essentials Guide to

Charts: With the Chart Wizard

Creating a Chart in a whizz!!

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