Adding data to a chart.

Change individual chart elements

Select a single element

right-click (call the context menu of the element);

Select the desired menu item;

· make changes (change the font, color, etc.). OK.

Removing and adding data to a chart

Deleting Chart Elements

· select the diagram element to be deleted;

· Press the Delete button.

Adding Data to a Chart

If new data has been added to the original table (a new row or a new column), you need to add it to the chart.

Method 1 : Select the range of cells to be added to the chart, move the cursor over the border of the range, and when the cursor takes the form of a cross with arrows at the ends, drag the cells to the chart area.

Method 2: Select the chart area. Execute the command Charts/Add data… In the New data window that opens, to specify the range, click on the cells with new data.

Method 3: To add new data to the chart, you need to right-click in the chart data area, select the Initial data command in the context menu and change the range of values and add series (if required)

Note : This method is also used when changing the data range if some cells have been deleted.

Exercise 1 .

Create a chart by table:

Fuel consumption
solid fuel
natural gas 0.1

For this:

1. Create a new Excel workbook, rename “Sheet1” to “Fuel”.

2. On this sheet, create a “Fuel Consumption” table.

3. Select the range of cells A2:E5.

4. Run the Chart Wizard to create a chart .

· Select the chart type – regular histogram. Further

· As a range of cells, select all cells of the table, except for the table header. Specify the arrangement of rows in rows.

Go to the Series tab, check if the names of the series and their values are correct. Add x-axis labels. Next

· Make the legend appear to the left of the data area.

Add a title to the “Fuel Consumption” chart and add labels to the “Years” and “In million tons” axes.

Add main lines along both axes. Further

· Place the chart on a new sheet, which you will call “Fuel Chart”. READY

Exercise 2 .

Change the “Fuel Consumption” chart:

· Change the Placement of the chart – place it in the sheet with the source table.

· Place the Legend at the bottom, add a fill (texture) and a bold style.

· Add intermediate lines along the X axis.

· Format the title of the diagram according to the sample (choose a frame with a shadow, fill method – gradient, change the font and style of the letters):

· For the Value Axis Title and Category Axis Title elements, on the Font tab, select Underline Double, By Value .

· For the Chart Area , check the box next to the command: rounded corners , add a fill (pattern).

· For the Chart Design Area, select an invisible frame and a transparent fill.

· Make the direction of the text in the title of the value axis vertical.

· For the Chart Area frame, check the box next to the rounded corners command, add a fill (pattern).

· Change the style of the data labels for solid fuels, remove the data labels for oil.

· Change the fill method for data series.

· Change the Value Axes (change the style and orientation of the letters).

Compare your result with the figure below.

Exercise 3

Adding data to a chart.

For this:

· Add columns for 2000 and 2004 and a row for peat to the table.

Fuel consumption
solid fuel
natural gas 0.1
peat 0.2

· Add the data for the year 2000 (F2:F5) to the chart in the first way ( see paragraph deleting and adding data to the chart ).

· Add peat data (A6:F6) to the chart in the second way .

· Add data for 2004 (G2:G6) to the chart in the third way .

· Remove the oil data from the chart. Change the chart data range in the third way .


Charts are also used to build graphs. To build ordinary function graphs, a scatter plot is used. You can display graphs of several functions on one chart.

Exercise 4 .

Plot the functions y = sin(x) and y = cos(x).

For this:

1. Fill in and format the table according to the model (when filling in the X column, use the fill marker, in the SIN and COS columns, use the appropriate functions):

x sin(x) cos(x)
-3.2 0.058 -0.998
-2.4 -0.675 -0.737
-1.6 -1,000 -0.029
-0.8 -0.717 0.697
0.0 0.000 1,000
0.8 0.717 0.697
1.6 1,000 -0.029
2.4 0.675 -0.737
3.2 -0.058 -0.998

2. Plot the B1:C10 range with data point markers . On the Row tab, select the X-axis labels – the range A2:A10.

3. Change the format of the data series: check the box next to Smooth line , change the appearance of the line and marker.

4. Format the chart as shown:

Tasks for self-fulfillment:

Task 1. According to the table used in exercise 3, build two diagrams:

· diagram of fuel consumption for 2004 ( Diagram type – Pie);

· diagram of peat consumption ( Chart Type – Graph).

· format the constructed charts, add titles, axis labels, etc.

Task 2. Build graphs of functions y=x 2 , , y=exp(x) (place all charts in one chart).

Be First to Comment

Leave a Reply

Your email address will not be published.