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, im confused. Using the Monthly Sales Report Data in Worksheet Chart depict the following Charts:
January Total Units Sold by Region as of Grand Total Sales
a Display data labels in by changing Format Data Labels to Percentage
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
