Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Create a bar chart that summarizes each Salesperson's cumulative sales during the 1 2 - month period: Double click on Sheet 1 at the
Create a bar chart that summarizes each Salesperson's cumulative sales during the month period:
Double click on "Sheet at the bottom of your workbook and rename it "Total Sales by Salesperson."
On the lefthand side under "Dimensions" sometimes labeled as Tables click on "Salesperson" and drag it to the "Columns"
area above the blank sheet.
On the lefthand side under "Measures", click on "Order Amount" and drag it to the "Rows" area.
This will create a vertical bar chart.
The calculation will default to Sum which is what we need for this exercise.
Order the bar chart from highest to lowest Descending by clicking on the "Descending Sort" button in the menu bar at the
top of the screen.
Label each bar with its respective amount by clicking on "Order Amount" and dragging and dropping it onto the "Label" Marks
tube
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