Change the type of the chart displayed on the active worksheet into Normal Column with 3D Look.
On the 2ndhour2 worksheet create a pie chart (not exploded pie). Accept the default settings. The pieces of the pie will represent data for product and quantity.
Set Sales per Product as title of the chart displayed on the 2ndhour2 worksheet.
Insert a Normal Column chart with 3D Look 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 pyramids and the chart perspective to 100.
Set red as the fill color for the active chart area.
Set the following fill effects in the active chart:
Fill type gradient: Linear yellow/brown.
The chart should not display any borders.
Change the color of the Series1 legend key from black to red in the chart.
Change the color of the active pie chart as follows:
RAM Memory to black,
Hard Drive to red,
Screen to white
Copy the active chart to the SALES worksheet.
Move the active chart to the SALES worksheet.
Delete the active chart.
Increase the width of the chart area and decrease the height of it in dimensions of your choice.
Without changing the size of the active chart move it so that the top left corner is in cell D15.
Create a Line (Points and Lines) chart using data from the cell range A5:E9.
Go to the computer worksheet and without moving the chart, decrease its height so that the contents of the cell range B15:C15 may appear.
Display the X and Y axis of the chart.
Move the legend under the drawing area of the chart appearing on the 2ndhour2 spreadsheet.
Select the chart of the active worksheet.
Change the fill (area) color of the legend of the chart to red.
Change the font color of the legend to red and its size to 12.
Display the value data labels as numbers of the active chart.
Display the value data labels as percentage on the active chart.