I have a Table "PivotChart" populated with data for Pivot Charts
The Pivot chart will be based on the jobno field
Catagory fields in Pivot cart will be jobno, ScopeDescription.PercentDescription
Data Fields in Chart will be Budget,Hrs,PercentAsHrs,
I wish to display a chart for the first Job number and after a set time e.g. 1 minute, refresh the data to display the next Job number and So on repeat until all Job numbers have been displayed, then start again.Of course i want to do this automatically.
The idea is to have the charts displayed on a workshop monitor for the trades men to see how there Job is going, with out any interaction from the workers.
Is this possible.
Data
jobno Hrs ScopeDescription Budget PercentAsHrs PCTD FBOPC PercentDescription
51492 0.5 Supervision 130 3 2 25 2 % of Scope Complete
51492 3 Bogie Assembly 16 8 50 6 50 % of Scope Complete
51492 32.5 Headstock fabrication 332 33 10 325 10 % of Scope Complete
51492 4 Main beam fabrication 330 0 0 0 % of Scope Complete
51492 1.5 Main wagon assembly 450 0 0 0 % of Scope Complete
51492 21 Minor misc assemblies 45 36 80 26 80 % of Scope Complete
51492 0 Airbrake & handbrake 130 0 0 0 % of Scope Complete
51492 0 Final assenbly (After painting) 95 0 0 0 % of Scope Complete
51492 0 Shunting 10 0 0 0 % of Scope Complete
51492 0 Project Management 150 0 0 0 % of Scope Complete
51492 0 Rework due to incorrect drawing from Allan Wallace 1 0 0 0 % of Scope Complete
51491 0.5 Supervision 130 39 30 2 30 % of Scope Complete
51491 2 Bogie Assembly 16 8 50 4 50 % of Scope Complete
51491 80 Rework due to incorrect camber(NCR60) 120 12 10 800 10 % of Scope Complete
51491 170 Headstock fabrication 332 33 10 1700 10 % of Scope Complete
51491 210.25 Main beam fabrication 330 231 70 300 70 % of Scope Complete
51491 85 Main wagon assembly 450 112 25 340 25 % of Scope Complete
51491 61.5 Minor misc assembly 45 40 90 68 90 % of Scope Complete
51491 0 Airbrake & handbrake parts fabrication 130 0 0 0 % of Scope Complete
51491 0 Final assembly (after paint) 95 0 0 0 % of Scope Complete
51491 0 Wagon testing 80 0 0 0 % of Scope Complete
51491 0 Shunting 10 0 0 0 % of Scope Complete
51491 0 Project Management 150 0 0 0 % of Scope Complete
51491 0 Rework due to incorrect drawing from Allan Wallace 20 0 0 0 % of Scope Complete
60319 1 Fit/Remove steps & handrails 4 % of Scope Complete
The Pivot chart will be based on the jobno field
Catagory fields in Pivot cart will be jobno, ScopeDescription.PercentDescription
Data Fields in Chart will be Budget,Hrs,PercentAsHrs,
I wish to display a chart for the first Job number and after a set time e.g. 1 minute, refresh the data to display the next Job number and So on repeat until all Job numbers have been displayed, then start again.Of course i want to do this automatically.
The idea is to have the charts displayed on a workshop monitor for the trades men to see how there Job is going, with out any interaction from the workers.
Is this possible.
Data
jobno Hrs ScopeDescription Budget PercentAsHrs PCTD FBOPC PercentDescription
51492 0.5 Supervision 130 3 2 25 2 % of Scope Complete
51492 3 Bogie Assembly 16 8 50 6 50 % of Scope Complete
51492 32.5 Headstock fabrication 332 33 10 325 10 % of Scope Complete
51492 4 Main beam fabrication 330 0 0 0 % of Scope Complete
51492 1.5 Main wagon assembly 450 0 0 0 % of Scope Complete
51492 21 Minor misc assemblies 45 36 80 26 80 % of Scope Complete
51492 0 Airbrake & handbrake 130 0 0 0 % of Scope Complete
51492 0 Final assenbly (After painting) 95 0 0 0 % of Scope Complete
51492 0 Shunting 10 0 0 0 % of Scope Complete
51492 0 Project Management 150 0 0 0 % of Scope Complete
51492 0 Rework due to incorrect drawing from Allan Wallace 1 0 0 0 % of Scope Complete
51491 0.5 Supervision 130 39 30 2 30 % of Scope Complete
51491 2 Bogie Assembly 16 8 50 4 50 % of Scope Complete
51491 80 Rework due to incorrect camber(NCR60) 120 12 10 800 10 % of Scope Complete
51491 170 Headstock fabrication 332 33 10 1700 10 % of Scope Complete
51491 210.25 Main beam fabrication 330 231 70 300 70 % of Scope Complete
51491 85 Main wagon assembly 450 112 25 340 25 % of Scope Complete
51491 61.5 Minor misc assembly 45 40 90 68 90 % of Scope Complete
51491 0 Airbrake & handbrake parts fabrication 130 0 0 0 % of Scope Complete
51491 0 Final assembly (after paint) 95 0 0 0 % of Scope Complete
51491 0 Wagon testing 80 0 0 0 % of Scope Complete
51491 0 Shunting 10 0 0 0 % of Scope Complete
51491 0 Project Management 150 0 0 0 % of Scope Complete
51491 0 Rework due to incorrect drawing from Allan Wallace 20 0 0 0 % of Scope Complete
60319 1 Fit/Remove steps & handrails 4 % of Scope Complete