Help Require for creating Runrate Chart

[Naveen Athaley]

Hello,

I am trying to find out the best chart to show runrates.It goes like below:

Total Volume=1000 Profiles to be completed by 31 dec 2016
Completed till now = 300
Current RR = 3.8 profiles/ day (start date 1 August 2016)

Require Runrate = 9.45
if we continues with Current Runrate we will achieve only 284 profiles.

I need help in showing all the above data points in chart.

Thanks
Naveen

POST MOVED TO CORRECT SECTION BY MODERATOR

.

 

[vletm]

... and Your Sample File will upload soon?

 

[Naveen Athaley]

Hi,
I don't have any sample file, case is described above.

Thanks

 

[vletm]

As in Tip: Upload a Sample File to get a quicker response
We can read Your #1 reply ...
I can close my eyes and I try to figure it ...
but ... can You see it just now? now there could be 285 profiles ...
If You know what You really would like to get,
that needs a Sample file with those #1 informations.

 

[Naveen Athaley]

Here You go,

Thanks for help

 

[bobhc]

Vietm has give you a tip I will give you another, probably receive more help if you took the trouble to post in correct forum section.

 

[vletm]

WOW! I opened my eyes and ...
I tried to find out those information from #1 ...
Okay, I noticed words like 'Current', 'Runrate', 'Total' & 'Profiles'.
Maybe I have to close my eyes again and
try to figure what would be the best chart to show 'runrates'
(fixed values 18,9 & 36,8)...
Have You tried to reread Your written #1?
Do You really know what would be Your clear idea of that?
Could You share that idea?

​

 

[Naveen Athaley]

Hello,

So basically I would like to see a chart which tells that till date we have completed X profiles and with the CRR we will complete Y profiles, however we need to complete Z profiles by MM-DD-YY date.

Some kind of line chart which can show above scenerio

 

[vletm]

Sample data below

>>>
I would like to see a chart which tells that till date we have completed X profiles and with the CRR we will complete Y profiles, however we need to complete Z profiles by MM-DD-YY date.
There are some challenges if You would notice,
or how to figure any dates ... and so?

 

[Naveen Athaley]

Sample data below
View attachment 35506
>>>
I would like to see a chart which tells that till date we have completed X profiles and with the CRR we will complete Y profiles, however we need to complete Z profiles by MM-DD-YY date.
There are some challenges if You would notice,
or how to figure any dates ... and so?

Lets say start date is 1 July 2016 and end date is 30 Nov 2016, we can always assume data if not given

 

[vletm]

Okay, I'll try still...
Please reread You writings and close Your eyes.
Try to figure what kind of RunChart You would like to see.
After few minutes Open Your eyes and make any kind of visual image of that ... draw however ... with all Your needed values and upload it here.
If You don't have more clear image of Your needs
then it would be challenge to do just something You would like to get.