Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started