#Visual basic in excel 2007 tutorial how to#

How worksheet data appears in the chart Create a chart Here’s how your new column chart looks. On the Design tab under Chart Tools, in the Type group, click Change Chart Type.

You’ve created a chart in about 10 seconds.Ĭreate your chart Create a chart If you want to change the chart type after creating your chart, click inside the chart.

Click Clustered Column, the first column chart in the 2-D Column list. You’ll see a number of column chart types to choose from. Click the Insert tab, and in the Charts group, click the Column button.Ĭreate your chart Create a chart The picture shows the steps for creating the chart. Select the data that you want to chart, including the column titles (January, February, March) and the row labels (the salesperson names). You want to create a chart that shows how each salesperson compares against the others, month by month, for the first quarter of the year.Ĭreate your chart Create a chart The picture shows the steps for creating the chart. You’ll also learn a few other chart odds and ends.Ĭreate your chart Create a chart Here’s a worksheet that shows how many cases of Northwind Traders Tea were sold by each of three salespeople in three months.

#Visual basic in excel 2007 tutorial how to#

In this lesson you’ll find out how to create a basic chart and learn how the text and numbers from a worksheet become the contents of a chart. After you create a chart, you can easily add new elements to it such as chart titles or a new layout. Create a chartĬreate a basic chart Create a chart Here’s a basic chart in Excel, which you can put together in about 10 seconds. Develop an understanding of basic chart terminology. Find out how to make changes to a chart after you create it.

This course presents the basics of creating charts in Excel 2007.Ĭourse goals Learn how to create a chart using the new Excel 2007 commands. So instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means. With a chart, you can transform worksheet data to show comparisons, patterns, and trends. Overview: Charts make data visual Create a chart A chart gets your point across-fast. Microsoft ® Office Excel ® 2007 Training Create a chart Jim Taliaferro Community Mental Health CenterĬourse contents Overview: Charts make data visual Lesson 1: Create a basic chart Lesson 2: Customize your chart Create a chart Each lesson includes a list of suggested tasks and a set of test questions.