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 pyramid (2) and the chart depth to 150.

1250

Change the font color of the values on the horizontal axis into blue and the font size of the values on the vertical axis into 12.

1251

Fill the columns of the chart using the image TEST4U.jpg located in the IL-ates\Excel folder on your desktop, without stretching it.

1275

Modify the type of chart as to DELLA Data Series only. Apply a chart type of your choice.

1281

Insert the MICRONA data for the first five months on the chart appearing in the SALES worksheet.

Then copy the chart to a new Word document, so that changes to the source chart are reflected to the chart on your Word document.

1527

Create a 2-D pie chart (not exploded pie) on the active worksheet. Accept the default settings. Each pie piece would represent the product and quantity data appearing in the 2ndhour2 worksheet of the IL-ates1527.xlsx workbook located in the IL-ates\Excel file on the desktop.

1529

You can see a pie chart on the 2ndhour2 worksheet. Rotate the chart so as to place the slice representing motherboard on the top.

1530

Format the horizontal axis of the chart appearing on the 2ndhour2 worksheet, to set scale between 0€ and 16000€, font color in White, Background 1, Darker 50% and font size in 8pts. Display major units every 2000€ and outside minor units mark every 1000€.

1531

Pull out all of the pie slices at the same distance from the center of the chart of the 2ndhour2 worksheet.

1532

Pull out from the pie chart of the 2ndhour2 worksheet only the Motherboard and Screen pie slices.

1533

Move the legend on the top of the chart appearing on the 2ndhour2 worksheet. Then, change its width to the maximum.

1534

Make sure the legend of the chart appearing on the active spreadsheet is not displayed and increase the chart area as much as possible inside the chart.

1535

Delete the Data Series of March displayed in the chart of the Graph worksheet.

1536

Insert the Data Series of May in the chart appearing on the Graph worksheet.

1537

Delete the IL-com company Data Series in the chart appearing on the Graph worksheet.

1538

Set the Series Overlap in 40% and the Gap width in 60% on the active chart. Also change the Series order so that JAN is displayed above all, FEB is displayed in the middle and MAR is displayed behind all.

 

1541

Navigate to the IL-ates\Excel folder on the desktop and find the image brick1.gif. Set the image as filling on JAN data of the chart. Repeat for FEB data with the image brick2.gif and for MAR data with the image brick3.gif. The images should not be stretched.

1855

Fill the columns of the chart using the arrow image located in Sheet1. Then, delete the image.

1917

Create a Line-Column on 2 axes chart in the Sheet1 worksheet deriving data from the cell range A1:C4.

1918

Display the secondary axis of the data series Quantity.