unk the chart title to cell A1. Format the value axis to display whole numbers only. the chart tle, value axis, category axis, and legend with Black, Text 1 font color 1.5 21 Select the Series Sales tab, select the ranges A4:A7 and C4:C7 and create a pie chart. Move the pie chart to a chart sheet named Office Reference. Move the Office Reference chart sheet to the right of the Series Sales sheet. Change the chart title to Office Reference Series. Apply bold and change the font size to 18 23 for the chart title