$6$ To show the percent that each state contributes to the total sales, select the nonadjacent ranges that represent the state names and state totals $($in column F$).$ Insert a $3-$D Pie chart, and then move the chart to a New sheet. Name the sheet Net Sales Chart.

$6$

$7,$ Change the Chart Title to Annual Net Sales by State and then change the chart title Font Size to $32.$ Remove the Legend from the chart, and then add Data Labels that display only the Category Name and Percentage positioned in the Center. Change the data labels Font Size to $14$ and apply Bold and Italic. Change the Font color to White, Background $1$