Creating a chart in microsoft excel 2007

Raju S Das. Hi, Thank you for using Microsoft Community. Thank you. How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. This site in other languages x. Santhi Chelliah at Bank of India. Dada Vocal.

Apolsoft at Apolsoft. Jen Reyes at DepEd. Show More. Views Total views. Actions Shares. No notes for slide.

Excel - Create a chart 1. Overview: Charts make data visual Create a chart A chart gets your point across—fast. With a chart, you can transform worksheet data to show comparisons, patterns, and trends.

So instead of having to analyze columns of worksheet numbers, you can see at a glance what the data means. This course presents the basics of creating charts in Excel Lesson 1 Create a basic chart 6. After you create a chart, you can easily add new elements to it such as chart titles or a new layout.

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. Create 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. Click the Insert tab, and in the Charts group, click the Column button. Click Clustered Column , the first column chart in the 2-D Column list. Create your chart Create a chart If you want to change the chart type after creating your chart, click inside the chart. Then select the chart type you want. It shows you at once that Cencini represented by the middle column for each month sold the most tea in January and February but was outdone by Giussani in March.

How worksheet data appears in the chart Create a chart Data for each salesperson appears in three separate columns, one for each month. The height of each chart is proportional to the value in the cell that it represents.

So the chart immediately shows you how the salespeople stack up against each other, month by month. How worksheet data appears in the chart Create a chart Each row of salesperson data has a different color in the chart. The chart legend, created from the row titles in the worksheet the salesperson names , tells which color represents the data for each salesperson.

Giussani data, for example, is the darkest blue, and is the left-most column for each month. How worksheet data appears in the chart Create a chart The column titles from the worksheet—January, February, and March—are now at the bottom of the chart. On the left side of the chart, Excel has created a scale of numbers to help you to interpret the column heights. After your chart is inserted on the worksheet, the Chart Tools appear on the Ribbon with three tabs: Design , Layout , and Format.

The Chart Tools go away. Take the first steps either by inserting a chart using the Charts group on the Insert tab , or by clicking inside an existing chart. The commands you need will be at hand.

To get them back, click inside the chart. Then the tabs reappear. Change the chart view Create a chart You can do more with your data than create one chart. This code works on 3 other machines but not on one. They're all running Windows 7 and Office They all have the same references selected in VBA too. I've tried to pinpoint the problem and it looks like it's coming from the chart creation code. So I've made the most simplistic code I can think of and it generates errors.

I want to create a chart on a sheet and the following code gives me an error: Sub Macro1 Range "A1:D1". Select ActiveSheet. Select does not add a chart. Therefore the Select part has nothing to select. Also, if I run the following code it does not create a chart: Sub Macro1 Charts. Could it possibly be a corrupted library? Any help would be greatly appreciated. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread.

I have the same question Report abuse. In the worksheet below, we have outlined three data series which form a cell range. A KeynoteSupport. To select the cells to chart, click and drag the cursor from the top left cell to the bottom right cell of your range, including column and row headings. Columns or rows containing totals should not be selected in most cases. Non-contiguous rows and columns can be selected by pressing and holding the Ctrl key while selecting each data series.

In the worksheet example below, we selected column headings for the four quarters, and just the data for "Trees. After you've chosen your chart type and selected the data series rows or columns to chart, follow the directions below to insert the chart into your spreadsheet. Note: In the new versions of Excel, hover the cursor over a chart type or sub-type on the Insert ribbon to display a description of the chart. Note: In older versions of Excel, click the chart type or sub-type in the Chart Wizard to display a description of the chart.