Forum Discussion

Copper Contributor

Nov 09, 2020

Solved

adding batch data to excel

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 li...

excel

Ramiz_Assaf
Nov 11, 2020
chytrid

I did something similar to a Gantt chart
please find it attached

chytrid

Copper Contributor

Nov 10, 2020

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

Ramiz_Assaf

Iron Contributor

Nov 11, 2020

chytrid

I did something similar to a Gantt chart

please find it attached

chytrid
Copper Contributor
Nov 12, 2020
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
media stuff.xlsx25 KB
- Ramiz_Assaf
  Iron Contributor
  Nov 12, 2020
  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
  - chytrid
    Copper Contributor
    Nov 16, 2020
    ahhh thank you!
chytrid
Copper Contributor
Nov 11, 2020
Ah that is great! Thank you so much for your help!