V _ L _ _ S
T H _ T
Y _ _
_ N T _ R
_ N
T H _
C H _ R T
D _ T _
T _ B L _
D _ _ L _ G _ _
B _ X
( Y _ _
C _ N
C R _ _ T _
T H _ S _
C H _ R T S
_ N
W R _ T _ R ,
D R _ W ,
_ R
I M P R _ S S ,
_ N D
Y _ _
C _ N
C _ P Y
_ N D
P _ S T _
T H _ M
_ L S _
T _
C _ L C ) Clue
VALUES THAT YOU ENTER IN THE CHART DATA TABLE DIALOGUE BOX (YOU CAN CREATE THESE CHARTS IN WRITER, DRAW, OR IMPRESS, AND YOU CAN COPY AND PASTE THEM ALSO TO CALC) OPEN TWO DOCUMENTS: THE OPENOFFICE CALC SPREADSHEET IN WHICH THE EXTERNAL DATA IS TO BE INSERTED (TARGET DOCUMENT) AND THE DOCUMENT FROM WHICH THE EXTERNAL DATA DERIVES (SOURCE DOCUMENT). IF THE DATAPILOT TABLE CONTAINS ONLY A SINGLE RESULT VALUE THAT FULFILLS ALL OF THE CONSTRAINTS, OR A SUBTOTAL RESULT THAT SUMMARISES ALL MATCHING VALUES, THAT RESULT IS RETURNED. YOU CAN ORGANISE DATA SERIES AND EDIT THE SOURCE FOR PARTS OF SINGLE DATA SERIES ON THE THIRD PAGE OF THE CHART WIZARD OR ON THE PAGE DATA SERIES IN THE DATA RANGE DIALOGUE BOX.