1126

Change the type of the chart displayed on the active worksheet into 3D Clustered Column chart.

 

1127

Create a pie chart (not exploded pie) on the 2ndhour2 worksheet. Accept the default settings. The pieces of the pie will represent the product and quantity data.

1128

Set the text Sales per Product as title of the chart displayed on the 2ndhour2 worksheet.

1141

Insert a 3-D column chart in the Contest2 sheet to display the sales of the four companies for August, as they appear on the SALES worksheet. Change the color of the columns to blue, the shape of the columns to Full Pyramids (2) and the chart depth to 150.

1172

Set the fill color for the active chart to red.

1173

Set the following fill effects in the active chart:

Gradient fill: color 1: red and color 2: White, Background 1

Type: Linear and

Direction: from red (top) to white (bottom).

The chart should not display any borders.

1174

Change the color of the Series1 Data Series to red in the active chart.

1175

Change the color of the active pie chart as follows:

RAM Memory to Black, Text 1

Hard Drive to Red,

Screen to White, Background 1

 

1176

Copy the active chart and paste it to the SALES worksheet.

1177

Move the active chart to the SALES worksheet.

1178

Delete the active chart.

1179

Increase the width of the chart area and decrease the height of it in dimensions of your choice.

1205

Without changing the size of the active chart, move it so that the top left corner is in cell D15.

1237

Create a chart using data from the cell range A5:E9 in line with markers type. Make sure the new chart is placed in a new worksheet.

 

1301

Go to the computer worksheet and decrease the height of the chart without moving it, so that the contents of the cell range B15:C15 may appear.

1303

Display the X (Primary horizontal) and Y (Primary vertical) axis of the chart.

1333

Move the legend to the bottom of the chart of the spreadsheet 2ndhour2.

1846

Select the chart of the active worksheet.

1847

Change the fill color of the legend of the chart to red.

1848

Change the font color of the legend to red and the font size to 12.

1881

Display the value data labels of the active chart.

1882

Display the percentage data labels on the active chart.

10131

Match the most suitable chart type for each situation.

20032

Change the color of the Gladbach column to red