![]() |
![]() |
|
Order Now, Only $25, Save Endless Hours! |
Great for Quality Tracking & Process Charting. |
|
Basic Info & Benefits for Users & Managers. |
Professional Charts in a Fraction of the Time. |
|
DPOINT! Free 14-Day Demo Test Drive Now. |
Fast Entry, Analysis, Consistent Presentation. |
|
| Save time & improve understanding. Scroll down to view charts, info, & tips. For other Excel help visit Our Home Page | ||
| Works in Excel 97 or higher (required), convert data to quality charts in seconds! Enter or paste almost any data daily, weekly, monthly, quarterly, etc. | ||
![]() |
||
| Once data is input, chart it from any starting point with a click! Many options available to quickly customize each chart, add other information, & more! | ||
![]() |
||
| Top Zoom out for a look at the entire chart with a quick click. |
||
![]() |
||
| Top 4 useful charts are combined. A trend chart for individual data comparisons over time, & 3 bar charts to compare the totals. Up to 31 data points, starting & ending at any point, may be charted & analyzed. View statistical limit lines with a click, & much more! |
||
![]() |
||
| Top Zoom out for a look at the entire chart with a quick click. |
||
![]() |
||
| Top This basic Upper Limit, Average, & Lower Limit method provides crystal clear signals that something warrants investigation! Some statistical warning signals are not as apparent, DPOINT! can check up to 7 important signals if desired. Set limits for best results. Auto-Signal Detection shows this data is actually giving off numerous warning signals, investigate & determine the causes of these fluctuations. |
||
![]() |
||
| Top Signals are opportunities - investigate, make improvements, but do something! Some mathematical signals are false or anomalies, always verify something significant happened. Eliminate causes of bad performance or develop contingency plans, standardize causes of good performance, don't make action the missing link! Each data entry sheet - called Enter1, Enter2, Enter3, Enter4, & Enter5 - holds 50 data sets, 250 total sets. More info on data input below. |
||
![]() |
||
| Top After inputting data, go to the CHART sheet & click the buttons above the chart to create & customize for viewing or printing. Show or hide point labels, show or hide any lines, change some font sizes or formats, or copy a chart to include in other presentations. Copied charts are non-updating snapshots, each created in a new Excel file, unprotected to allow customizing by more experienced users. |
||
![]() |
||
| Top More specifics on each button, & see individual drop-down arrow looks further below. |
||
![]() |
||
| Top Select any of the 50 data set titles. |
||
![]() |
||
| Top Select Auto-Signal Detection to set stats & view warning signals, Copy Chart to a new file, Toggle View 75% Normal Screen or 50% Full Screen, Toggle data point labels (values above each data point on trend chart), adjust Y-axis scale or move it to keep charted points aligned over data. |
||
![]() |
||
| Top Select any of the 5 data entry sheets (Enter1 - Enter5). |
||
![]() |
||
| Top Select any existing date, in your data, to start the chart from that date. |
||
![]() |
||
| Top Select number of data points to chart, starting from default date (most recent 31 data) or selected start date. |
||
![]() |
||
| Top Change display (does not alter data) to different format, 0-2 decimals, dollars, or percentages. Enter data as 5 - not $5, .10 - not 10%, 1.50 - not 1:30. |
||
![]() |
||
| Top Change font size for Data, Target & Previous numbers below trend chart (shown), from size 6-14. Do not change Print Area! Click File / Print Preview to see how chart will print. |
||
![]() |
||
| GET DPOINT! | ||
Order Now On-line and Save Endless Hours! |
||
| Contact info@excel97.com with questions. Visit Our Home Page |
||
| Top Copyrights & other legal below & in program. |
||
| |
||
| DPOINT! is copyright 1999-2001 LCL Resources. All rights reserved. | ||
| Visual Basic is a registered trademark of Microsoft Corporation. | ||
| Excel & all Microsoft products mentioned are either trademarks | ||
| or registered trademarks of Microsoft Corporation. | ||
| Other than free downloads, or any assistance specified directly as | ||
| free or general information, no original materials, images, or any | ||
| information may be copied or reproduced for any commercial purpose | ||
| without prior written consent of LCL Resources. | ||
| We of course do not object to non-commercial personal uses for individual improvement. | ||
| All original materials, images, or any information on these, & subsequent LCL Resources | ||
| or any excel97.com, pages, or any other areas of our sites, products, or services, or any | ||
| assistance are copyright LCL Resources, 2000. All rights reserved. | ||
| We are a data consulting & resource company not associated with Microsoft | ||
| or any other company mentioned. | ||
| LCL Resources takes all necessary precautions to ensure the security & privacy of Customers, | ||
| however, any Customer using any service whether free or by fee arrangement agrees | ||
| not to hold LCL Resources liable for any assistance, suggestions, files, products, programs, | ||
| formulas, VBA code, issues of privacy or security, or any known or unknown factors affecting | ||
| any systems, persons, property, or assets. | ||
Extensive data analysis, presentation, & teaching experience at various levels for most |
||
| Intermediate to advanced expertise in PowerPoint, basic Word skill, & general Windows use. Mathematics, problem solving, probability, tracking, process quality control, & consulting. Some services may be unavailable due to pre-scheduled client's needs & other priorities. |
||
Excel Help & Answers.Top |
||