Flow Charts in Excel - 'autoshape' and add text commands

L

Laura M

#1
Flow charts in Excel

I've been using Excel for flow charts. Today, something happened that I can't explain.

I used the 'autoshape' and add text commands. Print preview was not an exact representation of what I had on the screen. In a couple places, it moved a word to the previous line. I first noticed it on the pdf file I created because the pdf file cut off the end of the word.

I've used excel and pdf before. I'm betting there is a default option somewhere that I didn't know about. It's one of those head bangers that I've had enough of for one day so I'm looking for a Cover to bale me out!! HELP unlock brain block!!

Laura
 
Elsmar Forum Sponsor
T

tomvehoski

#2
I often used the autoshape commands in powerpoint (same as excel's) for flowcharts. I would always paste them into my Word documents. I would often find that things would move slightly from the copy in PP to the paste in word. If I resized the offending shape or line slightly, it would be OK. Sometimes just a second copy/past cycle would take care of it without any edits. I also would always paste as a picture, since pasting as a drawing object would leave individual objects that were a mess to move or resize.

My guess is that Autoshapes is not an advanced flowchart package and is full of bugs. I don't seem to have the same problems with Visio, but of course that has its own set of problems. I wish I had stuck with autoshapes since several of my clients don't have visio and there is no way to convert the drawings.

Tom
 
M

M Greenaway

#3
Tom

I also use Visio, and would recommend to Laura that she has a go with this very useful software.

As for sharing Visio diagrams with non-Visio users, you can import them as objects into a MS Word document, or you can save them as HTML files which everyone can access through their web browser software.
 
R

RosieA

#4
Hi Laura,
I've had the same problem with flow charts in Word. I couldn't figure it out, so I finally gave the file to our graphic designer who captured it as a .jpg file, and that worked.

I hope someone in the Cove knows the answer to this, because it's an annoying problem.
 
T

tomvehoski

#5
My main issue with visio is that my clients need to update the files after I am long gone (or call me with "can you add this box to the flowchart"). I hate telling people they have to go spend $250+ for software to maintain 10 flowcharts. I like the software, but it is overkill for some applications.

I have tried the HTML conversion and some others. You either lose individual objects, or objects/lines/text become disconnected individual objects. You would think Microsoft would make it more compatible with their office products.
 
L

Laura M

#6
Thanks for all the comments. Maybe I'm NOT losing my mind? What I don't get is that the flow chart I was working on is fairly simple. I did several complex ones, and didn't have this problem. I wonder if it is an XP problem, as the other charts were in '97.

I haven't tried PPT, because excel and word have all the symbols I need in the drawing toolbar. One thing I did notice (with XP?) is that it wants to open a picture instead of just placing the graphic on the page. Is that part of the problem? I don't think like a computer, so when it tries to distinguish between a text box or a picture, I usually go with the flow until I get it to look right. But this business of having the text reformat itself for printing, or the print preview is really confusing.:rolleyes: :frust:

I'll try a few more things tonite. Thanks again for the input everyone. If I learn anything else, I'll let you know.
 
J

James Gutherson

#7
Hi Laura, I think tomvehoski is right when he says some times a small change in size will correct these problems. This drawing part of Excel (and Word and Powerpoint) is a Vector type of diagraming program as opposed to a Raster style program like Paint. It (AutoShape) uses a series commands something like (very simplified) "Draw a Rectangle 'X' pixels long by 'Y' pixels high at 'A' pixels right from the top left of the window, and 'B' pixels down. Call this shape "Shape". Add text 'Text" in 'Q' font starting a 'C' pixels along from the top left corner of 'Shape'. If width of 'Text' exceeds width of 'Shape'; then start new line."

The problem occurs when the printer has a slightly diffent resolution of a pixel, and of a font to the screen, (and they all do) you can get in some circumstances a different word wrapping in the printed document to the screen. The screen can fit the word in the space given for the shape, but the printer can't so it wraps it (the text).

Essentially, what Acrobat is doing is making a Vector image of the Document using a printers definition of the image, so that what you see on the screen is what is printed, but this word wrapping problem can occur again.

Anyway to fix it, you might be able to change the size once, save it and correct it back again, in case it is a bug. If this doesn't work, it is probably one of those word wrap configurations, so you need to change something, maybe a change of the shape by one pixel (smaller of larger) will be enough to make the two images (printer and screen) line up.

Visio is a much more advanced program, designed to do this type of work with these type of situations allowed for - rather than a quick and dirty solution like Auto shapes - you gets what you pays for. Saying that, I tend to use Auto shapes as well, just be aware of the formating limitations.
 
L

Laura M

#9
I'll save my $25 for the 'cause.' Thanks for all the help.

(I hope this isn't a repeat post - I thought I submitted something similar, but didn't see it show up.)


I've used Visio - but only when the client already had it. I was self taught, but they still had no one to take it over when I left. I prefer the Word/Excel variety if they are simply flow charts.

Thanks for all the help in solving this problem
 
Thread starter Similar threads Forum Replies Date
A IATF 16949 Cl. 8.3.5.2 e) - Manufacturing Process Flow Charts & Layout IATF 16949 - Automotive Quality Systems Standard 5
R Irradiation Sterilization Dose Setting and Dose Audit Flow Charts ISO 13485:2016 - Medical Device Quality Management Systems 0
M Controlling Flow Charts that are hung in workplace. Quality Manager and Management Related Issues 6
G When are Flow Charts necessary or required? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 6
R "Control" as used in 4.1 c) - Process Flow Charts (Process Sequence Chart) ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 12
T Does FDA consider Flow Charts sufficient instruction for SOPs? 21 CFR Part 820 - US FDA Quality System Regulations (QSR) 2
R Work Instructions versus Process Flow Charts ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 8
N Supplier Process Change Request Procedures, Forms and Flow Charts Document Control Systems, Procedures, Forms and Templates 3
D Advised by external auditor to change all QMS?s procedures to Flow charts Document Control Systems, Procedures, Forms and Templates 16
B Do I need Flow Charts in TS16949? IATF 16949 - Automotive Quality Systems Standard 5
J Flow charts - Seeking Examples Document Control Systems, Procedures, Forms and Templates 9
M Linking Process Flow Charts, FMEAS and Control Plans for TS 16949 FMEA and Control Plans 4
G Does The FDA oppose the use of Process Flow Charts? ISO 13485:2016 - Medical Device Quality Management Systems 8
Marc Flow charts - Show Me Yours! Systems Approach - Process Mapping Process Maps, Process Mapping and Turtle Diagrams 28
L Describing the Process - ISO9001:2000 - Flow charts? Other documents? Document Control Systems, Procedures, Forms and Templates 14
V Seeking Complaint Management flow charts or other info Document Control Systems, Procedures, Forms and Templates 1
N Document Formats: Text Procedures vs. Flow Charts (Process Maps) Document Control Systems, Procedures, Forms and Templates 42
Marc Visio vs. Smartdraw - Best software for flow charts on an intranet Quality Assurance and Compliance Software Tools and Solutions 3
Marc Are Flow Charts REQUIRED by ISO 9001:2000? ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 20
M Text or Flow Charts? Mixing flow charts and text in procedures QS-9000 - American Automotive Manufacturers Standard 4
G Document Format - Flow Charts vs. Strictly Linear Text for Procedures Document Control Systems, Procedures, Forms and Templates 4
M Risk Analysis Flow - Confusion between ISO 14971 and IEC 62304 IEC 62304 - Medical Device Software Life Cycle Processes 8
B FAR/Prime Contractor Flow-down Tool - AS9100 AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 3
D Calibration Process Flow Map Example Wanted General Measurement Device and Calibration Topics 3
G New CAPA Work Flow with Revised 8D Approach Process Maps, Process Mapping and Turtle Diagrams 35
M Proper method to test flow of a regulator Inspection, Prints (Drawings), Testing, Sampling and Related Topics 1
Q AS9120B flow down to external providers: Records Retention AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
qualprod What is the Normal Flow in an ERP for Manufacturing? Manufacturing and Related Processes 0
D Virtual Documentation via Master Flow Chart? Process Maps, Process Mapping and Turtle Diagrams 4
eule del ayre Merging FMEA and Quality Control Process Flow FMEA and Control Plans 0
A Redesigning our process flow chart, PFMEA and Control Plan Process Maps, Process Mapping and Turtle Diagrams 4
K Vigilance process flow chart EU Medical Device Regulations 1
Ronen E Tolerance intervals (?) question - Flow Rate Probability Range Statistical Analysis Tools, Techniques and SPC 6
8 Creating Flow and Pull Game Lean in Manufacturing and Service Industries 1
S Improving Quality inspection gate in one piece flow manufacturing process Manufacturing and Related Processes 0
D Link between FMEA, flow chart and control plan FMEA and Control Plans 10
M What are the differences between "Process Flowchart form" and "Process Flow Diagram form"? IATF 16949 - Automotive Quality Systems Standard 4
O Air Flow - Which is the operational difference between LAF (vertical and horizontal) and RLAF? Manufacturing and Related Processes 2
A Tubing Clog Tester - Convert from Air Bubble to Flow Rate Reliability Analysis - Predictions, Testing and Standards 1
A How a test flow can be build for a car electronic sunroof control Reliability Analysis - Predictions, Testing and Standards 6
R Cascading (Flow Down) Customer Specific Requirements IATF 16949 - Automotive Quality Systems Standard 2
N Process Flow diagram steps for inspection and packaging APQP and PPAP 4
B AS9102 Supplier Flow Down Method AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 7
N Dataset for Academic Research - Infusion pump flow IEC 60601 - Medical Electrical Equipment Safety Standards Series 1
J ITAR flow down to Processors (Outsourced Processes) AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 1
G In-House Calibration of Gas Flow Meters General Measurement Device and Calibration Topics 6
M ISO 9001:2015 Compliant Recruitment Flow Chart Training - Internal, External, Online and Distance Learning 6
K Which Symbols are used in Process flow diagrams? Manufacturing and Related Processes 2
C Flow Meter calibration for mixed gases Calibration and Metrology Software and Hardware 1
T ITAR/EAR relationship and Flow Down to Suppliers AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 5

Similar threads

Top Bottom