Link to home
Start Free TrialLog in
Avatar of jskfan
jskfanFlag for Cyprus

asked on

MS Excel Script

I have an Excel spreadsheet , a sample of it is shown below.

User generated image
I would like to have each EmpID in a separate worksheet that will display
Date by older date on top row
EmpID
Cost

I do not need it to display Daily .. I need just Week End

that would be perfect if I can have a Chart (Histogram) added on each worksheet of the EmpID, based on Cost for each Date (older date first on the left).
it will display how the cost of each EmpID has fluctuated from 01/2017 going forward to more recent day.

I wonder if there is a script that can accomplish this ?

Thank you very much
SOLUTION
Avatar of Rob Henson
Rob Henson
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you to Shums for creating the sample data.

With that data I have created a Pivot Chart for what I believe you want to see.

The chart is created from the Pivot Table; changes to the table will be reflected in the chart and likewise changes to the chart will change the table. Use the EmpID filter in the table or the chart to change Employee

See attached.
Pivot-Filter.xlsx
Avatar of jskfan

ASKER

Thank you Guys..We'll try it later