John Seddon - Vanguard Consulting Vanguard Logo
Home
Online Charts
Create Online Chart
CapChart
Want to create a chart?  
Importing Data from Paper  
Creating a Chart from Scratch
Asking Better Questions  
Splitting the Data  
Special Causes  
Saving Views  
CapChart Help
Getting Started  
Charts  
Views  
Excel Data  
Access Database  
Filters  
Options  
Remove Points  
Including Points  
Splitting Charts  
Annotation  
Chart Zoom  
Scaling  
Import Data  
Glossary  
Menus  
Groups  
Moving Views  
Download
Product Key
Register
Login
Purchase
 
Data Format
There are two types of summary data that the Vanguard Charting tool understands, Case and date.

Date Data


The data format should include each date entry as a single row. Only one column should be included with dates and each subsequent column numeric values. the first row is used for the series names.
Dates Excel
Fig 1 Date Summary Data
Case Data

For case data the format is similar to the date format except instead of a column for dates there is a column for case number. This column should be of a text format.
Cases Excel
Fig 2 Case Summary Data