Dynamic line chart

aleisaab

New Member
Joined
Aug 10, 2021
Messages
3
Office Version
  1. 365
Platform
  1. Windows
I have 3 items in my shop. Each item is placed in a separate list. Each list of salespeople with the monthly sales for each person

Let’s assume i run a business with 3 different services. I have a list of employees that sell all 3 services. I have an excel sheet for each service which contains a list of the employees along with their monthly sales numbers for 5 years. I also have another excel sheet that contains the sum of all sales for each employee on a monthly basis for 5 years.
I want to create a dynamic line chart that can allow me to analyze the performance of the employees in the most efficient way. I want to be able to compare certain employee sales and also choose certain dates. I also want to know who outperformed during tough times and who received the highest share of sales during holiday season. If there are any other criteria that would help i would sincerely appreciate it. Thank you in advance to anyone who could help me.
 

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.
Please ignore the first three lines. I don’t know how to edit a thread
 
Upvote 0

Forum statistics

Threads
1,213,546
Messages
6,114,255
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top