Combination Charts in Excel to stack the data/Chart of Week 2 on top of Week 1

W

Winner

#1
Dear Covers,

Have you ever worked with Combination charts in Excel? I was wondering if any of you has worked on the kind of chart I am talking about.

Please have a look at the data and the Chart1 for Week1.

The question/ problem is: Is there a way to stack the data/Chart of Week 2 on top of Week1? I am talking about the Stacked column for charts such that you can see the weekly improvement in a factor over a month.

I can do it for 1 factor as shown in Chart 3 of the Excel file but not for 3 factors.

Any ideas, comments, suggestion?

Thanks a lot,

Harsh

P.S.- Please see the Excel file attached.
 

Attachments

Elsmar Forum Sponsor
L

little__cee

#2
Maybe...

IF I understand it, and that's a big IF on a Friday afternoon, couldn't you set up your data like so:

t1f1 2 3
t2f1 1 8
t3f1 4 5

week1 week2


Where t1f1 = Type1Factor1, t2f1=Type2Factor1, and etc.

Maybe that's too simple - sorry but I'm feeling the effects of massive doses of Sudafed, Throat Spray, Nasal Spray, and lots and lots of Vicks' VapoRub so its possible that I misunderstood your problem. Hope my solution helps you to get on the right track.
 

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#3
Would it help to use a combination bar and area chart? This is available among the custom chart selections.
 

Attachments

SteelMaiden

Super Moderator
Super Moderator
#4
little__cee said:
IF I understand it, and that's a big IF on a Friday afternoon, couldn't you set up your data like so:

t1f1 2 3
t2f1 1 8
t3f1 4 5

week1 week2


Where t1f1 = Type1Factor1, t2f1=Type2Factor1, and etc.

Maybe that's too simple - sorry but I'm feeling the effects of massive doses of Sudafed, Throat Spray, Nasal Spray, and lots and lots of Vicks' VapoRub so its possible that I misunderstood your problem. Hope my solution helps you to get on the right track.
That is what I get out of the question/example as well. Just below your factor 1 for types 1-3, you would input factor 2 for t1-3 and then factor 3 for t1-3, then everything is on the same chart.
 
W

Winner

#5
Thank you so much!!

SteelMaiden said:
That is what I get out of the question/example as well. Just below your factor 1 for types 1-3, you would input factor 2 for t1-3 and then factor 3 for t1-3, then everything is on the same chart.
Sometimes, hangover helps in concentration :)

I firstly thought that I got you all confused with the problem. So I changed all the factor and type names; paraphrased my question and was about to send the question to the forum again.

However, Steel Maiden's last lines struck me and I thought to myself that I didnt try that combination of data at all. And guess what, it worked!!!!!! Yay!! Thank you!

The reason Jennifer, I dont want to go for complex ( Area and other combination) charts is that- the charts are not meant for me :). Charts are either for the experts, i.e., people working on the machines or the decision makers i.e. Plant Managers/CEO and they will have a hard time understanding what the charts are trying to convey.

Before making any depictions, I talk to people in all departments and ask them what information do they want in what format. And then start making them.

I have uploaded the chart which I wanted , scroll to the very bottom. Its the chart in the end.

best,

Harsh
 

Attachments

Jen Kirley

Quality and Auditing Expert
Staff member
Admin
#6
Harsh, I didn't understand it as well as Steel Maiden did. I'm glad you got the right resolution to your problem!
 
Thread starter Similar threads Forum Replies Date
M Examples of Combination Products - MDR Article 1 (8) and MDR Article 1(9) Medical Device and FDA Regulations and Standards News 3
M Combination products - examples CE Marking (Conformité Européene) / CB Scheme 1
R Compatibility studies for Combination Products - Europe Medical Device and FDA Regulations and Standards News 2
R Compatibility studies - combination product CE Marking (Conformité Européene) / CB Scheme 4
N Is this a single integral drug device combination product EU MDR CE Marking (Conformité Européene) / CB Scheme 1
M Europe GMP medical devices - Combination products - Ancillary medicinal substance CE Marking (Conformité Européene) / CB Scheme 4
C Combination Products - Distributor of the device? EU Medical Device Regulations 7
M Differences in post market safety reporting for Combination Product Applicants Medical Device and FDA Regulations and Standards News 1
B Accessible parts per 8.4.2 b) - Touch currents in combination with MOOP or MOPP? IEC 60601 - Medical Electrical Equipment Safety Standards Series 3
M Informational US FDA Final guidance – Postmarketing Safety Reporting for Combination Products Medical Device and FDA Regulations and Standards News 0
M Informational EMA – Consultation on draft guideline on quality requirements for medical devices in combination products Medical Device and FDA Regulations and Standards News 0
K Release testing for Combination Drug-Medical Device Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
A UDI requirements for pre-filled combination devices - Box containing a pre-filled device US Food and Drug Administration (FDA) 2
S Definition of Convenience Kit for a Combination Product US Food and Drug Administration (FDA) 0
M FDA News USFDA draft guidance – Principles of Premarket Pathways for Combination Products; Draft Guidance for Industry; Availability Medical Device and FDA Regulations and Standards News 0
V Submission for a cross-labelled combination product 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 0
I Label Expiration Date - Single Use Combination Medical Device EU Medical Device Regulations 2
V For a Drug-Device Combination Product, 'Design Control' Process is triggered at? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
B Will FDA Inspect a New Coating Supplier for a Class III Combination Medical Device? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
M Shelf Life of Combination Sets for Class II Medical Devices ISO 13485:2016 - Medical Device Quality Management Systems 4
V Design Controls for Combination Drug Product Manufacturer (ANDA) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
F Development Meeting with the FDA - Approval Pathway for a Combination Product 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
V Upgrading Systems from CFR 211 to CFR 820 (drug+device combination) 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 7
B Article 12 Combination Device Registration With Competent Authority CE Marking (Conformité Européene) / CB Scheme 4
B Design history files for combination products 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
S Is Combination Product regulation available for Europe? EU Medical Device Regulations 2
B Combination Product South Africa CTD Other Medical Device Regulations World-Wide 1
S Any advice for my Pre Approval Inspection (PAI) for Combination product ? US Food and Drug Administration (FDA) 1
V Combination of software used as a single medical device ISO 13485:2016 - Medical Device Quality Management Systems 1
AnaMariaVR2 The Essential Guide to Combination Products cGMPs Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 0
S Contract Manufacturer - Product Identification for Combination medical device Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 8
Q CAPA - Combination of similar issues from different audits ISO 13485:2016 - Medical Device Quality Management Systems 3
B Best format for a combination ISO 9001/ISO 13485 Quality Manual? Quality Management System (QMS) Manuals 6
N Japan Combination Medical Device Product Regulations and Requirements Japan Medical Device Regulations 2
I What are examples of a Combination Product (Medical device and Pharmaceutical) ? ISO 13485:2016 - Medical Device Quality Management Systems 14
W FDA Preapproval Inspection - Submitting a 505b2 for a combination product to the FDA Other US Medical Device Regulations 5
Q Books that have a combination of ISO 13485 and FDA Title 21 CFR Part 820 ISO 13485:2016 - Medical Device Quality Management Systems 9
E Harms Severity Scoring - Combination of Hazards ISO 14971 - Medical Device Risk Management 4
A Establishment Registration Requirements - Combination Product 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
J ISO 22000, PAS 220 and HACCP Combination. Food Safety - ISO 22000, HACCP (21 CFR 120) 10
R Combination of Text and Flowchart based Procedures Document Control Systems, Procedures, Forms and Templates 18
I Analyte Specific Reagents (FDA requirements) for combination Antibodies US Food and Drug Administration (FDA) 7
F DIA (Drug Information Association) Conference on Combination Products EU Medical Device Regulations 1
F What Combination (Combined Advanced Therapy Product) Products are Approved in the EU? EU Medical Device Regulations 2
A Combination Product - Legacy Drugs and Reclassification 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 3
Michael Malis The FDA proposes to amend the combination product regulation 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 0
P Standard for Microbial Limits for a Combination Device - Impregnated Retraction Cord EU Medical Device Regulations 1
bio_subbu US FDA Proposed Rule for Combination Product Reporting US Food and Drug Administration (FDA) 1
B Format of Device Master Record (DMR) for Combination Products 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 1
I Device Class when used in combination with a device of a higher class? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 11

Similar threads

Top Bottom