Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

microsoft excel courses - chart

Forum home » Delegate support and help forum » Microsoft Excel Training and help » microsoft excel courses - Chart

microsoft excel courses - Chart

ResolvedVersion Standard

Milena has attended:
Excel Introduction course

Chart

Hou to create a line, column, graph in 2007?

RE: Chart

Hi Milena

Thanks for your question.

You can create all the chart types you mention in Excel 2007 by:

1. On the worksheet, arrange the data that you want to plot in a chart.

2. Select the cells that contain the data that you want to use for the chart.

3. On the Insert tab, in the Charts group, do one of the following:

Click the chart type, and then click a chart subtype that you want to use.

To see all available chart types, click a chart type, and then click All Chart Types to display the Insert Chart dialog box, click the arrows to scroll through all available chart types and chart subtypes, and then click the the ones that you want to use.

4. When you create a chart, the chart tools become available and the Design, Layout, and Format tabs are displayed. You can use the commands on these tabs to modify the chart so that it presents the data the way that you want.

I hope this helps.

Amanda

Excel tip:

Display pictures on Chart Data Point

Replacing a single chart data point bar with a picture.
Step 1: Left click on a bar. Then, wait, and do a second single click on the bar. This will select just one data point.

Step 2: Right click on the bar and select Format Data Point.

Step 3: On the fill effects tab, choose a picture. Browse for a picture for that bar. Indicate if you want it to be stretched or stacked. Repeat for each bar.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.