Question: Need help with this excel homework, i ' m confused. Using the Monthly Sales Report 2 0 1 8 Data in Worksheet Chart depict the

Need help with this excel homework, i'm confused. Using the Monthly Sales Report 2018 Data in Worksheet Chart depict the following Charts:
1) January Total Units Sold by Region as % of Grand Total Sales
a) Display data labels in % by changing Format Data Labels to Percentage
2) January Inverter Sales by Region
a) Include Invertor product type only
b) Use Size (in column B) for each Invertor type to edit Series Names to be displayed in Legend
Calculate Totals as needed. Select appropriate chart type for each above and explain why each type was chosen. Include Chart Title , Legend and Data Label as appropriate.
Insert your charts in correspondent sections in Chart worksheet and enter your type choice explanation in the yellow cells. Resize the charts and merge the yellow cells as needed.
* Charts in the Screenshots below are for the demonstration purpose only
To Create A Chart ( screenshots for demonstration only) :
Select data you want to chart. If your data isn't in a continuous range, select nonadjacent cells or ranges by holding CTRL key.
Select from the tool bar Insert- Insert Chart
Select Chart TypeJanuary Total Units Sold by Region as % of Grand Total Sales
January Inverter Sales by Region
 Need help with this excel homework, i'm confused. Using the Monthly

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!