How to plot a chart showing a job progress

PasLeChoix

New Member
Joined
May 26, 2017
Messages
1
My sheet is simple:

A1: data volumn, a big int like: 19981573933
B1: partition day, a small int like 365, every day has certain amount of data to be processed, total add up to A1

A2: starting date time (could be only time part, like 16:05)
B2: 0 (meaning at the starting point processed days is 0)
A3~Axx: various date time
B3~Bxx: correspondent completed days (up until 365)

I am looking for a chart showing:
X-Axis: time (from A column except A1)
Y-Axis: trend telling the progress

Chart type doesn't matter.

I need the chart can tell when the job will complete.

Bonus is the chart can tell the processing speed (how much data processed per hour).


Thank you very much.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Forum statistics

Threads
1,223,896
Messages
6,175,259
Members
452,626
Latest member
huntinghunter

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