Other Excel Help Services Order DPOINT! Now
   
      Order DPOINT! Order Now, Only $25, Save Endless Hours!
Great for Quality Tracking & Process Charting.
      View More DPOINT! Info Basic Info & Benefits for Users & Managers.
Professional Charts in a Fraction of the Time.
      Download Demo Version 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.
   
  DPOINT! data entry sample
   
        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!
   
  DPOINT! basic chart sample without statistical limit lines
   
  Top
      Zoom out for a look at the entire chart with a quick click.
   
  DPOINT! basic chart sample without statistical limit lines
   
  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!
   
  DPOINT! chart and stat limit lines
   
  Top
      Zoom out for a look at the entire chart with a quick click.
   
  DPOINT! chart and stat limit lines
   
  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.
   
  DPOINT! Auto-Signal Detection and Set Stats Form
   
  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.
   
  DPOINT! data entry sample specifics
   
  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.
   
  Excel chart programmed buttons
   
  Top
      More specifics on each button, & see individual drop-down arrow looks further below.
   
  Excel chart programmed buttons
   
  Top
      Select any of the 50 data set titles.
   
  Excel chart programmed buttons
   
  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.
   
  Excel chart programmed buttons
   
  Top
      Select any of the 5 data entry sheets (Enter1 - Enter5).
   
  Excel chart programmed buttons
   
  Top
      Select any existing date, in your data, to start the chart from that date.
   
  Excel chart programmed buttons
   
  Top
      Select number of data points to chart, starting from default date (most recent 31 data) or selected start date.
   
  Excel chart programmed buttons
   
  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.
   
  Excel chart programmed buttons
   
  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.
   
  Excel chart programmed buttons
   
        GET DPOINT!
   
      Order 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.
   
     Site rated safe for all ages, link to rating organization
   
        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
        functional areas. Production, sales, finance, human resources, maintenance, etc.
        Thousands of hours experience with data analysis, charts, reports, & presentation skills.
 
      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
        CONTACT INFO ABOVE!