Creating a chart in Excel


Charts and diagrams can help to show trends, averages, high and low points, and more. Not only do they make your Excel worksheets more visually appealing, they also serve a definite information translation function, by making it easier for you to sort out and understand the information you are presenting. This is especially true when dealing with data being presented to third parties.

Please scroll down when you are ready to get started (or you can click here for a quick overview of the course navigation options).

Following are the key steps, providing fast access for confident users...

  • Step 1: Select the data range to display in the chart, making sure to include the column headings as these will be used to label the x and y axis of the chart
  • Step 2: Select the Insert tab on the ribbon - where you will find that many different chart type options are offered so you need to get to know which charts work for your audience.
  • Step 3: Select the appropriate chart type - perhaps start with a simple Bar Chart by selecting the Insert Column or Bar Chart button and then making a sub-type selection such as the Clustered Column chart.
  • Step 4: And there you have it. A Bar Chart using your selected data range is inserted into the current worksheet.
  • Options... To investigate other chart types available, try selecting the Change Chart Type button on the ribbon that will allow you to preview options with the selected data, before confirming a change of selection. Perhaps try changing the above selection to a 3-D Clustered Column and click OK to confirm that change.
  • If you would like to access alternate learning options, please scroll down...

Learning options

You can watch a video to see the steps being processed or you can try the interactive simulation and simply follow the steps presented to 'learn by doing'...

Launch Video Start Simulation

Conclusion and Feedback

We hope that you have enjoyed the topics covered in this course. If you talk we listen, so please enter your feedback in the input boxes below and then select the highlighted button when you are ready to save your work and exit. Copyright: Interaction Training Pty Limited - www.interactiontraining.net

Please enter any other skills or topics that you would like us to add to our learning range here...
Is there any other feedback or ideas that you might like to share to help us improve your learning experience?
x
Save and Exit
Continue
Return to menu