---
title: "Status Reports: Reduce Your Cycle Time using Minitab Macros!"
description: "Status Reports: Reduce Your Cycle Time using Minitab Macros!"
image: https://blog.minitab.com/hubfs/B2BML%20-%20NEW%20FILE%20MANAGER%20STRUCTURE/Blog%20Images/Imported_Blog_Media/quality_w640-Jul-06-2025-12-58-08-5514-AM.png
---
English
- [English](https://blog.minitab.com/en/?hsLang=en)
- [Français](https://blog.minitab.com/fr/?hsLang=en)
- [Deutsch](https://blog.minitab.com/de/?hsLang=en)
- [Português](https://blog.minitab.com/pt/?hsLang=en)
- [Español](https://blog.minitab.com/es/?hsLang=en)
- [日本語](https://blog.minitab.com/ja/?hsLang=en)
- [한국어](https://blog.minitab.com/ko/?hsLang=en)
- [中文（简体）](https://blog.minitab.com/zh/?hsLang=en)
- [ Partners](https://www.minitab.com/en-us/company/partners/)
- [ Contact](https://www.minitab.com/en-us/company/contact-us/)
- [ Talk to Minitab](https://www.minitab.com/en-us/talk-to-minitab/)
- [ My Account](https://licensing.minitab.com/account/manage)
[](https://www.minitab.com/en-us/)
- Products
Back
[Products](https://www.minitab.com/en-us/products/)
[All Products](https://www.minitab.com/en-us/products/)
- [Minitab Solution Center](https://www.minitab.com/en-us/products/minitab-solution-center/)
- [Minitab Statistical Software](https://www.minitab.com/en-us/products/minitab/)
- [Minitab Connect](https://www.minitab.com/en-us/products/connect/)
- [Minitab Model Ops](https://www.minitab.com/en-us/products/model-ops/)
- [Minitab Education Hub](https://www.minitab.com/en-us/products/education-hub/)
- [Minitab Engage](https://www.minitab.com/en-us/products/engage/)
- [Minitab Workspace](https://www.minitab.com/en-us/products/workspace/)
- [Real-Time SPC](https://www.minitab.com/en-us/products/real-time-spc/)
- [Prolink Data Collection & SPC](https://www.minitab.com/en-us/products/prolink)
- [Simul8 Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [SPM](https://www.minitab.com/en-us/products/spm/)
- Solutions
Back
[Solutions](https://www.minitab.com/en-us/solutions/)
[All Solutions](https://www.minitab.com/en-us/solutions/)
- [Analytics](https://www.minitab.com/en-us/solutions/analytics/)
- [Statistics & Predictive Analytics](https://www.minitab.com/en-us/solutions/analytics/statistical-analysis-predictive-analytics/)
- [Data Science & Machine Learning](https://www.minitab.com/en-us/solutions/analytics/data-science-machine-learning/)
- [Business Analytics & Intelligence](https://www.minitab.com/en-us/solutions/analytics/business-analytics-intelligence/)
- [Statistical Process Control](https://www.minitab.com/en-us/solutions/analytics/statistical-process-control/)
- [Quality Analytics](https://www.minitab.com/en-us/solutions/analytics/quality-analytics/)
- [Live Analytics](https://www.minitab.com/en-us/solutions/analytics/live-analytics/)
- [Reliability & Life Data Analysis](https://www.minitab.com/en-us/solutions/analytics/reliability/)
- [Discrete Event Simulation](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Process Mining](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Key Capabilities](https://www.minitab.com/en-us/solutions/key-capabilities/)
- [Continuous Improvement](https://www.minitab.com/en-us/solutions/key-capabilities/continuous-improvement/)
- [Data Integration & Data Prep](https://www.minitab.com/en-us/solutions/key-capabilities/data-integration-data-prep/)
- [Diagramming & Mind Mapping](https://www.minitab.com/en-us/solutions/key-capabilities/diagramming-mind-mapping/)
- [Digital Twins](https://info.minitab.com/en/new-to-simul8?hsLang=en)
- [Model Deployment & ML Ops](https://www.minitab.com/en-us/solutions/key-capabilities/model-deployment-ml-ops/)
- [Innovation & Project Management](https://www.minitab.com/en-us/solutions/key-capabilities/innovation-project-management/)
- [Process Excellence: Detect, Correct & Prevent](https://www.minitab.com/en-us/solutions/key-capabilities/process-excellence/)
- [Featured Industries](https://www.minitab.com/en-us/solutions/industry/)
- [Academic](https://www.minitab.com/en-us/solutions/industry/academic/)
- [Energy & Natural Resources](https://www.minitab.com/en-us/solutions/industry/energy-resources/)
- [Government & Public Sector](https://www.minitab.com/en-us/solutions/industry/government/)
- [Healthcare](https://www.minitab.com/en-us/solutions/industry/healthcare/)
- [Insurance](https://www.minitab.com/en-us/solutions/industry/insurance/)
- [Manufacturing & Industrial](https://www.minitab.com/en-us/solutions/industry/manufacturing-industrial/)
- [Services](https://www.minitab.com/en-us/solutions/industry/service-industries/)
- [Software & Technology](https://www.minitab.com/en-us/solutions/industry/software-technology/)
- [Construction](https://www.minitab.com/en-us/solutions/industry/construction/)
- [Featured Roles](https://www.minitab.com/en-us/solutions/role/)
- [Engineering](https://www.minitab.com/en-us/solutions/role/engineering/)
- [Business Analysis](https://www.minitab.com/en-us/solutions/role/business-analysts/)
- [Information Technology](https://www.minitab.com/en-us/solutions/role/information-technology/)
- [Supply Chain](https://www.minitab.com/en-us/solutions/role/supply-chain/)
- [Customer Service & Contact Center](https://www.minitab.com/en-us/solutions/role/customer-service-contact-center/)
- [Human Resources](https://www.minitab.com/en-us/solutions/role/human-resources/)
- [Marketing](https://www.minitab.com/en-us/solutions/role/marketing/)
- [Research and Development](https://www.minitab.com/en-us/solutions/role/research-and-development/)
- Resources & Services
Back
[Resources & Services](https://www.minitab.com/en-us/resources-services/)
[All Resources & Services](https://www.minitab.com/en-us/resources-services/)
- [Resources](https://www.minitab.com/en-us/resources-services/resources/)
- [Case Studies](https://www.minitab.com/en-us/resources-services/resources/case-studies/)
- [eBooks & White Papers](https://www.minitab.com/en-us/resources-services/resources/ebooks-and-white-papers/)
- [Blog](https://blog.minitab.com/blog/?hsLang=en)
- [Data Sets](https://www.minitab.com/en-us/resources-services/resources/data-set/)
- [Webinars & Events](https://www.minitab.com/en-us/resources-services/resources/events/)
- [Education Hub](https://www.minitab.com/en-us/resources-services/resources/education-hub/)
- [Services](https://www.minitab.com/en-us/resources-services/services/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Deployment](https://www.minitab.com/en-us/resources-services/services/deployment/)
- [Consulting](https://www.minitab.com/en-us/resources-services/services/statistical-consulting/)
- [Self-Paced Learning](https://www.minitab.com/en-us/resources-services/services/self-paced-learning/)
- [Continuing Education](https://www.minitab.com/en-us/resources-services/services/continuing-education/)
- Support
Back
[Support](https://www.minitab.com/en-us/support/)
[Technical Support](https://www.minitab.com/en-us/support/)
- [Subscriptions & Activation](https://www.minitab.com/en-us/support/subscriptions-and-activation/)
- [Minitab Quick Start](https://www.minitab.com/en-us/support/quick-start/)
- [Training](https://www.minitab.com/en-us/resources-services/services/training/)
- [Installation Support](https://www.minitab.com/en-us/support/installation/)
- [Support Videos](https://www.minitab.com/en-us/support/videos/)
- [Support Documentation](https://www.minitab.com/en-us/support/documents/)
- [Software Updates](https://www.minitab.com/en-us/support/software-updates/)
- [Product Downloads](https://www.minitab.com/en-us/support/downloads/)
- [Support Policy](https://www.minitab.com/en-us/support/policy/)
- Company
Back
[Company](https://www.minitab.com/en-us/company/)
[Company](https://www.minitab.com/en-us/company/)
- [About Us](https://www.minitab.com/en-us/company/our-company/)
- [Leadership Team](https://www.minitab.com/en-us/company/leadership-team/)
- [Partners](https://www.minitab.com/en-us/company/partners/)
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Contact](https://www.minitab.com/en-us/company/contact-us/)
- [News](https://www.minitab.com/en-us/company/press-releases/)
[Try/Buy](https://www.minitab.com/en-us/try-buy/)
- [Statistics](https://blog.minitab.com/en/blog/tag/statistics)
- [Data Analysis](https://blog.minitab.com/en/blog/tag/data-analysis)
-
- [Quality Improvement](https://blog.minitab.com/en/blog/tag/quality-improvement)
- [Subscribe](https://info.minitab.com/blog/subscribe?hsLang=en)
## Notice
You are now leaving minitab.com.
Click Continue to proceed to:
Continue
Go Back
# Status Reports: Reduce Your Cycle Time using Minitab Macros!
[Steve Orlich](https://blog.minitab.com/en/blog/author/steve-orlich) | 4/10/2013
Topics: [Healthcare](https://blog.minitab.com/en/blog/tag/healthcare), [Six Sigma](https://blog.minitab.com/en/blog/tag/six-sigma), [Project Tools](https://blog.minitab.com/en/blog/tag/project-tools), [Lean Six Sigma](https://blog.minitab.com/en/blog/tag/lean-six-sigma)
- [Share](https://www.linkedin.com/shareArticle?mini=true&url=https://blog.minitab.com/en/blog/making-statistical-software-easier/status-reports-reduce-your-cycle-time-using-minitab-macros)
- [Share](https://www.facebook.com/sharer.php?u=https://blog.minitab.com/en/blog/making-statistical-software-easier/status-reports-reduce-your-cycle-time-using-minitab-macros)
Across all industries, there are many different ways professionals utilize [Minitab Statistical Software](http://www.minitab.com/products/minitab/) to improve the quality of their products and services.
You may be a professional in the health care industry who is interested in monitoring the days between hospital-acquired infections (HAIs) using rare event charts. You may be a professional in manufacturing who is using a [Pareto chart](https://blog.minitab.com/blog/understanding-statistics/explaining-quality-statistics-so-your-boss-will-understand-pareto-charts?hsLang=en) to evaluate the types of defects you are discovering during the inspection process. Or you may be a product manager like me who uses Minitab analytics to evaluate customer [survey data](http://www.minitab.com/en-us/Published-Articles/Analyzing-Survey-Data-with-Minitab--Frequency-Distributions,-Cross-Tabulation-and-Hypothesis-Testing/).
But no matter the different applications, we all share a common thread.
## Status Reports
Many of us present reports to management and stakeholders at regular time intervals using Microsoft Word or PowerPoint. These reports communicate actionable information, supported with Minitab graphs and analysis.
We take pride in our reports. We want to impress our audience. It's our voice. So I guess it's no surprise that they can take quite a bit of time to prepare.
When we do prepare them, we want to maximize our time spent on the actual content while trying to minimize time spent on all of the non-value added activities.
We want to reduce our status report cycle time.
## Status Reports: The Old Way
One step that can be somewhat laborious is updating our Minitab graphs in the status report.
We all know the drill. Every couple of weeks we create the same set of graphs and then manually copy and replace those same graphs into our latest status report.
And then, right when we are ready to send the report late on a Friday afternoon...the data change and we have to do it again! Yes, it happened to me once and I was consequently late with the family pizza—but that's a separate post altogether.
Bruno Scibilia wrote a great [blog](https://blog.minitab.com/blog/applying-statistics-in-quality-projects/using-macros-to-publish-statistical-reports?hsLang=en) post on how to use Minitab macros to publish reports. Now let's also learn how to use Minitab macros and Microsoft Word together to automatically update our reports.
## Status Reports: The New Way
*“I’m a Quality Engineer at a manufacturing plant and I inspect our product daily looking for defects. If the product does have a defect, I record the type of defect in Microsoft Excel. Every two weeks, I run my executable in Minitab that imports the data from Excel and creates a Pareto chart. I then copy and paste the graphs into a report template for management.”*
The engineer’s Minitab executable may look something like this:
Now, let’s add three additional subcommands to the Pareto chart command:
These subcommands instruct the executable to save the Pareto chart to a file location as a JPEG file and to automatically replace the current Pareto chart, if one exists. That's it from the Minitab side!
Now let’s set up the link to the Pareto chart in Microsoft Word. Within Microsoft Word, first click in the document where you'd like to display the Pareto Chart, go to the Insert tab, and select "Picture" from the Illustrations group:
Once we click the Picture icon, we are brought to a dialog where we can navigate to where our Pareto Chart was saved. Importantly, I will also select “Insert and Link” from the Insert drop down menu:
We are now finished. Microsoft Word is now connected to the source file, in this case, a Pareto chart. Every time we run the executable in Minitab, a new Pareto chart is created and saved. When we open our status report, we will see the most up-to-date Minitab graph! If you have more than one graph, just follow the above steps for all your graphs. Awesome!
And I'm happy to report there have been no more late pizzas for the family on Friday nights.
## You Might Also Like
[Inside the 2025 IHI Forum: What Healthcare Leaders Are Saying About AI](https://blog.minitab.com/en/blog/ihi-forum-healthcare-and-ai?hsLang=en)
[Minitab Ai](https://blog.minitab.com/en/blog/tag/minitab-ai) | 5 Minute Read
[Go See the Work: The Power of a Gemba Walk](https://blog.minitab.com/en/blog/gemba-walk-tools?hsLang=en)
[Lean Six Sigma](https://blog.minitab.com/en/blog/tag/lean-six-sigma) | 2 Minute Read
[Five Approaches to Enhance Patient Safety](https://blog.minitab.com/en/blog/five-approaches-to-enhance-patient-safety?hsLang=en)
[Operations](https://blog.minitab.com/en/blog/tag/operations) | 5 Minute Read
---
- [Careers](https://www.minitab.com/en-us/company/careers/)
- [Trust Center](https://www.minitab.com/en-us/trust-center/)
- [Suppliers](https://www.minitab.com/en-us/suppliers/)
- [Site Map](https://www.minitab.com/en-us/site-map/)
- [](https://www.linkedin.com/company/minitab/)
- [](https://www.facebook.com/Minitab/)
- [](https://www.youtube.com/user/MinitabInc)
- [](https://www.instagram.com/minitab/)
---
© 2025 Minitab, LLC. All Rights Reserved.
- [Terms of Use](https://www.minitab.com/en-us/legal/terms-of-use/)
- [Privacy Policy](https://www.minitab.com/en-us/legal/privacy-policy/)
- [Legal](https://www.minitab.com/en-us/legal/)
- Cookies Settings