SOLVED

adding batch data to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1870021%22%20slang%3D%22en-US%22%3Eadding%20batch%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870021%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20keep%20track%20of%20~10%20labs%20worth%20of%20media%20batches%2C%20and%20within%20that%2C%20around%2010-20%20different%20types%20of%20media.%20I'm%20already%20using%20excel%20to%20present%20our%20clinic%20success%20rates%2C%20and%20would%20like%20to%20present%20this%20data%20in%20the%20same%20file.%26nbsp%3B%3CBR%20%2F%3EWould%20someone%20please%20suggest%20the%20best%20way%20I%20could%20do%20this%3F%20originally%20i%20was%20thinking%20with%20an%20inserted%20calendar%2C%20but%20I%20think%20this%20might%20display%20too%20messily%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20s%20everyone%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1870021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1870446%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20batch%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1870446%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863406%22%20target%3D%22_blank%22%3E%40chytrid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20elaborate%20more%3F%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20is%20the%20type%20of%20data%20you%20are%20talking%20about%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1874877%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20batch%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1874877%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40Ramiz_Assaf%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESure!%20Thank%20you%20for%20your%20reply.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20for%20example%2C%20I%20have%20a%20single%20batch%20of%20media%20A%20with%20the%20lot%20number%205678%2C%20which%20I%20will%20start%20today.%20I%20also%20have%20media%20B%2C%20C%2C%20D%20and%20E%20with%20their%20own%20lot%20numbers%2C%20which%20I%20will%20start%20at%20some%20stage%20this%20week.%20Then%20there%20are%209%20other%20labs%2C%20also%20with%20the%20same%20*type*%20of%20media%2C%20and%20potentially%20the%20same%20lot%20numbers%2C%20but%20they%20might%20start%20their%20media%20on%20a%20different%20day%20to%20my%20lab.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20a)%20trace%20the%20use%20of%20a%20single%20lot%20number%2C%20ie%20when%20it%20was%20opened%20and%20when%20it%20was%20finished%2C%20and%20b)%20compare%20that%20against%20what%20media%20our%26nbsp%3B%20other%20labs%20were%20using%20at%20the%20same%20time.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20assumed%20it%20would%20easier%20to%20visualize%20this%20on%20a%20calendar-style%20display%2C%20but%20if%20you%20have%20any%20suggestions%20I%20would%20really%20appreciate%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETIA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1875702%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20batch%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1875702%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F863406%22%20target%3D%22_blank%22%3E%40chytrid%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20did%20something%20similar%20to%20a%20Gantt%20chart%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20find%20it%20attached%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1878637%22%20slang%3D%22en-US%22%3ERe%3A%20adding%20batch%20data%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1878637%22%20slang%3D%22en-US%22%3E%3CP%3EAh%20that%20is%20great!%20Thank%20you%20so%20much%20for%20your%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all, 

 

I need to keep track of ~10 labs worth of media batches, and within that, around 10-20 different types of media. I'm already using excel to present our clinic success rates, and would like to present this data in the same file. 
Would someone please suggest the best way I could do this? originally i was thinking with an inserted calendar, but I think this might display too messily?

 

Thank s everyone for the help!

7 Replies

@chytrid 

Can you elaborate more? 

What is the type of data you are talking about?

 

@Ramiz_Assaf 

 

Sure! Thank you for your reply. 

 

So for example, I have a single batch of media A with the lot number 5678, which I will start today. I also have media B, C, D and E with their own lot numbers, which I will start at some stage this week. Then there are 9 other labs, also with the same *type* of media, and potentially the same lot numbers, but they might start their media on a different day to my lab. 

 

I need to a) trace the use of a single lot number, ie when it was opened and when it was finished, and b) compare that against what media our  other labs were using at the same time. 

 

I assumed it would easier to visualize this on a calendar-style display, but if you have any suggestions I would really appreciate it.

 

TIA

Best Response confirmed by chytrid (Occasional Contributor)
Solution

@chytrid 

 

I did something similar to a Gantt chart 

please find it attached

Ah that is great! Thank you so much for your help!

@Ramiz_Assaf I've tried to replicate your work and I can't quite get it looking the same. I've very obviously missing something.  Can you please advise how  you plot your data without it starting on the vertical axis? If that makes sense... 

 

Thank you so much for your help

@chytrid 

You only need to select the blue series. then right click and change fill color to "no fill". see the pic

it is a cool trick, right?

 

have a wonderful day

ahhh thank you!