Controlling Data Labels on Graphs - Number of Decimal Places Reported - Minitab

M

My_name_is_Ben

#1
Hello,

Can someone tell me if it is possible to limit the number of decimal places reported in the data lables displayed on a graph. The default seems to be 6 significant figures, but that takes up so much space it becomes unreadable. 3 would be better.

thanks
Ben
 
Elsmar Forum Sponsor

Bev D

Heretical Statistician
Staff member
Super Moderator
#2
Re: Controlling data labels on graphs

I'm sure a minitab expert will come along shortly for a specific answer for you.
(I'm a JMP/EXCEL user)

let me ask a very different question that might resolve your issue tho: WHY do you need to have data labels on a graphical display of the data? What value does it add to the analysis?

Graphs are for relative comparisons. Data tables are for those who must look at the exact numerical value.
 
M

My_name_is_Ben

#3
I have to present data in a very concise form. Presenting the graph is all I have space for, but I _must_ have the mean available to view somehow. Typically I use box plots with individual data points shown because the number of data points is small. That allows people to compare whether one data set was more tightly distributed than another, whilst simultaneously showing (for those who can be bothered to look) whether there were multiple outliers that are artificially skewing the mean.

The way I use statistics is impure. I am sure that many people would have a problem with the way that I treat outliers, and I am sure many people are wondering why I combine a box plot and an individual data plot. If the data isn't good enough to build a reasonable box plot then don't plot one, right? However, you have to speak the same language as your audience, and if they won't buy into your conclusions unless you show them a box plot then you have to show them a box plot.

thanks for your thoughts
Ben
 

Bev D

Heretical Statistician
Staff member
Super Moderator
#4
I think your statistics are pretty pure: there is nothing like plotting all of the data so you and your audience can see the variation instead of having to envision it by doing math in their head form the average and standard deviation.
 

Miner

Forum Moderator
Staff member
Admin
#5
Minitab handles this in a rather awkward fashion. Here are the steps:

  1. Go to the worksheet and right click on the column containing the data used in the chart
  2. Select Format Column
  3. Select Numeric
  4. Select Fixed Decimal
  5. Enter 3
  6. Select Okay
If your chart does not automatically update, right click on the chart and select Update or Update Automatically.

Note Minitab keeps your data out to the original number of decimal places. This just changes the number of digits displayed.
 
M

My_name_is_Ben

#6
Hi Miner,

Thanks for the tip. I was having mixed success until I realised the critical step - that you need to select "Use labels from column" instead of "use y-value labels". Using the latter option leaves the labels with the same number of significant figures as the underlying data. Using the former option gives data labels formatted to the same number of decimal places that the column is formatted with.

I would have never got here without your help. thanks

Ben
 
A

Allattar

#8
A rather less automatic way of doing it is to edit each label individually, and cut the decimals down in size.

Not optimum but possible.
 
Thread starter Similar threads Forum Replies Date
R Procedure for Controlling Transmitted Technical Data - ITAR compliance Document Control Systems, Procedures, Forms and Templates 18
Marc Controlling Electronic Data Sheets from Manufacturers, Articles and Such Like Document Control Systems, Procedures, Forms and Templates 0
Q Controlling Data Sheets Document Control Systems, Procedures, Forms and Templates 2
D Controlling software and Data - Control of Information maintained in computers Quality Assurance and Compliance Software Tools and Solutions 4
R Controlling Quick Reaction Checklists Document Control Systems, Procedures, Forms and Templates 1
C Identifying and Controlling External Documents Document Control Systems, Procedures, Forms and Templates 3
qualprod Controlling documents in two different Applications ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 10
M AS9100d Controlling External Provided Processes (purchasing 8.4) - The customer want us to use supplier X AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
qualprod Minor non-conformance for not controlling local regulation laws? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 20
Q Controlling Multi-Tab Microsoft Excel Forms Excel .xls Spreadsheet Templates and Tools 5
C Controlling Software Versions that are part of a medical device IEC 62304 - Medical Device Software Life Cycle Processes 2
A ISO 13485 - Controlling Production and Service Provision - Product Catalogues ISO 13485:2016 - Medical Device Quality Management Systems 3
M Difficulties Controlling Foreign Suppliers Supplier Quality Assurance and other Supplier Issues 8
R OHSAS 18001:2007 Section 3 - Controlling Work Place Risks Occupational Health & Safety Management Standards 3
T Controlling an Excel Spreadsheet (Database) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 3
C ISO 9001:2008 4.2.3(f) - Controlling Documents of External Origin Quality Manager and Management Related Issues 9
M Controlling Flow Charts that are hung in workplace. Quality Manager and Management Related Issues 6
N Controlling Records query that may cause some serious trouble for me ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
T Controlling Manual - Control of 10 Printed Manuals throughout our 9 Branches Document Control Systems, Procedures, Forms and Templates 8
Fender1 Controlling Documents and Records in a Custom Weld/Fabrication Company Document Control Systems, Procedures, Forms and Templates 10
C Tool Monitoring - Controlling a Process with Better Tool Monitoring Manufacturing and Related Processes 4
C Controlling QMS - We are expanding globally and want to keep our QMS Confidential Quality Manager and Management Related Issues 20
C Controlling Documents: Beyond the standard, how do we truly define what to control ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 9
R Referencing and Controlling Labels & Stickers used internally throughout Production Document Control Systems, Procedures, Forms and Templates 1
Q Controlling Prints in Shop - Audit Finding Question ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 4
L Controlling "Stamps" used throughout our processing Records and Data - Quality, Legal and Other Evidence 16
T Requirements - Controlling and Maintaining Sheet Metal Templates for Production Use ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
P Controlling Solidworks model, CAD & Gerber files Document Control Systems, Procedures, Forms and Templates 3
M Defining and Controlling External Documents (Documents of External Origin) Quality Tools, Improvement and Analysis 5
M Controlling Temperature and Time - Do I need to calibrate the thermostat? IATF 16949 - Automotive Quality Systems Standard 4
S Controlling Documentation - Which procedures to control Document Control Systems, Procedures, Forms and Templates 12
C HACCP in Egg Production - Controlling hazards at the farm level Food Safety - ISO 22000, HACCP (21 CFR 120) 6
I Controlling Minitab by vba (visual basic) or vb Using Minitab Software 6
T Procedure for "Controlling Nonconformity" for a software company Document Control Systems, Procedures, Forms and Templates 2
R Controlling and monitoring of measuring devices - AS9100 General Measurement Device and Calibration Topics 3
D Establishing and controlling process capability - Meaning of Phrases Capability, Accuracy and Stability - Processes, Machines, etc. 2
E Controlling CNC Machine Programs - Your recommendations appreciated Manufacturing and Related Processes 12
T Controlling filled out "forms" (eg Operator job specific work instructions) Document Control Systems, Procedures, Forms and Templates 3
B Controlling Reference Material Document Control Systems, Procedures, Forms and Templates 1
J Controlling Temperature and Humidity in the CMM Room and does anyone use Artifacts? Inspection, Prints (Drawings), Testing, Sampling and Related Topics 8
S Identifying and Controlling External Documents Document Control Systems, Procedures, Forms and Templates 8
Raffy Controlling Handler, Tester, Computer and other Equipment Manuals. Document Control Systems, Procedures, Forms and Templates 2
H Controlling Continuously Changing Forms IATF 16949 - Automotive Quality Systems Standard 12
W Controlling Revisions of External Documents - Documents of External Origin Document Control Systems, Procedures, Forms and Templates 10
A Controlling Humidity in a Textile Testing Laboratory General Measurement Device and Calibration Topics 10
M Polyurethane Foam Testing and Controlling the Foaming Process Manufacturing and Related Processes 6
G Controlling a male 6% Luer with permanent collar according to EN1707? General Measurement Device and Calibration Topics 5
C Controlling External Customer Documents (Documents of External Origin) Document Control Systems, Procedures, Forms and Templates 5
L "Document Controlling" Queries run to obtain information reported to customer Document Control Systems, Procedures, Forms and Templates 7
A Still Confused About "Controlling Suppliers Records" AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3

Similar threads

Top Bottom