Home

DeltaGraph 5 User`s Guide for Windows

1. Ternary Charts A ternary chart uses a triangular map to represent the ratio of different elements to a sum total For example a chemical company could display the amount of various ingredients that make up a product Setting up your data The ternary chart requires three columns of data for each data series The first column corresponds to values on the x axis The second column corresponds to values on the y axis The third column corresponds to values on the z axis In a default ternary chart the x axis is on the right the y axis is on the bottom and the z axis is on the left Each row defines a point The position of the points is calculated by dividing each value by the sum of the row 102 Chapter 6 Figure 6 7 Ternary chart Data for scatter BE a A pa at a Product 4 Product B Cell 1 6 For Help press F1 ay lo B Product A Product B 0 4 wis Ternary Percent Charts A ternary chart uses a triangular map to represent the ratio of different elements to a sum total For example a chemical company could display the percentage of various ingredients that make up a product 103 Scatter Charts Setting up your data The ternary percent chart requires two columns of data for each data series Data must be in percentage form represented as a value between 0 and 1 The first column corresponds to values on the x axis The second column corresponds to values o
2. o 250 Preparing a Print Job o o 251 To Print Charts and Objects o 251 FoPint Datas soc ase eee ae EN A At a 252 Xiv To Preview a Print Job 252 Using a Service Bureau 252 To Create PostScript Files o o 253 To Create Encapsulated PostScript Files 254 18 Using DeltaGraph Charts in Other Applications 255 To Create DeltaGraph Charts in Other Applications 255 To Add Linked Charts to Other Applications 256 To Embed Charts in Other Applications 257 To Modify Charts in Other Applications 257 To Position Charts in Other Applications 258 19 Customizing the DeltaGraph Desktop 259 To Minimize the Document Manager 259 To Show or Hide the Document Manager 260 To Show or Hide Toolbars o o 260 To Show or Hide the Toolbox o 260 To Show or Hide the Rulers and Grid 260 To Show or Hide the Status Bar 261 To Move ToolbarS o o e 261 Rulers and Grid Dialog BOX o o 261 To Change Rulers and Grid Settings 262 Preferences General 2 2 ee ee 263 To Modify General Preferences o 264 To Modify Ruler and Grid Defaults
3. 173 Showing Valles treo at 173 Show Values Dialog BOX o 174 To Display Values or Categories within a Chart 175 13 Working with Chart Objects 177 Format Object Colors 2 2 a 177 To Apply a Gradient Fill 179 To Apply a Pattern Fill 180 To Change the Object Fill Pattern 180 To Change the Object Color o o 181 Format Object Lines o e 181 To Change the Line Color o o o o oo o 182 To Change the Line Dash Style 183 To Change the Line Width 183 Format Object Arrows o e 184 To Draw Arrows o o 000000000008 184 Format Object Shadows o o 186 To Apply a Shadow o o 187 Format Object Text 2 a o e 188 Format Object Spacing 2 2 o e 190 To Add Text Objects to Canvases o 190 Format Object Bullets o o o 192 To Format Text as a Bulleted List 192 Using the Drawing Toolbox o oo oo 193 To Zoom In and Out o o 193 To Draw EmES tuto bi Fak a ee Ed 194 To Draw Bezier Curves o o 194 To Draw Curves 22 4 eds e a Bs 195 To Draw Freehand Objects o o o 196 xi To Draw Filled Sha
4. ANTE WHH We ON y 20 Death Rate 25 55 Birth Rate 3 D XYZ Surface Line Charts AAAA ILLERA Mi Literacy Rate 3 D Charts A 3 D XYZ surface line chart shows three dimensional data One quantity plotted on the z axis varies according to the x and y values and contains a three dimensional plane represented by lines For example you could examine the fish population in a river where various pollutants are detected Setting up your data Each data series requires three columns of data The first column contains the x coordinates the second column contains the y coordinates and the third column contains the z coordinates 160 Chapter 10 Figure 10 10 3 D XYZ surface line charts Data for 3dcharts fx 2 3 3 o a 2 it Chapter 11 Combination Charts Combination charts combine two different types of numeric charts You can use the combination chart to present different concepts within the same chart or to highlight relationships among similar items For example you could combine a bar chart with a line chart to represent the portion of business income that goes toward expenses You can obtain a combination chart by selecting an existing chart that contains two or more series opening the overlay dialog from the chart menu and selecting one or more series to present as an overlay The allowed overlay types are shown in this dialog and you can choose which one you w
5. Recently Used File List E Entries Separate metafile images into distinct objects Cancel Apply Help 264 Chapter 19 Template Use the Browse button to select the file that you want to use as the document template Prompt for style set Select if you want DeltaGraph to prompt you to load a style set when you create a new document Rulers amp Grid Click to set defaults for rulers and grids Display start up dialog Select if you want the Welcome to DeltaGraph dialog box to display when you launch DeltaGraph Recently Used File List Enter the number of recently used files that you want the File menu to display Separate metafile images into distinct objects Select to import metafile images as separate objects so that you can manipulate them individually To Modify General Preferences From the menus choose Edit Preferences Click the General tab Do any of the following m To change the document template click Browse and browse to the location of the file that you want to use m If you want to be prompted to load a style set when you create new documents select Prompt for style set m Tochange the rulers and grid settings such as the unit of measurement and whether to snap objects to the grid click Rulers amp Grid m If you want the Welcome to DeltaGraph dialog box to appear when you launch DeltaGraph select Display start up dialog m To change the nu
6. 160 M Product A 140 120 100 80 60 40 1994 1995 1996 1997 1998 1999 Product Sales 107 Area Pie and Table Charts Spider and Radar Charts A spider chart shows values for multiple variables arranged along different radii of a circle spokes For example you could examine the effectiveness of a media campaign to promote several new products You can create a radar chart by plotting a spider chart and changing some settings in the Options dialog box A radar chart uses a circular grid system like a bull s eye target Setting up your data This chart requires three or more rows of data Each row corresponds to a category or spoke in the chart Each column of data corresponds to a data series Row labels name each category or spoke Column labels name each data series these labels appear in the legend If one or more of the chart s spokes fall into a group you may want to enter additional labels to provide additional detail Supercategory labels appear beyond the category labels around the perimeter of the chart and lie midway between the first category of the group and the last Figure 7 2 Spider and radar charts Data for areapie BE A B Product ProductB Product C TESI TY 2 Radio Magazine Cell 1 7 For Help press F1 108 Chapter 7 TV Sales Promotion We Product A Results Product B Product C Web 5 50 Radic 50 50 Ma
7. A Cancel Apply Help For Numeric Data Choose a number format for the data The Example area at the bottom displays how your data will look using the current settings Decimal Places Choose the number of digits that you want to be displayed to the right of the decimal point Use Commas Select to use commas as separators between thousands Minus Sign Select to display negative numbers using a minus sign Parentheses Select to display negative numbers using parentheses 28 Chapter 2 Figure 2 6 Format Cells Data Type tab with Date Time data selected Format Cells x Data Type text Appearance m Data Type FT No Date Long Date with Day C Numeric i Date Time C Currency C Text TF No Time Example 12 00 AM Friday January 1 1904 OK Cancel Apply Help For Date Time Data Choose a format for the data The Example area at the bottom displays how your data will look using the current settings You can choose a date format a time format or both 29 Preparing the Data Figure 2 7 Format Cells Data Type tab with Currency data selected Format Cells x Data Type text Appearance Data Type Numeric C Date Time Currency IV Use Current Language Default Currency f Tex United States USD y Example 54 00 Cancel Apply Help For Currency Data Choose a currency type
8. Axes Symbols and Legends Ternary Ternary charts use a special axis system in which the three value axes have the same attributes Time Line Time line charts use a special axis to control tick marks Z Color Some charts use a color coded axis or legend to represent a third data series Z Contour Some charts use contour or elevation lines to represent a third data series Figure 12 1 Axis types secondary category axis Category 1 Category 2 Category 3 100 lt major tick 4 minor tick major increments 8 k o 90 25 E minor divisions gt f 80 4 E 70 g2 E og 2 J C g g E g 2 157 C50 8 3 E S 4 C g Eso S E C 3 E E 30 o Category 1 Category 2 Category 3 category axis x axis primary axis 168 Chapter 12 primary value axis z axis secondary value axis To Modify Chart Axis Properties You can increase the increment of the major ticks to create a simpler axis scale change the font size and style of the axis title or even change the position of the axis in relation to the other axis From the menus choose Chart Axis X axis Y axis or other axis Click the tab that corresponds to the type of changes that you want to make Make your changes as desired For information about specific options click the Help button Click Apply to apply the changes or click OK to accept the changes and close the dialog bo
9. 232 To Opeisa Labrary cio at 232 xiii To Close a Library o 232 To Add Items toaLibrary oo o 233 To Rename Library Items o o 233 To Delete Library Items o o 233 To Use Library Items in Documents 233 Adding Pictographs to Charts o o 234 Pictographs 00 ciis eo Qe a a ae O a A ee 234 To Create Pictographs o o 235 To Remove Pictographs from ChartS 236 To Modify the Scaling Style of Pictographs 236 To Modify Pictograph Alignment 237 To Use an Image as a Chart Background 237 To Create a Stretch Pictograph 238 About Chart Templates o a 239 Add Chart Template to Library o 240 To Create Chart Templates 240 To Create Charts from Templates 241 To Add Chart Templates to the Chart Gallery 241 17 Preparing Your Document for Printing 243 Working with Color o o o e 243 Edit Colca rs ios td a es Ge 244 To Change Color Models o o o 247 To Modify Document Colors o o o 248 To Create a Custom Color Scheme 249 To Load a Custom Color Scheme 2 249 To Select PANTONE Colors o o 250 To Set Up Color Profiles
10. 20 5 20 19 5 19 18 5 4 5 3 5 2 5 1 5 0 5 LotA LotB LotC LotD LotE LotF LotG LotH Lotil LotA LotB LotC LotD LotE LotF LotG LotH Lotil Lot J Lot J UCL 21 27 UWL 20 87 Mean 20 07 LWL 19 27 LCL 18 87 UCL 4 398 UWL 3 625 Mean 2 08 LWL 0 535 139 Statistical and Quality Control Charts Figure 9 7 XBar chart with XBar S chart 21 5 21 20 5 20 19 5 19 18 5 1 8 1 6 1 4 1 2 0 8 0 6 0 4 0 2 LotA LotB LotC LotD LotE LotF LotG LotH Loti LotA LotB LotC LotD LotE LotF LotG LotH Lotil Lot J Lot J UCL 21 27 UWL 20 87 Mean 20 07 LWL 19 27 LCL 18 87 UCL 1 729 UWL 1 428 Mean 0 82 LWL 0 227 140 Chapter 9 Fraction Defective p and Number of Defectives np Charts When you plot a p chart the exact type of chart that results depends on your subgroup sizes Variable subgroup sizes produce a fraction defective p chart Fixed subgroup sizes produce a number of defectives np chart Control and warning limits show which data values fall outside of the control range The upper and lower warning limits represent the values that are two standard deviations or two sigmas away from the mean The upper and lower control limits represent the values that are three standard deviations or three sigmas away from the mean The fraction defective p chart plots the fraction of defective items in each subgroup T
11. Files of type Encapsulated Postscript eps y Cancel Image Hel Preview Help Include z You can import the following image formats bmp Windows bitmap jpe jpe jpeg JFIF JPEG image pntg pnt mac MACPaint bitmap psd Adobe PhotoShop image png Portable Network Graphics pct pict pic QuickDraw PICT image sgi rgb Silicon Graphics 199 Working with Chart Objects tga taRga Targa Image File tif tiff TIFF bitmap eps Encapsulated PostScript file wmf Windows Metafile emf Enhanced Metafile gif CompuServe bitmap Spx pix FlashPix image m gti qtif QuickTime image If an eps file has an embedded TIFF or Windows Metafile image the preview window displays the image To Import Images From the menus choose Insert Image Select the file Click OK Tip You can also click the Insert Image tool on the Document toolbar Export Image Dialog Box You can use the Export Image dialog box to select export options for graphic files Save in Specifies the save location of the file File name Type a name for the image file Save as type Specifies the type of image file that you want to export Selected objects Select to export any objects that you currently have selected on the chart canvas All objects Select to export all objects on the current chart canvas 200 Chapter 13 Entire canvas Select to export all
12. 26 Chapter 2 To Plot Data Series from Rows You can plot data series from rows instead of from columns This has the same effect as transposing rows and columns except that it does not change the way that the data are arranged in the Data window From the menus choose Data Series in Rows Note To plot series from columns again choose Series in Columns from the Data menu Formatting Data You can apply formatting to the cells in your data sheets For example you can m Select a data type and display style m Change the font size name and color m Add colored borders to cells Format Cells Data Type You can use the Data Type tab in the Format Cells dialog box to specify the type of data that the cell contains and how they are formatted Start by specifying a data type The options that are available depend on the data type that you choose Keep in mind that if you format numerical data as text you can plot those data only as chart labels 27 Figure 2 5 Preparing the Data Format Cells Data Type tab with Numeric data selected Format Cells x Data Type text l Appearance m Data Type C Date Time C Currency Text Decimal Places jo a I Use Commas Number Format General default a Fixed Precision Percentage Scientific E Scientific 10 Engineering E Engineering 10 Bl Negative Numbers Minus Sign Parentheses Example
13. 265 Preferences Charts 2 40 is ba ba beak O as 265 To Modify Chart Preferences o o o o 267 XV Preferences Data 272 To Modify Data Preferences o 273 Preferences Profiles 0 274 To Modify Profile Preferences 276 Preferences Libraries iaa a a ala a 276 To Modify Library Preferences o 277 Preferences Drawing Toolbox 278 To Modify Drawing Toolbox Preferences 279 To Set Default Text Box Properties 280 Index 281 xvi Chapter 1 Welcome to DeltaGraph 5 Welcome to DeltaGraph 5 the powerful charting application that you can use to create charts using data from a wide range of sources Whether you need charts to present your sales information or to explain highly technical data DeltaGraph provides the tools you need to create visually compelling charts with maximum impact This section shows you how to get started with DeltaGraph 5 whether you are an experienced user and want to check out the new features or whether you are a new user and want basic information about setting up and saving files What s New in DeltaGraph 5 DeltaGraph 5 includes many new features and enhancements including new ways of viewing and navigating your document Chart Wizard The Chart Wizard provides you with step by step guidance when you create a chart Th
14. Click the Lines tab Click the foreground color swatch and choose a color from the palette Click OK Format Object Shadows You can use the Shadows tab in the Format Object dialog box to add a shadow and to change the fill style and background and foreground colors of the shadow You can add a shadow to any object including lines Figure 13 4 Format Object dialog box Shadows tab Format Object E Colors Lines Arrows Shadows C Noshadow Drop shadow Inset shadow Drag white square to set shadow Shadow as Shadow gt 3 Foreground X Background y Color Color Shadow Fill Style Horizontal 5 a pts Vertical 5 pts Y DK Cancel Apply Help 187 Working with Chart Objects No shadow Select to remove a shadow Drop shadow Select to add a shadow to an object Inset shadow Select to add a beveled effect to lines or borders This effect works best for lines with a width of at least three points Shadow Foreground Color Click the color swatch and choose a color from the palette Shadow Background Color Click the color swatch and choose a color from the palette The background color appears only if the shadow has a pattern fill Shadow Fill Style Click the arrow to choose a shadow style from the palette Horizontal Enter a number to define the horizontal displacement of the shadow Vertical Enter a number to define the vertical displacement
15. Edit Preferences Click the Profiles tab Make the desired selections Click OK Preferences Libraries You can use the Libraries tab in the Preferences dialog box to select which libraries will automatically load when you launch DeltaGraph 277 Customizing the DeltaGraph Desktop Figure 19 9 Preferences Libraries tab Preferences x General Charts Data Profiles Libraries Drawing Toolbox m Automatically Load at Startup Available Libraries E DeltaGraphS Current_DG5_Debug_Sai OK Cancel Apply Help Available Libraries Initially the list displays all libraries located in the DeltaGraph Libraries folder Select a library to automatically load or open when you launch DeltaGraph Browse Click Browse to find and add a library to the Available Libraries list To Modify Library Preferences From the menus choose Edit Preferences Click the Libraries tab 278 Chapter 19 Prefere Make the desired selections Click OK nces Drawing Toolbox You can use the Drawing Toolbox tab in the Preferences dialog box to set default text properties for text objects Figure 19 10 Preferences Drawing Toolbox tab Preferences El General Charts Data Profiles Libraries Drawing Toolbox Buttons Stick On C Single click New Text Boxes Text Cancel Apply Help Buttons Stick On Select Single cl
16. Effects r Drag white letter to set shadow Font Er Aid Baseline Style Rega ee man Subscript Size E E T Strikeout I Underline m Alignment Script Shadow E Horizontal 4 pts Color Westem y so Vertical 3 pts Cancel Apply Help Font Choose a font type such as Arial or Times New Roman Color Style Choose a font style such as bold or italic Size Choose a font size Color Click the color swatch and choose a color from the palette Alignment Available for text objects Choose a text alignment style left justified centered or right justified Effects Choose a font effect such as an underline or a strikeout Script Choose a font script such as Western or Greek Text shadow Enter horizontal and vertical values to set the direction of the shadow You can also drag the preview letter to set the font shadow direction Shadow Color Click the color swatch and choose a color from the palette 190 Chapter 13 Format Object Spacing You can use the Spacing tab in the Format Object dialog box to change line spacing and paragraph spacing Figure 13 6 Format Object dialog box Spacing tab Colors Lines Shadows Text Spacing Bullets Text in text box is 9 point Line Spacing Increments AE 15 lt points Paragraph Spacing le points Hint Changes made here apply to all the text in the textbox Cancel
17. Event 1 Event 2 Event 3 Event 4 Event 5 Event 6 Event 7 9 8 1991 11 5 1991 14771992 4 1 1992 6 15 1992 7118 1992 7730 1992 eT gt Data Data Cell B 10 For Help press F1 Event1 Event3 Event5 Event 7 Event 2 Event 4 Event 6 8 1 1991 10 1 1991 12 1 1991 2 1 1992 4 1 1992 6 1 1992 8 1 1992 Chapter 6 Scatter Charts Scatter charts work well for displaying relationships between data series For example you could use a paired scatter chart to examine the relationship between age and income Bubble charts add a third dimension to a scatter chart Ternary charts map ratios This chapter describes the following chart types Paired scatter charts Scatter charts Paired intensity scatter charts Intensity scatter charts Polar charts Bubble charts Ternary charts Paired Scatter Charts A paired scatter chart shows the relationship between data points from one or more pairs of data columns Each x coordinate is paired with a corresponding y coordinate For example a catalog order company could plot revenues by advertising expense for several products in one chart Setting up your data Each data series has two adjacent columns of data The first data column contains the x coordinates and the second column contains the y coordinates Because the paired scatter chart uses values on both axes there are no category axis labels 93 94 Chapter 6 Figure 6 1 Paired sc
18. Exp Log Ln All trigonometric functions remember that values are in radians Formula for the nth root For all of the other functions do not use the independent variable or any parameter as a function argument This restriction ensures that the other function has zero valued partial derivatives with respect to the independent variable and each parameter Achieving Better Custom Curve Fits Defining custom curve fits usually requires several cycles of trial and error to attain the best curve The following tips can help you to achieve more accurate results Check that the graph on the screen matches the function at the nodes Be sure that the nodes are evenly spaced along the curve in the x axis direction The placement of nodes can be controlled in the Bezier Nodes field in the Curve Fit dialog box Sometimes a graph can look different from the model because the number of nodes is too small Remember that some functions have values for which they are undefined Avoid selecting initial values of parameters that cause the evaluation of the model function at any x value to be undefined In this case you may see a calculation error message Avoid selecting initial values of the parameters that cause the evaluation of the model function at any node s x coordinate to be undefined The graph may be drawn strangely in the vicinity of such a node Be sure that the parameters initialized in the Parameters field match those used in the mod
19. From the menus choose View Status Bar Note A check mark means that the status bar is displayed To Move Toolbars You can move toolbars the Document Manager the Libraries window and the toolbox to any location on your desktop Click anywhere on the toolbar outside of the toolbar buttons Drag the toolbar to its new location Dragging the toolbar to the top bottom or side of the window docks the toolbar at that location You can also leave the toolbar as a floating palette in the window Tips m You can dock and undock a toolbar by double clicking anywhere outside of its buttons m You can prevent a toolbar from docking by pressing Ctrl while you drag it Rulers and Grid Dialog Box You can use the Rulers and Grid dialog box to change the settings for the rulers and grid 262 Chapter 19 Figure 19 1 Rulers and Grid dialog box Rulers and Grid x Rulers Units inches gt Grid T Show grid Size 0 25 Snap to grid Cancel Help Show rulers Select to display the rulers along the left and top side of your Chart window Units Choose a unit of measurement from the drop down list Show grid Select to display the grid in the Chart window Snap to grid Select to snap objects automatically to the nearest grid intersection Size Enter a size for the grid increments This control uses the unit of measurement that you choose in the Units drop down list To Change Rulers
20. Position Text Font Ea Style Regular y Size 12 Color Page 1 of 3 areapie 7 24 00 Cancel Help Font Specifies the font type To change the font choose another type from the drop down list Style Specifies the font style To change the style choose another from the drop down list Size Specifies the font size To change the size choose another from the drop down list Color Displays the text color To change the color click the swatch and choose another from the palette 10 Chapter 1 To Edit Headers or Footers 4 From the menus choose File Document Setup Click the Properties button In the Header Footer Properties dialog box click the Contents tab Use the check boxes to select which items to display in the header or footer A check mark means that the item is displayed Use the drop down lists to select the format of each item that you have chosen Click OK To Reposition Headers or Footers From the menus choose File Document Setup Click the Properties button In the Header Footer Properties dialog box click the Position tab Click one of the six marked areas on the canvas thumbnail to select a position for the header or footer The area beneath previews how your header or footer will appear Click OK 11 Welcome to DeltaGraph 5 To Format Headers or Footers From the menus choose File Document Set
21. 131 132 OLE objects creating 255 embedding 257 linking 256 modifying 257 positioning 258 opening libraries 232 ovals drawing 196 overlay charts 59 60 161 163 p charts 140 paired charts 90 93 95 PANTONE Color Matching System 250 252 Paradox files importing 16 18 paragraphs 190 191 Pareto charts 130 131 132 pasting data from the Clipboard 20 Pattern Fill tool 180 Pattern tool 180 pictographs 234 238 about 234 adding to background 237 aligning 237 modifying 234 236 options 234 removing 236 Index pie charts 109 multiple pies 113 stacked charts 112 placeholders in layouts 225 226 plotting data series from rows 26 polar charts 98 Polygon tool 197 polynomial curve fitting 210 PostScript files 253 power curve fitting 210 preferences 263 265 267 268 270 272 274 276 278 279 preparing data for charting 13 previewing a print job 252 printing about 251 charts and objects 251 data sheets 252 files to disk 253 on a commercial press 252 previewing a print job 252 process colors 252 producing your document 243 quality control charts 136 Quattro Pro files importing 16 18 radar charts 107 radius angle vector charts 125 range charts 80 Rectangle tool 196 refreshing charts 61 regenerating formulas 41 reinitializing curve fit parameters 218 Remainders function 46 removing data sheets 15 links to Excel files 22 288
22. 71 pie charts 112 Standard Deviation function 48 Standard Score function 49 start up dialog box 264 statistical charts 133 134 136 140 142 status bar showing and hiding 261 step charts 79 stretch pictographs 238 style sets 221 264 loading 222 289 opening 222 saving 222 subscript characters 30 superscript characters 30 survival charts 134 switching columns with rows 25 SYLK files importing 16 18 symbols 169 formatting 170 171 setting defaults 271 table charts 115 templates adding to the Chart Gallery 241 applying 241 creating 240 setting default 264 ternary charts percent charts 102 text formatting paragraphs 191 setting indents 191 setting margins 191 setting tabs 192 text data formatting 30 31 text objects bulleted lists 192 setting defaults 280 Text tool 190 tick marks 269 setting defaults 269 time line charts 92 tool tips 264 toolbars docking and undocking 261 moving 261 showing or hiding 260 toolbox 193 moving 261 setting defaults 279 Index showing or hiding 260 tools Arrow 184 185 186 Bezier Curve 194 195 Circle 196 Color 181 Curve 195 Freehand 196 Gradient 179 Line 185 194 Line Color 182 Line Dash Style 183 Line Width 183 Pattern 180 Polygon 197 Rectangle 196 Round Rectangle 196 197 Shadow 187 Text 190 Zoom 193 transposing columns 25 trigonometric functions arccosecant 48 arccos
23. Chart Placement This panel of the Chart Wizard lets you choose a destination chart canvas for the new chart Figure 3 5 Chart Wizard Chart Placement Chart Wizard Options Chart Placement SABAS E Select the target canvas where the new chart will appear from the list at right Current Canvas Help Cancel lt Back Next 55 Creating Charts To Use the Chart Wizard You can select the range of data that you want the chart to plot before you open the Chart Wizard or while you have it open You can even change the range of data used by the chart after it is plotted From the menus choose Chart Wizard Select a chart category from the list and click Next Select a chart type from the list and click Next Ensure that the data you have selected is what you want plotted by the chart and click Next Choose a destination chart canvas for the new chart and click Finish Tips m You can also access the Chart Wizard by clicking the Chart Wizard tool on the Charting toolbar m If you have previously completed the Chart Wizard you can click Finish at any time The remaining settings will be the same as the last chart you created 56 Chapter 3 Chart Gallery Use the Chart Gallery to create charts from the data that you have selected in the Data window The Chart Gallery provides all of the controls that you need to create a chart in a single dialog box If
24. Color Palette In the Color Set group of the Edit Colors dialog box select Scheme colors or Custom colors 4 In the Choose Item to Edit area click the swatch of the object whose color you want to edit Do one of the following Modify the color by adjusting its component levels in the Edit Color group m Change the color by clicking the System Colors button and using the Color dialog box You can choose a new color by clicking a swatch in the Basic Colors palette or you can click the color you want on the color matrix Click OK to close the Color dialog box Click OK Tip You can also access the Edit Colors dialog box by double clicking Scheme Colors or Custom Colors on the Documents tab in the Document Manager 249 Preparing Your Document for Printing To Create a Custom Color Scheme From the menus choose Edit Color Palette In the Color Set group of the Edit Colors dialog box select Scheme colors Inthe Choose Item to Edit area click a color swatch Do one of the following m Create the color by adjusting the levels of its components in the Edit Color group m Choose the color by clicking the System Colors button and using the Color dialog box You can click a swatch in the Basic Colors palette or you can click the color you want on the color matrix Click OK when you have finished Repeat until all of the swatches in the Choose Item to Edit area have been assigned colors Click S
25. Data Format Cells In the Format Cells dialog box click the Appearance tab 37 Preparing the Data Click the Cell Color swatch and choose a color from the palette Click OK Tip You can also access the Format Cells dialog box by clicking the Format Cells tool on the Data window toolbar or by right clicking any cell Sort Dialog Box You can use the Sort dialog box to sort data by selected columns You can use up to three sort keys For each sort key choose whether to sort in ascending or descending order Figure 2 10 Sort dialog box Select Sort Order First a Ascending C Descending Second E Ascending C Descending Third je y Ascending C Descending OK Cancel Apply Help First Choose the column that you want to use as the first sort key Second Optionally choose a column to use as the second sort key Third Optionally choose a column to use as the third sort key 38 Chapter 2 To Sort Data Use care when sorting your data If your rows and columns are arranged in a meaningful matrix you can destroy the matrix with a single sort It is important to select all of the columns that you want to be affected by the sort before performing it Select the rows or columns that you want to sort Select all rows or columns that you want to be sorted even if you do not want to use them as sort keys From the menus choose Data Sort Se
26. Data for Document 1 _ BE lea fe Y Label A B Ca Series 1 1 Category 1 2 Category 2 3 Category 3 Cell 4 8 For Help press F1 200 150 100 50 Category 1 Category 2 Category 3 Volume Open High Low Close Charts Volume open high low close charts show values that fluctuate within a given time period such as a day These charts have two vertical axes On one the volume is plotted as a column for each category on the other high low open and close values are plotted as in an ordinary open high low close chart Setting up your data Each series must have five columns of data that represent volume open high low and close respectively Each data sheet can contain more than 86 Chapter 5 one series of data The default chart has a vertical line extending from the low to the high values and a horizontal line projecting to the left for the open value and one projecting to the right for the close value Row labels are used to name each category To name the series enter a label in the first column of each series Figure 5 7 Volume open high low close chart Data for Document 1 Alx HIT EJER NES E Label A B C D E a Label Volume Open High Low Close Category 1 Category 2 Category 3 fad DalaB Data 6 Cell G 4 For Help press F1 250 120 200 100 80 150 60 100 40 50 20 0 0 Category 1 Category 2 Category 3 87 Line Step
27. Error Bars dialog box Error Bars x Series Y Dimension Division 1 Division 3 Y Show Enor Bars Equalends Unequalends Upperend Lower end Measure Whiskers E Inches Cancel Apply Clear All Help Series Select any combination of series Whiskers Select a width for the error bar cap Show Error Bars Select to display error bars Equal ends Click to display the upper and lower ends of the error bar Unequal ends Click to display upper and lower ends with different error bar measurements Upper end Click to display only the upper end of the error bar 208 Chapter 14 Lower end Click to display only the lower end of the error bar Measure Choose an error bar measurement If you choose Unequal ends you will be able to choose a different measure for the upper and lower end Variable Displays the individual error for each point in a series Select a series from the Series list on the left and choose a series from the Measure list to create an association between the data series and the error series You should have already calculated or entered the error amount in a separate column in the data sheet Standard Deviations Displays the error bar in standard deviation units based on the sum of data values for all series selected Within series displays the error bar in standard deviation units based only on the data for the individual series Pooled displays the error bar in standard deviation units
28. If a data series contains more than one column click the label cell of the first column Type the label text and press Enter Note When you select data for the chart make sure that the label column or row is the first that you select Calculated Data The Formula Builder provides dozens of mathematical statistical and data analysis functions that you can use to create new calculated columns from the values in your existing columns For example you can create a calculated column called Profit that calculates the difference between your expenses and revenue You can also create a variety of custom mathematical functions by combining operators with columns or numbers When you create custom functions the standard order of operations applies You can override this order by using parentheses Formula Builder You can use the Formula Builder dialog box to perform calculations on data and enter the results in a new column 40 Chapter 2 Figure 2 11 Formula Builder dialog box Formula Builder x m Source Columns Functions Operators Data 1 y dde Ele Je MEEA ERRE FIA fa m Function Description Diff a column The numeric difference between rows Formula Current Destination Column E lt lt Col D Col F gt gt Calculate Now OK Cancel Help Source Columns Lists the populated columns in each data sheet in the Data window Choose the data sheet in the
29. In the Save as Type drop down list choose a file type In the File Name text box type a name for the data file Click Save In the Select the Export Range dialog box choose whether you want to export the whole data sheet the currently selected cells or a range of cells Click OK Tip You can also copy and paste or drag and drop data from the Data window into other open applications To Paste Data into DeltaGraph With DeltaGraph running open the data file in its native application for example open an Excel spreadsheet in Microsoft Excel Select the range of data that you want to copy to DeltaGraph From the menus choose Edit Copy Switch back to DeltaGraph In the Data window click a cell on the data grid to select it as the insertion point From the menus choose Edit Paste Tip You can also drag and drop tab delimited data from other applications 21 Preparing the Data Links Dialog Box You can use the Links dialog box to update modify or break the links you have to data in external files Figure 2 4 Links dialog box Links BE Links Type Update Cancel compcost xls compcostIR1C01 A5C4 Worksheet Automatic Update Now Open Source Change Source Break Link Source E AWinBuildihipicompcost IslcompcostiR101 RA5C4 Type Microsoft Excel Worksheet Update Automatic Manual Help Links Displays all of the links in the current document Click a link to sele
30. Sample data Select to create a chart using the sample data Set axis titles Select if you want to create axis titles before creating the chart You can use cells from the Data window as axis titles or you can type in new titles To Use the Chart Gallery You can select the range of data that you want the chart to plot before you open the Chart Gallery or while you have it open You can even change the range of data used by the chart after it is plotted From the menus choose Chart Gallery In the Charts group select the chart categories that you want to display In the Source group select a source for the charts Select a chart type by clicking it in the left pane Inthe Plot Chart On drop down list choose the canvas on which you want to place the chart If you want DeltaGraph to automatically size and place the chart on the chart canvas select Auto plot If you have not already selected data in the Data window you can do one of the following m Select Use all data Deselect this if you have more than one chart s worth of data on the data sheet m Select Sample data to plot a chart using sample data Select whether to add axis titles Click OK 59 Creating Charts If you deselect Auto plot the cursor changes to the chart area cursor when you close the Chart Gallery Click and drag on the chart canvas to specify the size and position of the chart Chart Overlay Dialog Box A comb
31. the value of Y given the value of X With X F y you are trying to predict the value of X given the value of Y Domain Choose the length of the curve fit If you choose Axis the curve fit runs from axis to axis If you choose Data the curve fit runs from the smallest domain value to the largest domain value Bezier Nodes Enter a value to set the number of Bezier nodes used to plot the curve This affects only the appearance of the drawn curve Higher numbers yield smoother lines Force curve through origin If you choose the Linear or Polynomial function you can select Force curve through origin to make sure that the curve fit includes the origin 211 Equations Error Bars and Curve Fits Figure 14 3 Curve Fit dialog box Series Eunction Formula Division 1 None f x a p 1 295288E 0 2 Division 3 Linear where a exp 1 430275E 0 Polynomial R 2 8 723177E 1 Display Digits e Options Direction Domain Bezier Nodes x Fly y Data y 25 Cancel Apply Help To Apply a Curve Fit to a Chart You can draw curves for one data series a selection of series or all of the series Curves are displayed within the boundaries of the axes only If you need to see more of the curve extend the range of your value axis Select the chart 212 Chapter 14 From the menus choose Chart Curve Fit Select the series to which you want to fit a curve Select a cu
32. 218 To Save a Custom Curve Fit 219 xii 15 Standardizing Charts and Documents 221 To Select the Document Template 221 To Load Style Sets iy a TE Teg Be be ne ee 4 222 To Save Style Sets 3 2 05 a A Be See hie eS 222 To Import Layouts into Style Sets 2 222 Using Layouts awi ela he A Se Sa ee sla ee a4 223 To Show or Hide the Layouts Window 223 To Create Layouts 020 Sa te ee a eee 224 To Modify Layouts 2 2000004 224 To Duplicate Layouts o o 224 To Rename Layouts o o 225 To Add Placeholders to Layouts 225 To Delete Layouts o 226 To Apply Layouts to Canvases o o 226 To Remove Layouts from Canvases 227 Using Backgrounds o e 227 To Show or Hide Backgrounds 227 To Create Backgrounds o o 227 To Create Linked Backgrounds 228 To Apply Backgrounds o oo 228 To Modify Backgrounds o oo o 229 To Remove Backgrounds from Chart Canvases 229 To Delete Backgrounds o o o 230 To Relink to the Master Background 230 16 Using Libraries to Store Charts and Images 231 To Show or Hide Libraries o o o 231 To Create a Library o o
33. 3 D Scatterline Charts A 3 D scatterline chart plots data points created by the intersection of three different coordinate values A line connects the points in each data series A 3 D scatterline chart also works well to measure something that moves in space as a function of time such as a satellite orbiting the earth For example an engineer could explore the relationship among horsepower engine displacement and fuel efficiency Setting up your data Each data series requires three columns of data The first column contains the values for the x coordinate points the second column contains the y coordinate points and the third column contains the z coordinate points The column label for the first data column of each series names the series Figure 10 4 3 D scatterline chart Data for 3dcharts 4 gt fr scatter line area wireframe Cell K 10 For Help press F1 151 3 D Charts Horsepower 3 D Area Charts A 3 D area chart emphasizes the volume or size of a data series usually over time For example a product developer could analyze the various properties of new plastics Setting up your data Each column of data corresponds to a data series or a filled area on the chart Row labels name each category and column labels name each series These will appear in the legend 152 Chapter 10 Figure 10 5 3 D area chart Data for 3dcharts BE A B C Strength Gloss Opacity Sample 1 Sam
34. Apply Help Increments Choose a value to set the space between lines Select Custom to enter a custom value in the Leading text box Leading Enter a value to adjust the spacing between lines Paragraph Spacing Enter a value to adjust the spacing between paragraphs To Add Text Objects to Canvases If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Text tool To keep the tool selected double click it Click and drag to draw the text box 191 Working with Chart Objects Type or paste your text up to 32 000 characters A live hyperlink is automatically generated if you type text that begins with a MIME type prefix for example http telnet mailto etc Click outside of the text object to close the edit field Note If you click outside of the text box without entering any text it will close and be deleted To Modify Text Spacing Select the text From the menus choose Format object name Click the Spacing tab Choose a value for the space between lines and for the space between paragraphs Click OK To Set Margins Double click the text box This replaces the canvas rulers with text box rulers Click and drag the margin stops to change the margin within the text box Click outside the text box to close the edit field To Set Indents You can set a first line indent or a hanging indent with the indent marker A first line in
35. Enter initial values for the parameters and define any constants that you may have used Enter a formula making sure that it includes at least one parameter as well as the independent and dependent variables Choose the estimation settings as desired Click Estimate 218 Chapter 14 Check the output to see if the final model is acceptable If not make changes to the various settings and try again If it is acceptable click Continue to return to the main Curve Fit dialog box The final model formula for the custom curve fit now appears in the Formula field in the Curve Fit dialog box The parameters in the formula have been replaced by numbers these numbers are derived from the iteration with the best fit Click OK To Reinitialize Curve Fit Parameters Reinitializing the parameters of a custom curve fit can improve its accuracy and result in a much better fit Enter a different chi squared value if desired Increase the maximum iterations to a value appropriate to your model computer speed and computer math capabilities This value can be as low as 1 for simple equations and as high as 32 767 for more complex ones Click Estimate Click Reinitialize Parameters Repeat these steps as necessary Click OK To Open a Custom Curve Fit From the menus choose Chart Curve Fit Select the data series to which the curve fit will apply For the curve fit type select the Custom function Click Def
36. Help 268 Chapter 19 Font Choose a font type such as Arial or Times New Roman Style Choose a font style such as bold or italic Size Choose a font size Color Click the color and choose a color from the palette Alignment Choose an alignment type Effects Choose a font effect such as underline or strikeout Script Choose a font script such as Western or Greek Text shadow Enter horizontal and vertical values to set the direction of the shadow You can also drag the preview letter to set the font shadow direction Shadow Color Click the color and choose a color from the palette To Set Default Text Object Properties 4 From the menus choose Edit Preferences Click the Charts tab Click Text Make the desired selections Click OK Click OK in the Preferences dialog box Tick Mark Preferences You can use the Tick Mark Preferences dialog box to set the defaults for chart tick marks and grid lines 269 Figure 19 5 Tick Mark Preferences dialog box Tick Mark Preferences x Appearance Customizing the DeltaGraph Desktop Style With axis C With sample bubbles F Align bubble centers T Auto size frame m Direction C Horizontal Vertical Size bubbles X Tick Marks Major Style Outside y Length 0 06 Inches Minor Style jo utside y Length 0 03 Inches Cancel Help St
37. In the Data window double click the data sheet tab Type a new name for the data sheet Press Enter Tip You can also rename data sheets by right clicking the tab of the data sheet and choosing Rename Bringing Data into DeltaGraph Bringing data into DeltaGraph can include importing data copying and pasting from external files dragging and dropping from other DeltaGraph data sheets or documents or typing data directly into the grid DeltaGraph supports a large number of file types such as spreadsheets databases and even text files allowing you to add charting power to data from almost any application Importing Data You can import data from any of these file types ASCII text txt dat asc csv Data interchange format dif dBASE Il M M IV FoxPro dbf Excel 2 1 and above xls Lotus 1 2 3 wks wk1 wk2 Paradox db Quattro wkq wb SYLK Symbolic Link File Format s k Symphony wks wr SPSS sav 17 Preparing the Data Select the Import Range You can use the Select the Import Range dialog box to specify whether you want to import all of the data that a file contains or only a range of cells You can also specify where in the data sheet you want the new data to be inserted and whether you want the new data to overwrite the existing data Figure 2 2 Select the Import Range dialog box Select the Import Range E Select source and destination settings below for importing the
38. Index renaming layouts 225 library items 233 worksheets 16 rendering intent 276 resizing canvases 6 columns 25 roots 39 rotating objects 204 Round Rectangle tool 196 197 rows adding 24 labeling 38 39 plotting data series from 26 removing 25 resizing 25 transposing 25 rulers 260 261 262 265 Running Sum function 47 saving charts as image files 200 documents 4 Encapsulated PostScript files eps 254 PostScript files prn 253 style sets 222 scatter charts 93 94 95 97 3 D charts 148 3 D scatterline charts 150 segmentation charts bar charts 67 column charts 67 stacked bar charts 68 stacked column charts 68 Select the Export Range dialog box 18 Select the Import Range dialog box 17 selecting data 24 series plotting from rows 26 shadows adding 187 formatting 186 modifying 188 showing or hiding backgrounds 227 Document Manager 260 layouts 223 placeholders 226 rulers 260 the Data window 14 the toolbox 260 toolbars 260 Smooth function 47 snap to grid 261 sorting data 37 38 spacing adjusting for lines 190 adjusting for paragraphs 190 spider charts 107 spline curve fitting 209 210 spot colors 252 SPSS files importing 16 18 Square Root function 47 Squash function 47 stacked charts 163 bar charts 65 bar segmentation charts 68 build up charts 73 column charts 65 column segmentation charts 68 floating bar charts 71 floating column charts
39. Location fLer y Hint If the text will not fit in the chart element the text appears on the Outside You can resize the chart or change the Rotation angle to make it EA fit Text Category Rotation D y Cancel Apply Help Location Select a location for the labels in relation to the chart elements Different chart types offer different locations Text Select one of the following text display formats m Value Displays the numeric value of each data element m Percent Displays the numeric value of each data element as a percentage of the whole Category Displays the row labels from the data sheet Value Percent Displays the numeric value and percentage of each data element Category Percent Displays the row labels from the data sheet and their percentages m Category Value Displays the row labels from the data sheet and their numeric values 175 Axes Symbols and Legends For stacked charts you can also select one of the following text display formats Summations Displays the cumulative values of the series as they climb or proceed along the bars Summations Percent Displays the cumulative values and the cumulative percentages of the columns and bars Category Summation Displays the category names and the cumulative values of the columns or bars Rotation Select the rotation angle of the text box 90 degrees reads top to bottom 270 degrees reads bottom to
40. a a e de A a aa 93 Scatter Charts cy der 3 da a e ee he eae ee es 94 Paired Intensity Scatter Charts 00 95 Intensity Scatter Charts o o 97 Polar Charts 03 a e a ed eee 98 Bubble Chiatts so este ar eae a 8 A 100 Ternary Chaltso s sen da be oe AS ee el a 101 Ternary Percent Charts 2 2 2 2 o e 102 7 Area Pie and Table Charts 105 Ated Charts dano ha a BR Pte tale Goh Grad bs 105 Spider and Radar Charts 2 o o o ee 107 viii Pie and Donut Charts e 109 Stacked Pie Charts o e e 112 Multiple Pie Charts o ooo o o 113 Table Chart s syi a IL oh ee oot tae 2 115 8 Contour and Vector Charts 117 Contour Fill Charts 2 ee eee 117 XYZ Contour Fill Charts o o 119 Contour Line ChartS o e e 120 XYZ Contour Line Charts o e 122 Vector Charts dolia aa aa Sk ek Be E 123 Radius Angle Vector Charts 0 ooo o 125 AY Vector Charts a deh a a wR ete ain 126 9 Statistical and Quality Control Charts 129 Histograms A a ee he 130 Pareto Charts tot es es ee ate A ge BL 131 Osive Charts esi 5 pda a Gh ee i Ge be hi Pe 132 BOX Charts 32 80 8 2 4 a Og 133 Survival Charts s koa a a a ale get 134 Quality Control Charts o o 136 XBar R and XBar S Charts 2 0 20000 136 Frac
41. based on the sum of all data values for all series selected Value Displays the error bar at a fixed numeric distance Enter a positive numeric value Percentage Displays the error bar as a fixed percentage based on the percentage times the data value Enter a percentage value Standard Errors Enter a value in the Number field to set the number of standard errors Within series displays the error bar in standard error units based only on the data for the individual series Pooled displays the error bar in standard error units based on the sum of data values for all series selected To Add Error Bars to a Chart Select the chart From the menus choose Chart Error Bars Select one or more series Select your options Click OK For more information on specific options click the Help button 209 Equations Error Bars and Curve Fits To Format Error Bars You can use the Format Object dialog box to change the appearance of the error bars Select the error bar From the menus choose Format object name Make any desired changes Click OK For more information on specific options click the Help button Curve Fits Curve fitting attempts to describe the data that you have plotted by fitting an equation to the data points The resulting curve is plotted with your data so that you can see how well the equation fits There are two classes of curve fits Equation curve fits assume
42. but places a copy of the object on the page of the second document If you duplicate an object 1t appears on the same chart canvas To Copy a Chart and Data If you copy a chart the paste function inserts a copy of the chart data into a new data sheet and places the chart on the active canvas Select the chart From the menus choose Edit Copy Tip You can also right click and choose Copy from the context menu or press Ctrl C To Copy a Chart without Copying the Data If you duplicate a chart the duplicate chart uses the same data sheet as the original chart and the duplicate appears slightly offset from the original chart Select the chart From the menus choose Edit Duplicate To Move Objects to a Different Page When you copy an object you can paste the object onto any page Dragging an object to a different document does not move the object but places a copy of the object on the page of the second document Select the object s 202 Chapter 13 From the menus choose Edit Cut Move to the other page From the menus choose Edit Paste Tip You can also right click and choose Cut or Paste from the context menu or press Ctrl X for Cut or Ctrl V for Paste To Move Objects on a Page Select the object Handles appear indicating that you have selected the image Drag the object to the new position Tip The following keyboard actions also help you to position charts
43. by Season Floating Bar and Column Charts Floating bar and column charts display ranges of data You specify the lowest and highest value for each bar The plotted bars float without being attached to the category axis For example you could display the average high and low temperatures for various cities 70 Chapter 4 Setting up your data Two columns of data are required for each data series the first column contains the starting value and the second column contains the ending value The order in which you enter values does not matter However if you are using the range to display positive or negative change you may want to use Show Values on the Chart menu to display the order in which the values were entered Row labels name each category column labels name each data series Because only the first label for each range appears on the legend you should label every second column Figure 4 5 Floating column chart Data for barcol BE C Anchorage Chicago January April July October floating Cell Label Label For Help press F1 M Anchorage A Chicago Miami 50 40 30 20 January April July October Average Temperatures by City 71 Bar and Column Charts Floating Stacked Bar and Column Charts A floating stacked bar or column chart specifies ranges of data so that each range is composed of parts of a total Setting up your data The first data c
44. chart Data for Document 1 HII Sf Ha Oeil k x YE Label A B Label Series 1 1 Category 1 2 Category 2 3 Category 3 4 Category 4 5 Category 5 Cell C 8 For Help press F1 120 100 Category 1 Category 2 Category 3 Category 4 Category 5 83 Line Step and Range Charts High Low Close Charts High low close charts show values that fluctuate within a given time period such as a day These charts plot the high the low and the final value close They are commonly used for market analysis and are also seen in investment publications High low close charts have an additional legend besides the series legend to indicate which side ofthe vertical line represents the opening value and which side represents the closing value Setting up your data Each series must have three columns of data representing the high low and close values respectively Each data sheet can contain more than one series of data at one time The default chart has a vertical line extending from the low to the high values and a horizontal line projecting to the right for the closing value Row labels are used to name each category To name the series enter a label in the first column of each series these labels appear in the legend Figure 5 5 High low close chart Data for line BE ra gt p line pared xy ine high low cl 4 Cell K 10 SEs ForHelp pressF1 84 Chapter 5 20
45. coordinates specified in the Data window in the third and fourth columns of the chart s data Radius and Angle The end point is determined from radius values and angle values in the third and fourth columns of the chart s data Chapter 9 Statistical and Quality Control Charts Statistical charts such as histograms provide another way of summarizing your data By reviewing the distribution of your data you have a better understanding of the data series than what you would get by looking at its average Quality control charts allow you to monitor processes such as manufacturing lines This chapter describes the following chart types Histogram charts Pareto charts Ogive charts Box charts Survival charts XBar R and XBar S charts Fraction defective p and number of defectives np charts Defects per unit u and number of defects c charts 129 130 Chapter 9 Histograms A histogram chart shows the occurrence frequency of ranges of values in your data The chart automatically divides your data into a set of equal ranges and plots the count total number of values for each range or bin After you create the chart you can redefine the bins using the Binning tab in the axis dialog boxes For example you could find out which age groups are more likely to purchase a product based on a taste test promotion Setting up your data Enter your data values into a single column If you select multiple columns of
46. corresponding cell in the destination column Syntax Avg two or more columns or numbers Examples Avg A B Avg 5 14 TAvg Function Writes the average of all of the cells in the source column s to the first cell of the destination column Syntax TAvg one or more columns or numbers Examples TAvg A B TAvg 5 14 21 43 Preparing the Data Diff Function Writes the difference between each source value and the one that follows it to the corresponding cell in the destination column Syntax Diff one column Examples Diff A Diff B Exp Function Writes the constant e 2 71828 to the power of each value in the source column to the corresponding cell in the destination column Syntax Exp one column or number Examples Exp A Exp 200 Fill Function Generates and writes data starting with the value time or date that you specify incrementing by the value that you specify to fill the number of cells that you specify in the destination column Optionally you can specify units such as random numbers or days of the week The permitted values for units are Sec Min Hr Day Wk Wkday Mon Yr and Rand Syntax Fill start value increment number of cells to fill units Examples Fill 0 5 10 Fill 0 100 10 Rand Fill Oct 31 93 2 10 Day Filter Function Evaluates values in the source column If a value fulfills the logical expression that you specify the value if true is output to its
47. data for both the base and overlay charts should be included on the same data sheet Figure 11 2 Stacked column chart with a line overlay Data for overlay A eS Pee D E Product amp Product B Product Product D Average stacked column floating stact 4 For Help press F1 164 Chapter 11 300 250 200 150 100 50 1stQ 2ndQ 3rd Q 4thQ Average Product D Product C Product B Product A Chapter 12 Axes Symbols and Legends Axes symbols and legends provide visual clues that allow you to interpret your charts and data values Customizing these chart elements can make your charts easier to understand You can also use the Show Values command to display additional detail in a chart such as exact values category groups and percentages There are two ways to customize these elements First you can modify the axis symbol or legend properties For example you can change the axis scale or tick increments Second you can format the appearance of the axis symbol or legend such as changing the color or line width of an item This chapter shows you how to modify axis symbol and legend properties and how to display values within a chart Types of Chart Axes Every chart has two or more axes Two dimensional charts typically have a value axis and a category axis each of which may have a secondary or overlay axis Three dimensiona
48. of the shadow Shadow direction Drag the preview square to set the direction of the shadow or enter horizontal and vertical values Text shadow color Click the color swatch and choose a color for the text shadow To Apply a Shadow If the toolbox is not visible from the menus choose View Drawing Toolbox Select the object Click the Shadow tool YA Tips m You can also select the Shadow tool by pressing D on your keyboard m You can also use the Shadows tab in the Format Object dialog box to apply a shadow to an object 188 Chapter 13 To Change the Shadow Style 4 Select the object with the shadow From the menus choose Format object name Click the Shadows tab Select the shadow type that you want Click the shadow foreground color swatch and choose a color from the palette Click the shadow background color swatch and choose a color from the palette Click the shadow fill swatch and choose a pattern fill from the palette Enter values in the Horizontal and Vertical text boxes to determine the size and offset of the shadow or drag the shadow in the thumbnail Click OK Format Object Text You can use the Text tab in the Format Object dialog box to change the properties of chart text or text objects 189 Working with Chart Objects Figure 13 5 Format Object dialog box Text tab Format Object x Colors Lines Shadows Text Spacing Bullets
49. on You can either embed an object which means that the object resides in the file to which you add it or you can link an object so that it is updated every time you change the source file To Create DeltaGraph Charts in Other Applications If you already have data selected when you create a DeltaGraph chart from within Excel the data are automatically linked to the DeltaGraph datasheet and selected making it easy to plot them as a chart Any changes you make to the data from within Excel are reflected in the DeltaGraph document one second later Inthe other application open the file to which you want to add the chart If you are working in Microsoft Excel select the data that you want to plot as a chart From the menus choose Insert Object On the Create New tab in the Object dialog box select DeltaGraph 5 Document from the Object Type list 255 256 Chapter 18 Click OK DeltaGraph s Chart Gallery Data window Chart window toolbars and menus appear If you are working in PowerPoint or Word you will have to add data to the Data window within the embedded document and then select them for the chart or DeltaGraph will create the chart using sample data When you are finished click any area outside of the DeltaGraph windows to return to the other application Tip You can also access the Chart Gallery by clicking the Chart Gallery tool on the Charting toolbar or by choosing DeltaGraph Chart from the
50. or objects m The arrow key moves the object one pixel m The Ctrl key plus the arrow key centers the object on the chart canvas m The Shift key plus the arrow key moves the object one grid increment To Group Objects Select the objects From the menus choose Format Grouping Group Tip You can also right click and choose Group from the context menu 203 Working with Chart Objects To Ungroup Objects Select the object group From the menus choose Format Grouping Ungroup Tip You can also right click and choose Ungroup from the context menu To Change the Order of Layered Objects To place an object underneath or on top of another object select the object and from the menus choose Format Order Send to Back or Bring to Front To adjust the position of an object within several layers of objects from the menus choose Format Order Send Backward or Bring Forward Tip You can also right click and choose the command from the context menu To Lock Objects To lock objects from the menus choose Format Locking Lock To unlock the objects for editing from the menus choose Format Locking Unlock 204 Chapter 13 To Flip Objects To flip an object 180 degrees select the object and from the menus choose Format Flip Vertical or Flip Tip You can also right click and choose the command from the context menu To Rotate Objects To rotate an object 90 degre
51. scatter chart and select Connect Data Points in the Options dialog box The line will connect the data points in the order in which they appear in the Data window 91 Line Step and Range Charts Figure 5 10 Paired XY line chart Data for line alx A B Nominal GNP per Capita 1210947 1253296 1494659 2134956 2596566 2981955 2870648 3151735 3509838 3823854 4460064 4860421 5142346 4531296 4171253 16 4 gt candlestick xy line paired xy lit 4 Cell F 15 For Help press F1 45 000 40 000 35 000 30 000 g E 25 000 5 20 000 a 15 000 10 000 5 000 0 0 1 000 000 2 000 000 3 000 000 4 000 000 5 000 000 6 000 00 Nominal GNP 92 Chapter 5 Time Line Charts A time line chart can display a project schedule time line or even a product comparison based on a predetermined scale For example you could map the product release history of a company Setting up your data A time line uses two columns per data series Enter the labels for your time line in the first column and the numbers or times in the second column You can create additional series on the same data sheet Once the time line is plotted you can select and reposition chart labels as a group or individually When you drag a category label to a new location the arm connecting it to the time line follows Figure 5 11 Time line chart Data for Document 1 BE San AEA
52. the menus choose Format Backgrounds Apply Drag and drop the Blank background onto the chart canvas Note You cannot delete the master background However you change the master background to white to create a blank background 230 Chapter 15 To Delete Backgrounds From the menus choose Format Backgrounds background name From the menus choose Edit Delete Background To Relink to the Master Background If you applied a different background to a canvas you can reset the canvas to use the master background Select a chart canvas From the menus choose Format Backgrounds Relink to Master Click Yes Chapter 16 Using Libraries to Store Charts and Images Libraries are container objects with the file extension br that you use to store images and charts You can use the images within libraries as pictographs which are images used to represent data For example you can apply the image of a dollar sign to the bars of a chart to represent revenue You can create a chart template by saving the chart in a library without its data This retains any formatting that you have applied to the chart When you want to use the template to create a chart you apply it to a canvas and then select the data that you want to use When you create or open a library file 1t is displayed in the Libraries window When you want to use a chart or image from the library in a document simply drag it fro
53. to clearly illustrate the percentage of revenue that is taken up by expenses you can create a column chart that displays your revenue for each product and then add a line chart overlay that displays each product s expenses Create the base chart You must select the data for the overlay chart at the same time that you select the data for the base chart From the menus choose Chart Overlay In the Overlay Chart area choose the type of chart that you want to plot over the base chart Choose whether to display the legend for the overlay chart separately from that of the base chart In the Series Selection area choose which series will be used to create the overlay chart You can add and remove series by double clicking them At least one series must be in both the overlay and base charts series lists Select Value axis if you want to add a value axis to the chart Select Category axis if you want to add a category axis to the chart Click OK 61 Creating Charts To Refresh Charts If you revise the data that is associated with a chart you must refresh the chart to reflect those changes From the menus choose Data Update Charts Tip You can also refresh charts by clicking the Update All Charts tool on the toolbar of the Data window To Add Chart Axis Titles Click the chart to make it active From the menus choose Chart Revise Data In the Select Data dialog box click Set Axis Titl
54. to ensure predictable results The EPS output in DeltaGraph supports such advanced output features as spot color separation over printing and strikeout Edit Colors You can use the Edit Colors dialog box to select and modify the colors in your document 245 Preparing Your Document for Printing Figure 17 1 Edit Colors dialog box Edit Colors El Color Set Scheme colors Color Model RGB Custom colors Choose Item to Edit Edit Color Red 100 0 Highlight Text cad ee Green 53533 Grid TidvAxis Blue 6 86 J Text Shadow E Chart Labels 2 Monitor Color working space Axis Titles E Canvas Title j J PANTONE Color one PANTONE Color Name None CMYK Loi soe REN OK Cancel Help Scheme colors Select to view or modify the colors associated with the current color scheme within the active document Custom colors Select to view or modify the colors in the custom palette Choose Item to Edit Displays the colors in the document and the objects in the document with which they are associated Click a swatch in the palette to select a color for editing or to associate an object with a new color Color Model Specifies the current color model You can choose from additive color models RGB and HSL and subtractive color models CMY and CMYK Additive color models create color by adding light and are generally used when an image is going to be viewed onscreen Subtractive color models creat
55. you launch DeltaGraph When you are moving items such as the Document Manager Libraries window toolbox or toolbars you can prevent them from docking by pressing Ctrl while you drag them To Minimize the Document Manager Click the arrow button at the top right corner of the Document Manager The Document Manager is minimized along the side of the screen To restore it click the arrow button again 259 260 Chapter 19 To Show or Hide the Document Manager From the menus choose View Document Manager Tip You can also close the Document Manager by clicking the x at its top right corner To Show or Hide Toolbars From the menus choose View Toolbars Select the toolbar that you want to show or hide A check mark means that the toolbar is displayed Tip You can also show or hide the toolbars by right clicking an empty portion of the main DeltaGraph window or any toolbar To Show or Hide the Toolbox From the menus choose View Drawing Toolbox Tip You can also close the toolbox by clicking the x at its top right corner To Show or Hide the Rulers and Grid From the menus choose View Rulers and Grid To show the rulers select Show rulers To show the grid select Show grid Click OK 261 Customizing the DeltaGraph Desktop To Show or Hide the Status Bar The status bar displays information about the menu and toolbar items that are under the mouse pointer
56. 0 180 160 140 120 100 80 60 40 20 1 Jan 8 Jan High Low Close Stock Prices Open High Low Close Charts Open high low close charts show values that fluctuate within a given time period such as a day These charts plot the starting value open the high the low and the final value close They are commonly used for market analysis and are also seen in investment publications Open high low close charts have an additional legend besides the series legend to indicate which side of the vertical line represents the opening value and which side represents the closing value Setting up your data Each series must have four columns of data representing the open high low and close values respectively Each data sheet can contain more than one series of data at one time The default chart has a vertical line extending from the low to the high values and a horizontal line projecting to the left for the opening value and one projecting to the right for the closing value Row labels are used to name each category To name the series enter a label in the first column of each series these labels appear in the legend Open high low close charts have an additional legend to indicate which side of the vertical line represents the opening value and which side represents the closing value 85 Line Step and Range Charts Figure 5 6 Open high low close chart
57. 2 173 symbols 170 171 ellipses 196 Encapsulated PostScript files 254 entering data 23 equations 205 error bars about 206 adding to a chart 208 configuring 207 formatting 209 Excel files breaking links with 22 copying data from 20 importing 16 18 linking to 22 Exponent function 43 exponential curve fitting 210 export file formats 2 Export Image dialog box 199 exporting charts and objects as graphics 200 data files 19 Encapsulated PostScript files eps 254 PostScript files prn 253 fill charts 117 119 Fill function 43 Filter function 43 flipping objects 204 floating charts bar charts 69 column charts 69 stacked bar charts 71 stacked column charts 71 fonts chart objects 188 data cells 33 text objects 188 footers 6 8 adding 6 editing content 10 formatting 11 repositioning 10 Format Cells dialog box 26 31 33 formatting about 26 arrows 184 axes 169 cell borders 36 charts 177 colors 177 currency data 30 date time data 30 error bars 209 labels 30 legends 173 lines 181 185 numeric data 30 31 objects 177 pictographs 234 placeholders 225 shadows 186 text 30 188 285 Formula Builder dialog box 39 formulas about 39 building 41 recalculating 41 fraction defective charts 140 Freehand tool 196 Frequencies function 44 functions about 42 Abs 42 Avg 42 custom 39 Diff 43 Exp 43 Fill 43 Filter 43 Freq 44 Fr
58. 251 refreshing 61 setting axis titles 61 templates 239 241 updating automatically 267 Circle tool 196 color about 243 cell background 36 displaying RGB profile colors 276 gamuts 243 management 243 palettes 221 249 PANTONE Color Matching System 250 profiles 243 247 248 250 separations 252 setting default profiles 276 Color tool 181 column charts 64 161 163 3 D charts 145 build up charts 72 floating charts 69 floating stacked charts 71 segmentation charts 67 stacked charts 65 stacked segmentation charts 68 XY charts 74 columns adding 24 labeling 38 39 removing 25 resizing 25 sorting by 38 transposing 25 combination charts 60 commercial presses 252 contour charts 117 119 122 3 D surface fill charts 155 283 3 D surface line charts 156 3 D wireframe charts 153 3 D XYZ surface fill charts 158 3 D XYZ surface line charts 159 contour fill charts 117 contour line charts 120 copying charts 201 257 data 20 objects 200 201 creating backgrounds 227 228 calculated data 41 chart templates 240 charts 55 58 60 charts from templates 241 documents 4 layouts 224 libraries 232 currency formatting data as 30 curve fits about 209 applying 211 configuring 210 reinitializing parameters 218 Curve tool 195 custom color palettes 247 248 249 curve fits 212 213 217 218 219 functions 39 data adding borders 36
59. If you want to use the default currency for your operating system select Use Current Language Default Keep in mind that this default may change if you open the document on another computer 30 Chapter 2 For Text Data Text data have no options in this dialog box To Format by Data Type DeltaGraph includes many types of preset formatting that you can apply to data depending on their type For example you can specify that numeric data display using scientific notation using fixed precision as percentages and so on Select the cell s whose data type and formatting you want to specify From the menus choose Data Format Cells In the Data Type group select Numeric Date Time Currency or Text Specify options for the data type as desired For information about specific options click the Help button Click OK Tip You can also access the Format Cells dialog box by clicking the Format Cells tool on the Data window toolbar or by right clicking any cell To Format Label Cells You can add special formatting such as backslashes line breaks and subscript characters to axis and data point labels as well as axis titles Click the label cell that you want to format 31 Preparing the Data Add any of the following before the data that you want to format For Type this Subscript text Superscript text Line breaks r Normal text Backslashes Null characters 0 Exampl
60. Insert menu To Add Linked Charts to Other Applications Linking is useful when you want to use the chart in several different places When you update the source document every linked instance of the chart updates automatically In the other application open the file to which you want to add the chart Inthe Windows Explorer select the DeltaGraph document that contains the chart From the menus choose Edit Copy Switch back to the other application From the menus choose Edit Paste Special In the Paste Special dialog box click Paste Link and select DeltaGraph 5 Document Object from the list Click OK 257 Using DeltaGraph Charts in Other Applications To Embed Charts in Other Applications In the other application open the file to which you want to add the chart In DeltaGraph open the document that contains the chart and select it From the menus choose Edit Copy Switch back to the other application From the menus choose Edit Paste Special In the Paste Special dialog box click Paste and select DeltaGraph 5 Document Object from the list Click OK Tip You can also drag and drop copies of DeltaGraph charts into other applications These charts are copies and will not be updated automatically if you modify the original chart To Modify Charts in Other Applications You can modify any embedded DeltaGraph object including data from w
61. Parameters Statistics Display Steps z pr Partial FEE Mora Estimates _v I Attempted parameter values Opn a o Saen Continue Cancel Help The Model controls let you set up a custom curve fit Independent Variable Type a name for the independent variable the model s predictor variable Parameters Enter the starting value for the model parameter for example m 1 Separate two or more parameters with semicolons Constants If desired enter the value s for the constant s in the formula for example b 5 214 Chapter 14 Formula Enter your curve fit formula You can type any name for the dependent variable and 1t must be followed by an equals sign Your formula must contain the independent variable and at least one parameter but it does not need to include a constant For example your formula could be Melting b m Temp Estimate Click to start the estimation process Reinitialize Parameters Click to update the initial values in the Parameters field using the final parameter values in the Statistics field Statistics Displays parameter estimates and model fit statistics Chi squared shows how well the curve fits the data and the smaller the number the better the fit R squared equals the proportion of the variability in the dependent variable that is explained by the independent variable the higher the number the better the fit DeltaGraph estimates parameter values usi
62. Red Rock Software Inc 10 West Broadway Suite 475 Salt Lake City Utah 84101 801 322 4322 http www redrocksw com DeltaGraph 5 User s Guide for Windows DeltaGraph DeltaGraph 5 User s Guide for Windows Copyright O 2004 by SPSS Inc and Red Rock Software Inc All rights reserved Printed in the United States of America No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise without the prior written permission of the publisher The SOFTWARE and documentation are provided with RESTRICTED RIGHTS Use duplication or disclosure by the Government is subject to restrictions as set forth in subdivision c 1 ii of The Rights in Technical Data and Computer Software clause at 52 227 7013 Contractor manufacturer is Red Rock Software Inc 10 West Broadway Suite 475 Salt Lake City Utah 84101 SPSS is a registered trademark and other product names are the trademarks of SPSS Inc for its proprietary com puter software No material describing such software may be produced or distributed without the written permis sion of the owners of the trademark and license rights in the software and the copyrights in the published materials PANTONE Colors displayed in the software application or in the user documentation may not match PAN TONE identified standards Consult current PANTONE Color Publications
63. To Print Data Click the Data window to make it active If you want to print selected data only select it now From the menus choose File Print Data Choose an option in the Print Range group Choose an option in the Print What drop down list Click OK To Preview a Print Job Because each chart page can span one or more printer pages it is a good idea to preview your print job to see where the page breaks occur From the menus choose File Print Preview Using a Service Bureau You can print your document directly to disk as a prn file which creates a PostScript file or as an eps file which creates an Encapsulated PostScript file You can then send the file to a service bureau for printing on a Linotronic device or other high resolution imagesetter that produces film directly from the file When you give the disk to the service bureau you should also provide them with a printout of the document even if it is only in grayscale so that they will have an idea of what you expect the document to look like 253 Preparing Your Document for Printing PANTONE Spot Colors If you are going to use a service bureau to print your document you can take advantage of the PANTONE Color Matching System An important advantage of using PANTONE spot colors is that you always know exactly how they will appear because each PANTONE spot color corresponds to a specific ink at the service bureau You can assign spec
64. Toolbox m Add graphics by importing images Click the Exit Background Mode tool on the Background toolbar to save your changes and return to the Chart window To Create Linked Backgrounds You can create an association between a background and a layout so that whenever you apply the layout the linked background is automatically applied to the chart canvas as well Create or edit an existing background From the menus choose View Layouts In the Layouts window double click the layout Click the Background tool on the Layout toolbar and choose a background Click the Exit Edit Mode tool on the Layouts window toolbar to return to apply mode To Apply Backgrounds Select the canvas From the menus choose Format Backgrounds Apply Background Select a background and click Apply 229 Standardizing Charts and Documents To Modify Backgrounds From the menus choose Format Backgrounds background name Do any of the following m Add or modify colors shadows or gradients using the Format Object dialog box m Add or modify drawing objects or text using the Drawing Toolbox m Import graphics Click the Exit Background Mode tool on the Background toolbar to save your changes and return to the Chart window To Remove Backgrounds from Chart Canvases From the menus choose Edit Delete Background Click Yes and the chart is linked to the master background or From
65. alignment within cells 35 century range 273 changing background color 36 creating calculations 41 displaying values in charts 173 174 175 editing 23 24 entering 23 exporting 19 filtering 43 formatting 26 30 31 Index generating 43 linking to Excel files 22 preparing for charting 13 printing 252 regenerating calculated data 41 removing columns 25 selecting 24 sorting 38 text properties 33 data sheets adding 15 entering data 23 removing 15 removing columns 25 renaming 16 Data window opening more than one 14 rolling up 15 showing or hiding 14 date time data 30 31 dBASE files importing 16 18 defaults cell text properties 273 chart labels 268 color profiles 250 Drawing Toolbox 279 perspective labels in 3 D charts 267 series appearance 267 symbols 271 text objects 280 tick marks 269 defects per unit charts 142 deleting library items 233 Difference function 43 disk printing files to 253 Document Manager 1 259 260 261 Document Setup dialog box 5 documents creating 4 opening 4 printing 251 producing 243 saving 4 284 Index templates 221 donut charts 109 drawing arrows 184 Bezier curves 194 195 circles 196 lines 194 195 196 ovals 196 polygons 197 rectangles 196 text 190 duplicating charts 201 objects 200 Edit Colors dialog box 244 editing axes 168 backgrounds 229 charts 177 data 24 layouts 224 legends 17
66. and size of arrowheads Figure 13 3 Format Object dialog box Arrows tab Format Object El Colors Lines Arrows Shadows Arrowhead at Tl Start Height a pts Width E pts DK Cancel Apply Hel Caneel to Helo End Select to display an arrowhead on the end of the line Start Select to display an arrowhead at the start of the line Height Enter a value for the arrowhead height Width Enter a value for the arrowhead width To Draw Arrows If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Arrow tool Pid To keep the tool selected double click it 185 Working with Chart Objects Click and drag to extend the arrow Release the mouse button to complete the arrow Tip You can also select the Arrow tool by pressing A on your keyboard To Change the Length of Lines and Arrows Click the line or arrow to select it Drag the handles to adjust the length To Change the Arrowhead Size From the menus choose Format object name Click the Arrows tab Enter new values in the Height and Width text boxes Click OK To Change the Color of the Arrowhead From the menus choose Format object name Click the Colors tab Click the foreground color swatch and choose a color from the palette Click OK 186 Chapter 13 To Change the Color of the Arrow Line From the menus choose Format object name
67. and Grid Settings The rulers appear along the left side and top of your Chart window You can use rulers to keep track of the actual size of your chart The ruler also displays the position of your cursor The grid overlay makes it easier to size and align objects If you enable the Snap to Grid feature each object that you add to the Chart window automatically aligns to the closest grid point From the menus choose View Rulers and Grid To show the rulers select Show rulers 263 Customizing the DeltaGraph Desktop To show the grid select Show grid Choose a unit of measurement in the Units drop down list Entera size for the grid squares in the Size text box This control uses the unit of measurement that you chose in the Unit drop down list If you want objects on the chart canvas to automatically snap to the nearest grid intersection select Snap to grid Click OK Preferences General You can use the General tab in the Preferences dialog box to set defaults such as start up behavior how many files are listed in the recently used file list and which DeltaGraph document you want to use as the basic template Figure 19 2 Preferences dialog box General tab Preferences El General Charts Data Profiles Libraries Drawing Toolbox New Documents Template DocumentT emplate dg5 Browse Rulers amp Grid IV Display start up dialog j Image Import
68. and Range Charts Candlestick Charts Candlestick charts show whether the open or close activity has increased or decreased within the bounds of the highs and lows for different items over a period of time They are commonly used for market analysis and are also seen in investment publications Candlestick charts have an additional legend besides the series legend to indicate which color is an increasing value closing value higher than opening value and which color is a decreasing value closing value lower than opening value Setting up your data Each series must have four columns of data representing open high low and close values respectively The default chart has a vertical line or wick extending from the low to the high values a box extends from the open value to the close value Each data sheet can contain more than one series of data at one time Row labels are used to name each category To name the series enter a label in the first column of each series these labels appear in the legend Figure 5 8 Candlestick chart Data for line BE paired xy 4 Cell J 7 For Help press F1 88 Chapter 5 Company A Company B Increase Decrease Day 1 Day 2 Day 3 Candlestick Chart XY Line Charts XY line charts show the relationship between data points from one or more data series in which each point has the same x coordinate and a unique y coordinate A line connects each data point to the nex
69. and removing columns and rows m Transposing columns and rows m Renaming data sheets m Formatting data types Note If you have your data linked to an Excel file any changes that you make to the data in the Data window will be lost the next time you open the document and its contents are synchronized with the source file If you want to make changes to the data within DeltaGraph consider breaking the link with the Excel file first 24 Chapter 2 To Select Data You can select data in DeltaGraph just as you would in any standard spreadsheet To select a Cell Row or column Range of cells Range of rows Range of columns Data sheet Do this Click the cell Click the header of the row or column Click the first cell of the range and then press Shift while you click the last cell If the cells are not adjacent press Ctrl while clicking additional cells Click the header of the first row and then press Shift while you click the header of the last row If the rows are not adjacent press Ctrl while clicking additional rows Click the header of the first column and then press Shift while you click the header of the last column If the columns are not adjacent press Ctrl while clicking additional columns Choose Select All from the Edit menu or click the Select All tool at the top left corner of the data grid Tip You can also select a range of data by clicking and dragging across the data cells To M
70. and warning limits show which data values fall outside of the control range The upper and lower warning limits represent the values that are two standard deviations or two sigmas away from the mean The upper and lower control limits represent the values that are three standard deviations or three sigmas away from the mean The second chart drawn is the R or the s chart The R chart is the default display To display an s chart change the chart type to Standard Deviation S in the chart options The R chart plots the difference between the high and low values within each subgroup The mean line represents the mean of the between group variance The s chart plots the standard deviation within the subgroups The upper and lower warning 137 Statistical and Quality Control Charts limits represent the values that are two standard deviations or two sigmas away from the mean The upper and lower control limits represent the values that are three standard deviations or three sigmas away from the mean Setting up your data Each row represents a subgroup or lot number Each column represents the time each measurement was taken or a part within the lot To label your data enter your time or part sample in the label column Enter your lot or subgroup numbers in the label row Figure 9 6 XBar chart with XBar R chart Data for stat BE Bars np pac Cell 1 11 For Help press F1 138 Chapter 9 21 5 21
71. ant for your overlay chart You can also choose whether to place the overlay on the existing axes or create a new axis Bar and Column Charts with Line Overlays A column with line overlay chart is simply a column chart with a line chart superimposed onto it For example you could plot high and low temperatures with average rainfall as an overlay Setting up your data Each row of data corresponds to one set of bars for a given category Each column of data corresponds to a data series Row labels are used to name each category and column labels are used to name each data series These labels appear in the legend The data for both the base and overlay charts should be included on the same data sheet 161 162 Chapter 11 Figure 11 1 Column with line overlay chart Data for overlay BE Low Mon Tues Weds Thurs Fri 163 Combination Charts Stacked Bar and Column Charts with Line Overlay Stacked bar and column charts can have line overlays A line overlay usually shows the trend of one or more items over a period of time For example you could display quarterly expenses with average expenses as an overlay Setting up your data Each row of data corresponds to a single segmented bar or column in the chart category Each series of data corresponds to a segment of a bar Row labels are used to name each category and column labels are used to name each data series These labels appear in the legend The
72. art category Tables Select to show all subtypes in the table chart category Contours Select to show all subtypes in the contour chart category Statistical Select to show all subtypes in the statistical chart category Vectors Select to show all subtypes in the vector chart category The Source group lets you choose which charts to offer in this dialog box You can choose whether to display charts from the base chart list the standard library custom libraries or any combination of these Base charts Select to view the charts in the base chart list Custom Select to view the charts from all libraries that are currently open Custom Libraries Displays all libraries that are currently open Open Library Click to access the Open dialog box which you can use to select and open additional chart libraries The Chart Options group controls how the new chart is plotted in the Chart window for example you can choose whether you want DeltaGraph to automatically position the new chart on the page or whether you want to place and size it yourself Plot Chart On Specifies the chart canvas on which the new chart is placed Auto plot Select if you want DeltaGraph to automatically size and position the chart in the Chart window Use all data Select to create a chart using all of the data in the active worksheet Deselect this check box if you have more than one chart s worth of data on a single data sheet 58 Chapter 3
73. as 221 changing 228 creating 227 deleting 229 230 editing 229 exporting 222 hiding 227 linking 221 228 230 master 221 showing 227 backslash characters 30 bar charts 64 161 163 build up charts 72 floating charts 69 floating stacked charts 71 segmentation charts 67 stacked charts 65 stacked segmentation charts 68 Bezier Curve tool 194 195 binning 44 borders 36 282 Index bounding specs 44 box plots 133 breaking links with Excel files 22 bubble charts 100 build up charts 72 bulleted lists 192 c charts 142 calculated data about 39 creating 41 recalculating 41 candlestick charts 87 canvas adding headers or footers 6 backgrounds 227 228 repositioning headers or footers 10 size 6 categories displaying in charts 173 174 175 cells adding borders 36 alignment of data 35 changing background color 36 editing contents 24 formatting 26 removing empty 47 setting default text properties 273 Chart Gallery 56 58 Chart Overlay dialog box 59 Chart Wizard 53 54 55 charts background images 237 combination 60 copying 200 201 creating 55 58 60 255 256 creating from template 241 creating templates 240 curve fits 211 data values 173 174 175 duplicating 201 embedded 257 error bars 208 exporting as graphics 200 formatting 177 188 modifying lines 181 new types 2 overlay 60 positioning OLE charts 258 preparing data for 13 printing
74. atter chart Data for Document 1 __ BE aanlal B E E ES E Label Y2 Point 2 Point 3 Point 4 Point 5 Cell G 8 For Help press F1 mx x2 x3 0 10 20 30 40 50 60 Scatter Charts A scatter chart shows the relationship between data points from one or more data series in which each point has the same x coordinate and a unique y coordinate For example a catalog order company could plot quarterly purchases by sales cost for new repeat and valued customers Setting up your data Each data series uses the same x coordinates which are contained in the first column The second and following columns contain the y coordinates To 95 Scatter Charts label each data series of a scatter chart enter labels over each column of y coordinates Because the scatter chart uses values on both axes there are no category axis labels Figure 6 2 Scatter chart Data for Document 1 10 28 43 58 Data 8 Cell G 19 For Help press F1 Point 1 Point 2 Point 3 Point 4 Point 5 a Fea Data 6 Data 7 14 12 10 8 6 4 2 0 0 10 20 30 40 50 60 Paired Intensity Scatter Charts mY O v A Y3 A paired intensity scatter chart is a paired scatter chart in which each point is colored or shaded along a spectrum to show its value on a third z value For example a company could plot the cost of each sa
75. ave Enter a name for the color scheme in the File Name text box and click Save Click OK Tip You can also access the Edit Colors dialog box by double clicking Scheme Colors or Custom Colors on the Documents tab in the Document Manager To Load a Custom Color Scheme From the menus choose Edit Color Palette Click Load In the Load Palette File dialog box browse to the location of the dpl file 250 Chapter 17 Select the file and click Open Click OK Tip You can also access the Edit Colors dialog box by double clicking Scheme Colors or Custom Colors on the Documents tab in the Document Manager To Select PANTONE Colors 4 From the menus choose Edit Color Palette In the Color Set group of the Edit Colors dialog box select Scheme colors or Custom colors In the Choose Item to Edit area click the swatch to which you want to assign a PANTONE color Click PANTONE Colors Use the Color Picker dialog box to choose a color Click OK to close the Color Picker dialog box Click OK Tip You can also access the Edit Colors dialog box by double clicking Scheme Colors or Custom Colors on the Documents tab in the Document Manager To Set Up Color Profiles From the menus choose Edit Preferences Click the Profiles tab 251 Preparing Your Document for Printing In the Monitor Profile drop down list choose a profile This affe
76. catter chart uses values on both axes there are no category axis labels Figure 6 4 Intensity scatter chart Data for Document 1 La fx Point 1 Point 2 10 Point 3 28 Point 4 43 Point 5 58 F lt gt 2 Data 3 Data 10 Data 11 Cell G 4 For Help press F1 98 Chapter 6 14 Mv 12 O y 10 8 6 4 2 0 0 10 20 30 40 50 60 Polar Charts A polar chart shows the relationship between an angle measured in degrees and some other quantity for example volume versus direction of the listener measured at some fixed distance from a loudspeaker the strain at a particular point on a cam shaft as it rotates through 360 degrees or the quantity of measured airborne contaminants near a pollution source versus wind direction This chart can also be used to show cyclical trends by scaling time into degrees For example a catalog order company could examine how many calls come in each hour Setting up your data The polar chart requires two columns of data for each data series The first column of data corresponds to the distance from the center of the chart the radius The second column corresponds to the number of degrees on the perimeter of the chart the angle 99 Figure 6 5 Polar chart Data for scatter Scatter Charts 1st Hour 2nd Hour Cell H 12 For Help press F1 1st Hour 2nd Hour 100 Chapter 6 Bubble Charts Bubble chart
77. ce Attendance 73 Bar and Column Charts Stacked Build Up Charts Stacked build up charts plot several categories that build up to a total Stacked build up charts are typically used to show a progression of values that make up a total Each category s bar starts where the previous one leaves off For example you might plot a starting purchasing figure for supplies of wood concrete and steel You then increase it monthly with each month s purchases appearing in a separate category The final category s ending value would be the cumulative purchasing figure You could also plot a conference across several days and by seminar Setting up your data Data rows correspond to categories while data columns correspond to series You may have multiple series Figure 4 8 Stacked build up chart Monday Tuesday For Help press F1 Cell F 5 74 Chapter 4 5000 03 00 00 PM 4500 01 00 00 PM 4000 3500 10 00 00 AM 3000 08 00 00 AM 2500 2000 1500 1000 500 Monday Tuesday Wednesday Conference Attendance by Session XY Column Charts An XY column chart also known as a Marimekko chart shows the relationship between data points from one or more data series Each x coordinate is paired with a corresponding y coordinate Drop lines from the data points to the x axis are added to create columns representing changes in values and diffe
78. click it Tips m Press the N key as a shortcut for the Gradient Fill tool m You can also use the Format Object dialog box to apply a gradient fill To Change a Gradient Fill Style 6 gt gt UM From the menus choose Format object name Click the Colors tab Click the background color swatch and choose a color from the palette Click the foreground color swatch and choose a color from the palette Select Gradient fill Click the thumbnail to set a direction for the gradient In the Style drop down list choose a gradient type In the Steps text box enter the number of shades you want between the foreground and background colors Click OK 180 Chapter 13 To Apply a Pattern Fill If the toolbox is not visible from the menus choose View Drawing Toolbox Select the object Click the Object Fill Pattern tool lt To keep the tool selected double click it To Change the Default Pattern Fill From the menus choose Format object name Click the Colors tab Choose a background color Choose a foreground color Choose a pattern style Click OK To Change the Object Fill Pattern If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Selection tool and select the object Click the Object Fill Pattern tool To keep the tool selected double click it Choose a pattern from the palette 181 Working wit
79. corresponding cell in the destination column Optionally you can also specify a value to output if the expression is false The value to output can refer to a column or it can be a constant value Syntax Filter logical expression value if true value if false Examples Filter A lt 5 A Filter A gt 10 1 0 44 Chapter 2 In the first example all values in column A that are less than 5 are output to their corresponding cells in the destination column In the second example a 1 is output for all values in column A that are greater than 10 while a 0 is output for all values that are not greater than 10 Freq Function Counts the number of times the source value appears in the source column and then lists the frequency of each source value in the destination column Optionally you can define bins or categories of numbers by referring to an additional column containing bounding specs In this case the source column is compared to the bounding specs and the number of cases that fall within each bin is output If you use bounding specs the default rounding flag is less than parameter is 0 To specify a rounding flag of less than or equal to use 1 for the rounding flag parameter Syntax Freq one column one column for bounding spec rounding flag of O or 1 Examples Freq A Freq A B In the first example the frequency of each value in column A is listed in the corresponding cell in the destination column In the sec
80. cs on the chart canvas You can apply a layout to a canvas with or without elements When you apply a layout to a chart canvas that already contains elements any elements that match the placeholders are snapped to the placeholder s size and position and take on any properties assigned to the placeholder When you apply a layout to a blank canvas the layout placeholders appear on the canvas You can add the element simply by double clicking the placeholder To Show or Hide the Layouts Window From the menus choose View Layouts 224 Chapter 15 To Create Layouts If the Layouts window is not visible from the menus choose View Layouts Click the New Layout tool on the Layouts window toolbar Add any of the following placeholders by clicking the appropriate tool on the Layouts window toolbar Chart Title Text and or Graphics Click and drag to size the placeholder Click the Exit Edit Mode tool on the Layouts window toolbar to return to apply mode To Modify Layouts gt If the Layouts window is not visible from the menus choose View Layouts Select a layout Click the Edit Layout tool on the Layouts window toolbar Change the placeholders as desired Click the Exit Edit Mode tool on the Layouts window toolbar to return to apply mode Tip You can also double click or right click the layout and select Edit To Duplicate Layouts If the Layouts window is
81. ct it Update Now Click to reload the data for the selected link Open Source Click to open the source file in its native application Change Source Click to open the Change Source dialog box which you can use to change the source file of the link Break Link Click to break the selected link The data remain in your DeltaGraph document but are no longer connected to the external file The Update area controls whether the linked data update automatically when you make changes to the source file or whether the data are updated only when you open the DeltaGraph document Automatic Selectif you want the linked data to update automatically when you modify the source file If you have the DeltaGraph document open when you modify the source 22 Chapter 2 file the linked data update in one second If DeltaGraph is not running when you modify the source file the linked data update the next time you open the document Manual Select if you want the linked data to update only when you open the DeltaGraph document or click Update Now To Link to Data in Excel Files You can link the data from an Excel file to your DeltaGraph document By default the linked data are set to update automatically which means they reflect any changes you make to the source file within one second If you prefer you can set the data so that changes to the source are not reflected until you manually update them With DeltaGraph running open the file in E
82. cts the appearance of colors onscreen also known as your working color space In the RGB Profile drop down list choose a profile If you have selected Include Color Profiles on Export in the Image Files group this will affect how your colors are represented when you export charts and objects as graphics In the Printer Profile drop down list choose a profile This affects how your colors are printed If you have selected Include Color Profiles on Export in the Image Files group then all of the colors within any eps file that you create are calibrated to the CMYK profile that you select Click OK Preparing a Print Job DeltaGraph supports a wide variety of printing technologies making 1t easy for you to print your charts and data sheets on virtually any printer You can also prepare your print job for production on a commercial press Note Different color devices reproduce color differently If you are going to use a color printer you should select a color profile that is calibrated to your output device on the Profiles tab of the Preferences dialog box This helps to ensure that the colors you see onscreen will match the colors of the printed document To Print Charts and Objects Click the Chart window to make it active From the menus choose File Print Canvas Choose an option in the Print Range group Choose an option in the Print What drop down list Click OK 252 Chapter 17
83. data the columns are treated as one series Any labels for the categories or series are ignored Histogram bin labels take the place of category labels Figure 9 1 Histogram chart Data for stat BE lt 0 5 15 25 35 45 55 65 75 gt 80 Age Groups 4 a histogram box plot survival Cell 1 15 For Help press F1 131 Statistical and Quality Control Charts Pareto Charts A Pareto chart shows the occurrence frequency of ranges of values in your data sorted in descending order The chart automatically divides your data into a set of equal ranges and plots the count total number of values for each range or bin After you create the chart you can redefine the bins using the Binning tab in the axis dialog boxes For example you could find out which age groups are more likely to purchase a product based on a taste test promotion A Pareto chart highlights the most important age groups Setting up your data Enter your data values into a single column If you select multiple columns of data the columns are treated as one series Any labels for the categories or series are ignored Pareto bin labels take the place of category labels Figure 9 2 Pareto chart Data for stat mE 25 45 55 65 75 lt 0 5 15 gt 80 Age Groups Fe gt pacto Bax plat survival H 16 For Help press F1 132 Chapter 9 Ogive Char
84. dent indents the first line of the paragraph A hanging indent indents all the text under the first line of the paragraph Double click the text box This replaces the canvas rulers with text box rulers 192 Chapter 13 Do one of the following m Click and drag the indent marker to the right of the left margin to set a first line indent m Click and drag the indent marker to the left of the left margin to set a hanging indent Click outside the text box to close the edit field To Set Tab Stops Double click the text box This replaces the canvas rulers with text box rulers Select a tab type by clicking the tab aid in the left hand corner of the canvas frame Click in the ruler to set the tab stop Click outside the text box to close the edit field Tip You can also right click a ruler to set a tab stop Format Object Bullets You can use the Bullets tab in the Format Object dialog box to create bulleted lists and to change the appearance of the bullets Create bulleted list from text Select to place bullets in front of paragraphs Font Choose a font Bullet Choose a bullet style Size Enter a value to set the point size of the bullets Color Choose a color for the bullet To Format Text as a Bulleted List Select the text 193 Working with Chart Objects From the menus choose Format object name Click the Bullets tab Select Create bulleted list from selected text C
85. drawn at the same length Row labels name each category on the y axis Column labels name each series on the x axis 124 Chapter 8 Figure 8 5 Vector chart Data for contvect BE A B E 08 00AM 12 00PM 05 00PM Cell F 5 For Help press F1 INUM y A Day 1 A Day 2 Day 3 08 00 AM 12 00 PM 05 00 PM Wind Direction 125 Contour and Vector Charts Radius Angle Vector Charts A radius angle vector R A vector chart shows direction such as airflow using vectors arrows over a gridded area The length of the vectors varies according to the data For example you could plot wind direction and speed Setting up your data Each data series requires at least two columns of data The first column represents the radius or length of each vector and the second column represents the angle of the vector For the angle enter a degree value Values outside of the 0 to 360 range are supported If the value is greater than 360 360 is subtracted from the value If the value is less than 0 360 is added to the value Figure 8 6 Radius angle vector chart Data for contvect BE A B C D E speed O8 004M speed 12 00PM speed 05 00PM For Help pressF1 e a MU eens h Cell 4 4 126 Chapter 8 Day 1 Day 2 Day 3 Wind Direction and Speed XY Vector Charts An XY vector chart displays a direction such as airflow using vectors and a magn
86. e Each color device used in the production of your document such as a monitor or printer has a specific range of colors that it can reproduce This range is known as a color gamut and is dependent on a number of things such as the color model that the device uses and even the manufacturer and age of the equipment The gamut of your monitor which is based 243 244 Chapter 17 on the RGB color model will be different from the gamut of your printer which is usually based on the CMYK color model To ensure that your colors are accurately reproduced you need to account for the differences between the color spaces of each device You can do this by setting up a color profile and identifying any colors in your document that fall outside of the color gamut of any device you can then map those colors to others that the device can reproduce Color profiles help to control how the different color devices communicate color information Some file formats such as jpg png tif pct qtf and eps support embedded color profiles which means that the information travels with the file when you export it This helps to ensure that the colors you see in DeltaGraph match the colors that come out of your printer and also that the colors will be accurately reproduced on other display devices Using PANTONE Colors If you are going to send your document to a service bureau you can take advantage of the PANTONE Color Matching System which helps
87. e If you want your label to appear as E mc you would type E O mc 2 To Treat Date Time or Numeric Data as Text You can specify that date or numeric data should be treated by DeltaGraph as text For example if you want to use the custom date format 12 18 2001 you can prevent it from being reformatted to one of the set date formats by specifying it as text Bear in mind that once you format numeric or date data as text these data can be used only as labels Double click the cell that contains the numeric data Press Home Type an apostrophe at the beginning of the string gt Press Enter Format Cells Text You can use the Text tab in the Format Cells dialog box to specify the font name size style and color for any type of data in your cells 32 Chapter 2 Figure 2 8 Format Cells Text tab Format Cells x Data Type Text Appearance Font Font Style Tahoma Bold T SymbolProp BT a Regular m System T System APL Special T System VT Special l Lg Tahomal sl A Taobinhdhd m Effects I Strikeout T Underline Color Script Westem y Example e Company Cancel Apply Help The Font list controls which font name style and size are applied to the contents of the cell Font Specifies the name of the current font Font Style Specifies the formatting of the font such as italic or bold Size Specifies the point si
88. e Chart Wizard which walks you through the process of creating charts the Document Manager which provides Explorer type control over the different elements in your document and the Data window which lets you view your data and charts simultaneously System Requirements Processor Pentium II processor or later Operating System Microsoft Windows 98 2000 or XP Memory 32MB RAM or more Drives Internal hard drive with 20MB of free space Display 256 color monitor or higher If you are not sure whether your computer meets these minimum requirements check the User s Manual that came with your system to find out how to determine its capabilities iii Technical Support Register your copy of DeltaGraph at www redrocksw com and enjoy full technical support and notification of software updates For 24 hour support visit our support site at http support redrocksw com For email support send your question to dgsupport redrocksw com For phone support between 9 00 a m and 5 00 p m MST call 801 363 2485 For sales call 888 689 3038 Contents 1 Welcome to DeltaGraph 5 1 What s New in DeltaGraph 5 0 ooo 1 New Chart Types s es ce ice e a de ER E a e 2 Setting Up Saving and Exporting Documents 2 To Create Documents e ee 4 To Open Documents 4 To Save Documents o e e 4 Document Setup 5 To Set
89. e Chart Wizard contains a screen for each of the major stages in chart creation which ensures that you won t miss a stage and helps you to become more familiar with the process Document Manager The new Document Manager offers Explorer like navigation and control over the elements in your document The Documents tab displays all of the charts and other objects on the chart canvases of all open documents and the Data tab displays information about any data that you have imported or entered Data window The Data window replaces the Data View of previous versions The Data window is a separate window that can contain multiple data sheets which makes 1t possible for you to view and work on your charts and data simultaneously 2 Chapter 1 Chart window The Chart window shows individual chart canvases and the charts and other objects they contain You can create and edit charts graphics and text objects in this window New Chart Types DeltaGraph 5 offers the following new base charts Floating stacked bar chart Floating stacked column chart Intensity scatter chart Paired intensity scatter chart Volume open high low close chart In addition DeltaGraph 5 offers these new overlay charts Bar chart with line overlay Floating stacked bar chart with line overlay Floating stacked column chart with line overlay Stacked bar chart with line overlay Stacked column chart with line overlay Floating stacked bar chart with stacked ba
90. e color by absorbing some colors and reflecting others and are generally used by printers and other devices that produce hard copies of documents 246 Chapter 17 The Edit Color group lets you modify the selected color by adjusting its components The available options depend on the color model you have chosen For RGB colors m Red Specifies the percentage of red in the selected RGB color m Green Specifies the percentage of green in the selected RGB color m Blue Specifies the percentage of blue in the selected RGB color For CMY and CMYK colors m Cyan Specifies the percentage of cyan ink in the selected CMY or CMYK color m Magenta Specifies the percentage of magenta ink in the selected CMY or CMYK color m Yellow Specifies the percentage of yellow ink in the selected CMY or CMYK color m Black Specifies the percentage of black ink in the selected CMYK color For HSL colors m Hue Displays the hue of the selected HSL color You can choose a different hue using the arrow buttons Saturation Displays the intensity of the selected HSL color If you set the saturation to 0 the color will appear as gray If you set the saturation to 100 the color will appear intense m Lightness Displays the lightness of the color If you set the lightness to 0 the color will appear as black If you set the lightness to 100 the color will appear as white Monitor Color working space Displays the selected color as i
91. e points The third column contains the z coordinates or legend You are limited to 32 767 data points when creating an XYZ contour fill chart Labels are not used in an XYZ contour fill chart Figure 8 2 XYZ contour fill chart Stress 11 4 gt fi contour fill xyz contour fill Cell 6 10 For Help press F1 120 Chapter 8 Metal Fatigue Stress a 500 450 400 350 300 250 200 150 100 50 Y coordinates X coordinates Contour Line Charts A contour line chart shows surface variation based on two sets of evenly spaced values such as latitude and longitude at 10 intervals and a unique number such as elevation at a given point The values are shown as a variation in line contours For example you could compare which lubricants and which amounts work best to reduce friction Setting up your data Contour line charts require at least two columns and two rows of data The y axis shows the category and the x axis shows the series Each row of data corresponds to a category Each column of data corresponds to a series Row labels name each category on the y axis Column labels name each series on the x axis 121 Contour and Vector Charts Figure 8 3 Contour line chart Cell 4 11 For Help press F1 Force 1 Lubricant A Lubricant B Lubricant C Lubricant D 122 Chapter 8 XYZ Contour Line Charts An XYZ contour line chart shows var
92. e was a trend in the election polls for various candidates T11 78 Chapter 5 Setting up your data Each series of data corresponds to one line in the chart You can have more than one series per data sheet The y axis shows values the x axis shows categories Row labels are used to name each category Column labels are used to name each data series these labels appear in the legend Figure 5 1 Line chart Data for line fx Cell 1 6 For Help press F1 PEN E Candidate A Candidate B Candidate C Candidate D Mon Tues Weds Thurs Fri 79 Line Step and Range Charts Step Charts Step charts are the same as line charts except that they use steps rather than sloped lines to connect points in a series Setting up your data Each column of data corresponds to one series of steps a data series on the chart You can have more than one series per data sheet The y axis shows values the x axis shows categories Row labels are used to name each category Column labels are used to name each data series these labels appear in the legend Figure 5 2 Step chart Data for line BE Cell J 6 For Help press F1 80 Chapter 5 60 Candidate A 50 Candidate B Candidate C 40 Candidate D 30 20 Mon Tues Weds Thurs Fri Range Charts Range charts show the highs and lows of an item as well as the midpoints between the two You
93. ed images this profile will match the selected RGB profile 215 Customizing the DeltaGraph Desktop Printer Profile Select a device profile to describe the target device for exporting eps files If you choose to embed profiles within exported images DeltaGraph also embeds the CMYK profile within the image file Rendering Intent Select a color rendering intent for displaying printing and exporting files A color management model maps colors from one device s color space to another according to a rendering intent The rendering intent determines how the CMM maps colors The four rendering intents are absolute colorimetric perceptual relative colorimetric and saturation Absolute Colorimetric Select to create the closest absolute match to the onscreen colors If you have an image with a blue white color the printer will print a light blue in the area rather than leave the spot blank to let the white paper show through This rendering intent makes no changes to the white point or black point that would affect brightness Relative Colorimetric To create the closest match to the onscreen colors select relative colorimetric If you have an image with a blue white color the printer will leave the spot blank to let the white paper show through When a color in the current color space is out of gamut in the target color space this rendering intent maps the color to the closest possible color in the target color space Saturati
94. el function in both spelling and number Compare the chi squared error values with the chi square value Estimate Reinitialize Parameter cycles are not necessary if the Stop Below value adequately describes your requirement for terminating the iteration process 217 Equations Error Bars and Curve Fits m Curve fits may not always return expected results In the process of iterating the general method does not always converge to what you would get with the same formula chosen from the standard curve fit types It may not converge to what looks like the best answer It does not necessarily converge to the smallest possible chi squared value in fact it does not necessarily converge at all If it picks a value for a parameter that produces undefined results it may not be able to improve upon the solution from that point m All curve fits depend on the data values supplied the formula and the initial values of the parameters Changing the data and initial values of parameters can make a big difference in the final result To Create a Custom Curve gt You can name and save your curve fits as you would any other file Select the chart From the menus choose Chart Curve Fit Select the data series to which the curve fit will apply For the curve fit type select the Custom function Click Define at the bottom of the function list In the Custom Curve Fit dialog box enter a name for the independent variable
95. eqL 44 Ln 45 Log 45 Median 45 Mn 46 Mod 46 Mx 46 RSum 47 Smooth 47 Sqrt 47 Squash 47 Std 48 TAvg 42 TMedian 46 trigonometric 48 TStd 48 ZScore 49 gamuts color 243 generating calculated data 41 data with the Fill function 43 Gradient tool 179 graphic file formats 2 grids 261 262 Index setting defaults 265 grouping objects 202 hard returns 30 headers and footers 6 8 adding 6 editing content 10 formatting 11 repositioning 10 hiding 261 backgrounds 227 Document Manager 260 layouts 223 placeholders 226 rulers 260 toolbars 260 toolbox 260 high low charts 81 close charts 83 open close charts 84 volume open close charts 85 histogram charts 130 131 132 Image dialog box 198 images exporting 200 importing 199 importing data files 16 18 graphic objects 199 images 199 layouts 222 indents 191 192 inserting image onto chart canvas 233 images in a library 233 intensity charts 95 97 introduction to DeltaGraph 1 labels 286 Index about 38 adding line breaks 30 adding to columns 39 backslashes in 30 null characters 30 setting defaults 268 subscript 30 superscript 30 layering objects 203 layouts 221 about 223 applying 226 creating 224 deleting 226 227 duplicating 224 editing 224 exporting 222 hiding 223 importing 222 placeholders 225 226 removing 227 renaming 225 showing 223 legend
96. es Enter axis titles into the Set Axis Titles dialog box or specify the cells to be used as titles Click OK To Change a Chart s Data Range From the menus choose Chart Revise Data Select a new range of data in the Data window In the Select Data dialog box click Plot Chart Chapter 4 Bar and Column Charts Bar and column charts summarize data so that you can instantly draw conclusions and make decisions For example you can create a column chart to show revenue for several products or to show the amount of research and development that a product will require This chapter describes the following chart types Bar and column charts Stacked bar and column charts Bar and column segmentation charts Stacked bar and column segmentation charts Floating bar and column charts Floating stacked bar and column charts Build up charts Stacked build up charts XY column charts 63 64 Chapter 4 Bar and Column Charts A bar or column chart compares one item to another or compares the same or different items over a period of time Bar or column charts effectively show dramatic changes from one category to another For example a sportscaster could display the number of home runs that a baseball player hits each year Setting up your data Each row of data corresponds to one set of columns for a given category Each column of data corresponds to a data series Each column within a given category
97. es Open the library that contains the template Drag the template from the Libraries window onto the chart canvas Inthe Data window select the data that you want to use to plot the chart Inthe Select Data dialog box click Plot Chart To Add Chart Templates to the Chart Gallery From the menus choose Chart Gallery Select Custom to enable the Open Library button Click Open Library Select the library that contains the chart template Note All chart templates in an open library automatically appear in the Chart Gallery Chapter 17 Preparing Your Document for Printing DeltaGraph supports a wide variety of printing technologies including PostScript and GDI You can print your document on a printer attached to your computer or local area network or you can prepare it for a service bureau for high end production This chapter shows you how to m Manage the color in your document so that the colors of the printed document will match what you see onscreen Prepare your document to take to a service bureau Print your document Working with Color Color is an important part of your document Whether you are going to print your document or display it onscreen the colors used and how they appear can impact the effectiveness of your charts Color Calibration Without color management the colors that you see on your monitor may not match the colors of the printed document or exported image fil
98. es to the right or the left select the object and from the menus choose Format Rotate Right or Left To rotate an object to a specified angle select the object and from the menus choose Format Rotate Angle Tip You can also right click and choose the command from the context menu To Align Objects Select the objects that you want to align The first object that you select serves as the reference point for the alignment commands From the menus choose Format Align Left Center Right Top Middle Bottom or To Grid Tip You can also right click and choose the command from the context menu Chapter 14 Equations Error Bars and Curve Fits With equations error bars and curve fits you can insert additional technical details into your charts You can add equations and formulas for reference and you can add error bars to illustrate several statistical measurements Also you can add curve fits to display an equation that most closely models or fits your data This chapter shows you how to add equations create error bars and apply curve fits Equations The Equation Editor is a specialized text tool that you can use to insert mathematical equations or chemical formulas into your chart canvases Figure 14 1 Equation Editor window To Add Equations to a Chart Canvas From the menus choose Insert Equation 205 206 Chapter 14 Create your equation using the control
99. file prodcosts xls Source Destination Import from Import to C Entire File C Cell A C The Current Position Label Label Cell Range Lar shest Name orksheet Name Cell Location gt Vv Promote first selected row for column labels AS MV Set Insert Mode On OK Cancel The Source group controls how your source file is imported Import from Choose whether to import the whole data sheet or a range of cells Worksheet Name For multiple worksheet files choose the desired source worksheet You can choose to import a range of cells within a single worksheet or the entire worksheet Promote first selected row for column labels Select this option if you want your first row of data to be used as column labels 18 Chapter 2 The Destination group controls the location of the new data in the Data window Import to Specify the starting cell for the data that you are importing Set Insert Mode On Deselect this option if you want the new data to overwrite the existing data To Import Data Click the Data window to make it active If the data you are importing contain row labels click the first row label to select it as the insertion point From the menus choose File Import Data In the Select File for Import dialog box select the data file that you want to import and click Open Under Import From in the Select the Import Range dialog box choose whether you
100. for accurate color PANTONE and other Pantone Inc trademarks are the property of Pantone Inc Pantone Inc 2001 Pantone Inc is the copyright owner of color data and or software which are licensed to SPSS Inc to distribute for use only in combination with DeltaGraph PANTONE Color Data and or Software shall not be copied onto another disk or into memory unless as part of the execution of DeltaGraph DeltaGraph Chart Advisor SPSS and the DeltaGraph logo are registered trademarks of SPSS Inc Microsoft Windows and their respective logos are registered trademarks of Microsoft Corporation in the United States and other countries Adobe the Adobe logo Acrobat the Acrobat logo PhotoShop Illustrator PostScript and the PostScript logo are trademarks or registered trademarks of Adobe Systems Incorporated in the U S and or other countries All other brand and product names used in this manual are or may be trademarks or registered trademarks of their respective companies ISBN 1 56827 238 3 April 20 2004 Preface DeltaGraph 5 for Windows is a powerful charting application that you can use to create charts from a wide variety of data sources With more than eighty base charts to choose from and customizable chart options DeltaGraph provides you with virtually endless ways of presenting your data DeltaGraph 5 also offers a variety of new features including seamless integration with Microsoft Office applications th
101. graph o 3 Series 6 No symbol Fi Series 7 O Series 8 Appearance amp Series 9 Color O Example Series 10 Y EA Size 12 z a Character W v Key EN coca J Series list Select all series whose display properties you wish to modify When you select other options in this dialog box only the series you have selected here are affected Built in DeltaGraph symbol Use a built in set of symbols that is not dependent on font availability Font Select a font Library pictograph Select a pictograph to use as a symbol No symbol Select to hide symbols Color Select a color Size Select a size Character Select a character or symbol Key Select a character symbol by entering a keyboard stroke 171 Axes Symbols and Legends To Modify Chart Symbol Properties Click the chart From the menus choose Chart Symbols In the series list select all series whose symbols you want to modify Make the desired selections Click OK Tip You can double click the symbol to display the Symbols dialog box or select the symbols and use the right click context menu Also the text toolbar in the document window works with symbols as well as text Modifying Legends Legends distinguish the various series in a chart The type of legend available depends on the type of chart Here is a list of the various legend types Base Legend Displays the color or symbol that represe
102. h Chart Objects Tip You can also use the Format Object dialog box to change the fill pattern To Change the Object Color If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Selection tool and select the object Click the Foreground or Background Color tool Pr and choose a color from the palette Tip You can also use the Format Object dialog box to change the object color Format Object Lines You can use the Lines tab in the Format Object dialog box to change the color width dash style and fill style of any line Figure 13 2 Format Object dialog box Lines tab Format Object x Colors Lines Shadows Text Background Color 22222222222 os y Foreground Color Fil Style A Width 112 pt T Custom fp 50 pts 4 m T Dashes E a Scale Normal Bound ends OK Cancel Apply Help 182 Chapter 13 Background Color Click the color swatch and choose a color from the palette The background color appears only if the line has a pattern fill Foreground Color Click the color swatch and choose a color from the palette to change the line color of an object or chart item Fill Style Click the arrow and select a pattern style from the palette to apply it to a selected line To select the colors that appear in the pattern select a foreground and background color To create a colorful border create a thick line with a pat
103. he Gr he Era 56 To Use the Chart Gallery o o oo 58 Chart Overlay Dialog Box 2 o o oo 59 To Create Combination Charts 00 60 To Refresh Charts e aod ee ee ee Ge te ae 61 To Add Chart Axis Titles 2 2 2 eee ee 61 To Change a Chart s Data Range o 61 4 Bar and Column Charts 63 Bar and Column Charts eee 64 Stacked Bar and Column Charts o o 65 Bar and Column Segmentation Charts 67 Stacked Bar and Column Segmentation Charts 68 Floating Bar and Column Charts 69 Floating Stacked Bar and Column Charts 71 Buuld Up Charts sees o Pas A ea Sled E 72 Stacked Build Up Charts ooo ooo 73 XY Column Charts tai a A e Ee 74 5 Line Step and Range Charts 77 Eme Charts aise ae Loa did ds eta E 77 Step Charts aur eh Goth wis ec wat en s Bln Sh ee 79 Range Chatts lt o oos ee ge ic a ep a ee 80 High Low Charts cn aa a A a e 81 High Low Close Charts 2 00 00 00004 83 Open High Low Close Charts o 84 Volume Open High Low Close Charts 85 Candlestick Charts o o e e 87 XY Lie Charts me de a A A A A a 88 Paired XY Line ChartS o o e 90 Time Line Charts o e e 92 6 Scatter Charts 93 Paired Scatter CHATS care
104. he color click the arrow and choose a color from the palette Example Displays how the cell will look using the current settings To Change the Alignment of Data 4 o Select the cell s that you want to format From the menus choose Data Format Cells In the Format Cells dialog box click the Appearance tab In the Vertical Alignment group select Top Center or Bottom In the Horizontal Alignment group select Left Right or Center Click OK 36 Chapter 2 Tip You can also access the Format Cells dialog box by clicking the Format Cells tool on the Data window toolbar or by right clicking any cell To Add Cell Borders Select the cell s that you want to format From the menus choose Data Format Cells In the Format Cells dialog box click the Appearance tab In the Cell Border list select a line style To change the border color click the Border Color swatch and choose a color from the palette Do one of the following m Select All Borders to apply borders to the top bottom left and right of cells m Select any of the Top Bottom Left and Right check boxes to apply those borders to cells Click OK Tip You can also access the Format Cells dialog box by clicking the Format Cells tool on the Data Window toolbar or by right clicking any cell To Change the Cell Color Select the cell s that you want to format From the menus choose
105. he x axis shows the subgroups or lot numbers and the y axis shows the percent defective the number of defectives divided by the subgroup size The control warnings and limits vary in a fraction defective chart because the sample sizes vary The number of defectives np chart plots the number of defective items in each subgroup The x axis shows the subgroups or lot numbers and the y axis shows the number of defectives Setting up your data The first column represents subgroup size The second column represents the number of defects in the subgroup To label your data enter your lot or subgroup numbers in the label row Figure 9 8 Fraction defective p chart UCL UWL Mean 6 8 LWL AAA AA Cc D 9 Volt 141 Statistical and Quality Control Charts Figure 9 9 Number of defectives chart np Data for stat BE L PX Ba Sy ne Cell F 7 For Help press F1 20 UCL 19 93 18 UWL 16 82 16 14 12 Mean 10 6 10 8 6 4 LWL 4 38 2 LCL 1 27 0 AAA AA Cc D 9 Volt 142 Chapter 9 Defects Per Unit u and Number of Defects c Charts When you plot a chart the exact type of chart that results depends on your subgroup sizes Variable subgroup sizes produce a defects per unit u chart Fixed subgroup sizes produce a number of defects c chart The mean line is the average number of defects Control and warning limits show which data values fall outside of the control range The upper and lower war
106. hoose File Style Set Open In the Open Style Set dialog box browse to the location of the file and select it In the Load area select which components you want to load Click Open To Save Style Sets Backgrounds and layouts are saved with their associated documents If you want to use the backgrounds and layouts in a different document you can save them in a style set and load the style set into the other document From the menus choose File Style Set Save Type a name for the style set in the File Name text box Click Save To Import Layouts into Style Sets You can add layouts from another style set to the current style set To append the layouts to the list of current layouts the imported layout names must be different from the current layout names 223 Standardizing Charts and Documents From the menus choose File Style Set Open Select the style set to which you want to add the layouts and click Open From the menus choose File Style Set Open Select the style set that contains the layouts that you want to import Inthe Load area ensure that the Layouts check box is selected Click Open and then click Add Note If you want to import a layout from another document you must first save the style set from that document and then import the layout from the style set Using Layouts A layout is a template for arranging charts titles text and graphi
107. iations and relationships over three sets of values for example latitude longitude and elevation The values vary as in line contours Setting up your data Each data series requires three columns of data The first column contains the values for the x coordinate points the second column contains the y coordinate points and the third column z represents an elevation You are limited to 32 767 data points when creating an XYZ contour line chart The third dimension of values is shown as an annotated elevation on the chart An XYZ contour line chart does not require labels or a legend Figure 8 4 XYZ contour line chart Data for contvect BE Cell K 10 For Help press F1 123 Contour and Vector Charts Elevation Latitude 3 Longitude Vector Charts A vector chart displays a direction such as airflow using vectors arrows over a gridded area In this chart the length of the vector is determined as a percentage of the size of the chart plot frame and is the same for all vector arrows Setting up your data Each data series requires a single value Each value becomes a vector within a grid cell Since these values give the angle at which to draw the vector on the gridded chart enter a degree value Values outside of the O to 360 range are supported If the value is greater than 360 360 is subtracted from the value If the value is less than 0 360 is added to the value All vectors on this chart are
108. ick to keep a tool active until you select another tool or press Escape With Double click a double mouse click keeps the tool active and a single click keeps the tool active for a single instance 279 Customizing the DeltaGraph Desktop New Text Boxes To set the default text appearance for text objects click Text Choose the desired text properties and then click OK To Modify Drawing Toolbox Preferences From the menus choose Edit Preferences Click the Drawing Toolbox tab Make the desired selections Click OK Text Box Preferences You can use the Format Object dialog box to set default text properties for any new text objects Figure 19 11 Format Object dialog box Format Object x Text gt Effects Drag white letter to set shadow Font E Arial z l Baseline Style Regar y Superscript CS5 bscript Size 3 y E p l Strikeout Color E I Underline Alignment Script Shadow Horizontal o pts e westen y Color E Y SS Western z an Vertical fo pts Continue Cancel Help 280 Chapter 19 Font Choose a font type such as Arial or Times New Roman Style Choose a font style such as bold or italic Size Choose a font size Color Click the color and choose a color from the palette Alignment Choose a text alignment style left justified centered or right justified Effects Choose a fo
109. ific PANTONE spot colors directly to any element in your chart knowing that when you export these spot colors in EPS files they will separate correctly with any application that uses PostScript Level 2 or higher PANTONE also offers a wide selection of process colors which separate onto their own color plates To Create PostScript Files If you are preparing a file for a service bureau you can save it as a prn file From the menus choose File Print Canvas In the Print Canvas dialog box select Print to file Click OK In the Print to File dialog box browse to the directory in which you want to save the file Type a name for the file in the File Name text box Ensure that prn is selected in the Save as Type drop down list Click Save 254 Chapter 17 To Create Encapsulated PostScript Files Click the Chart window to make it active From the menus choose File Export Image In the Export Image dialog box browse to the directory in which you want to save the file Type a name for the file in the File Name text box From the Save As Type drop down list select eps Click Save Chapter 18 Using DeltaGraph Charts in Other Applications You can add the charting power of DeltaGraph to Microsoft Word PowerPoint Excel and any other application that supports OLE 2 embedding You can link embed and edit any DeltaGraph object charts chart objects data sheets and so
110. igh North West West South South East East Middle Very High West West North East Noth O East Soth West South South 115 Area Pie and Table Charts Table Chart Use a table chart to display the data associated with a chart or any other information You can also attach a data table to 2 D charts with a categorical axis The category labels also act as the column headers in the attached data table For example you could attach a table chart to an area chart to show the specific number of units sold Setting up your data Enter the table data including row and column labels as you want it to appear in the table chart You can use the upper left cell in the data sheet to enter a title over the row labels in the table Figure 7 7 Table chart and area chart with attached table 180 Wi Product A 160 ProductB 140 120 100 80 60 40 1994 1995 1996 1997 1998 1999 Product Sales Product A Product B Chapter 8 Contour and Vector Charts While contour charts emphasize every nuance of the data vector charts emphasize a single direction in the data An elevation map is an example of a contour chart You could use a vector chart to map the effect of wind speed on pollution This chapter describes the following chart types Contour fill charts XYZ contour fill charts Contour line charts XYZ contour
111. il Magazine Sales Promotion TV Results 50 Web 5 Radia 50 50 50 Mail Magazine MM ProductA Ws Product B Product C 109 Area Pie and Table Charts Pie and Donut Charts A pie chart shows the relationship of the parts to the whole You can create a donut chart by plotting a pie chart and changing some settings in the Options dialog box The center section of a donut chart can display the sum of the values of all parts For example to show the number of units sold in various regions use a pie chart To show the total number of unit sales as well use a donut chart Setting up your data This chart type uses one column of data Each wedge of the pie represents a row value Row labels name each pie slice these labels also appear in the legend A pie chart does not use column labels Figure 7 3 Pie and donut charts Data for areapie BE Label Unit Sales papada pie tack Cell P 7 For Help press F1 110 Chapter 7 Units Sold by Region North South East Units Sold by Region North South East 111 Area Pie and Table Charts Figure 7 4 Exploded pie and 3 D pie chart Units Sold by Region North South East Units Sold by Region M North B South O East M West South East 112 Chapter 7 Stacked Pie Charts A stacked pie chart shows the relationship of the parts to the whole for two or more data series Data se
112. ination chart combines two different chart types The first chart is the base chart The second chart is the overlay chart You can use only certain chart types to create a combination chart 3 D charts nonrectangular 2 D charts and 2 D charts with the depth effect do not support overlay charts You can use the Chart Overlay dialog box to create or apply an overlay chart to a base chart Figure 3 7 Chart Overlay dialog box Chart Overlay M Show Overlay Column Chart 55 Series Selection Base Chart Overlay Chart Series 1 gt Series 2 E usa Axis and Legends Display overlay legend separately Additional axis on T Val JE xxi EE Lategory als Cancel Apply Help Show Overlay Select to apply an overlay chart Deselect to hide an overlay chart Overlay chart Choose a chart type for the overlay chart 60 Chapter 3 Series Selection You can use the right and left arrows to select the series for the base chart and for the overlay chart You can use the up and down arrows to set the order of the data series Display overlay legend separately Select to display the overlay legend in a box separate from the base legend Value axis Select to display an additional value axis Category axis Select to display an additional category axis To Create Combination Charts A combination chart is a base chart with a second chart known as an overlay chart drawn on top of it For example
113. ine 48 arccotangent 48 arcsecant 48 arcsine 48 arctangent 48 cosecant 48 cosine 48 cotangent 48 hyperbolic trig functions 48 secant 48 sine 48 tangent 48 types of output 243 typing data into the data sheet 23 u charts 142 ungrouping objects 203 unlocking objects 203 updating charts 61 290 Index values displaying in charts 173 174 175 vector charts 123 125 XY charts 126 worksheets adding 15 removing 15 renaming 16 typing in data 23 XBar charts 136 XY charts 88 90 3 D XYZ surface fill charts 158 3 D XYZ surface line charts 159 column charts 74 vector charts 126 XYZ charts 119 122 Zoom tool 193
114. ine at the bottom of the function list 219 Equations Error Bars and Curve Fits In the Custom Curve Fit dialog box click Open Choose dcf from the Files of Type list Browse to the location of the file Click OK To Save a Custom Curve Fit In the Custom Curve Fit dialog box click Save Enter a filename Click Save Chapter 15 Standardizing Charts and Documents DeltaGraph provides a number of features to help you streamline chart production and provide a consistent appearance across one or more documents Document Templates The document template is a DeltaGraph file called DocumentTemplate dg5 It includes information on color schemes layouts and backgrounds and serves as the basis for all new documents as well as any new charts you create in existing documents Style Sets A style set is a file with the extension dsy that contains three basic components color palette backgrounds and layouts When you load a style set into a document you can load any or all of these components To Select the Document Template From the menus choose Edit Preferences Click the General tab Click the Browse button and browse to the location of the DeltaGraph document that you want to use as the document template Click OK 221 222 Chapter 15 To Load Style Sets You can use style sets to load different layouts and backgrounds into your document From the menus c
115. irst data series in your chart template but the current chart color scheme uses red for the first data series your applied chart will use red for the first data series To make the first data series use blue open the chart color scheme that uses blue for the first series or change the first 240 Chapter 16 series color in the Edit Colors dialog box The chart template stores the position of the color in your current color palette rather than the absolute color value Add Chart Template to Library You can use the Add Chart Template to Library dialog box to add charts and chart templates to libraries Figure 16 3 Add Chart Template to Library dialog box Add Chart Template to Library E Name QualControl Xbar Save chart as template C Save chart with data Cancel Help Name Enter a name for the chart or chart template Save chart as template Click to save the chart with all of its formatting options but without its data Save chart with data Click to save the chart with its formatting options and its data To Create Chart Templates Open the library in which you want to store the template Drag the chart that you want to use as the template from the chart canvas into the Libraries window In the Add Chart Template to Library dialog box enter a name for the template Select Save chart as template Click OK 241 Using Libraries to Store Charts and Images To Create Charts from Templat
116. ithin the other application When the object is activated DeltaGraph s menus and toolbars replace those of the other application When you have finished editing the object you can return to the other application by clicking any area outside of the DeltaGraph windows Open the file that contains the embedded DeltaGraph object Double click the DeltaGraph object The DeltaGraph menus and toolbars replace those of the other application 258 Chapter 18 Modify the object as required Tip You can also edit an object by right clicking it and choosing Edit If you want to edit the object in DeltaGraph click Open To Position Charts in Other Applications In the other application drag the object to its new location Chapter 19 Customizing the DeltaGraph Desktop When you initially launch DeltaGraph the desktop opens a Chart window and a Data window for the new document The Document Manager on the left is minimized In subsequent sessions the windows open where you last left them for example docked floating minimized or hidden You can customize your workspace in several ways You can m Minimize resize dock float or close the Document Manager m Show or hide various screen elements such as toolbars rulers and grid lines m Dock resize or close the Data window 7 Set application defaults such as which document to use as the template and whether to show the Welcome to DeltaGraph dialog box when
117. itude dependent on the endpoint calculation method The XY vector chart specifies the origin point based on the x and y axes scaling For example you could track how the wind disperses pollen from various plants Setting up your data Each data series requires four columns of data The first two columns represent the origin or tail of the vector The third and fourth columns represent the x and y coordinates of the end point of the vector To label each series enter labels over the first column of each data series These labels appear in the chart legend Because the XY vector chart uses values on both axes there are no category axis labels You can edit vectors in the chart by double clicking the arrows or by choosing Edit Arrows from the Draw menu 127 Contour and Vector Charts Figure 8 7 XY vector chart Pollen B 10 26 19 26 22 22 27 28 23 15 32 27 v1 x1 Ey 2 Y2 x23 Y2 3 ODIN Cell L 8 For Help press F1 70 20 JA 0 10 20 30 40 50 60 70 Pollen Distribution Pollen A PollenB 128 Chapter 8 Delta Change The ending point is computed from delta values specified in the Data window The first and third columns of the chart s data are summed to compute the x coordinate of the ending value The second and fourth columns are summed to compute the y coordinate XY Coordinates The end point is determined from x and y
118. iving people 135 Statistical and Quality Control Charts Figure 9 5 Survival chart Data for stat BE Cell 6 11 For Help press F1 1000 900 800 700 600 500 400 300 200 100 0 01 02 03 04 05 06 07 08 09 1 Chemical A 136 Chapter 9 Quality Control Charts Quality control charts also known as Shewhart charts are specialized graphs used for the control of continuous processes They highlight variation in a process that exceeds established control limits Quality control charts consist of x and y data points plotted as symbols connected by line segments The plotted values result from computations based on the type of quality control chart selected A horizontal line is also plotted to represent the average of all plotted values The following types of quality control charts are available XBar R or XBar S Fraction defective p Number of defectives np Defects per unit u Number of defects c Within DeltaGraph these charts are found under names beginning with QC as in QC XBar R XBar R and XBar S Charts When you plot an XBar R chart two charts are created in the slide window The first chart drawn is the XBar chart which plots the mean value of each subgroup The subgroup numbers are plotted along the x axis The average of the measured data for each subgroup is plotted along the y axis The mean line is the average of all of the values in the data set Control
119. ject To Create Pictographs You can add a pictograph to any chart background symbol or object as long as the object does not contain a gradient fill 236 Chapter 16 4 Select the object to which you want to add a pictograph In the Libraries window select the image that you want to use as a pictograph From the menus choose Insert Apply Library Pictograph In the Pictographs dialog box choose a scaling option in the Type drop down list The thumbnail on the right displays a preview of the selected option In the Anchor drop down list choose an alignment option Click OK Tip You can also add a pictograph by dragging and dropping an image from a library onto a selected chart element or by placing the image on the clipboard and then choosing Paste As Pictograph from the Edit menu To Remove Pictographs from Charts 4 Select the pictograph From the menus choose Format Pictograph Select Remove Pictograph Click OK To Modify the Scaling Style of Pictographs Pictographs offer several styles for creating various visual effects including stretched tiled stacked and scaled Select the pictograph 237 Using Libraries to Store Charts and Images From the menus choose Format Pictograph In the Type drop down list choose a different pictograph type The thumbnail on the right displays a preview of the selected option Click OK To M
120. k Cell Text Choose the desired text properties and then click OK 273 To Modify Data Preferences From the menus choose Edit Preferences Click the Data tab Make the desired selections Click OK To Set Text Default for the Data Window From the menus choose Edit Preferences Click the Data tab Click Cell Text Make the desired selections Click OK e Click OK in the Preferences dialog box Customizing the DeltaGraph Desktop 274 Chapter 19 Preferences Profiles You can use the Profiles tab in the Preferences dialog box to set color management features Figure 19 8 Preferences Profiles tab Preferences El General Charts Data Profiles Libraries Drawing Toolbox Image Files Monitor Profile Generic RGB Profile y RGB Profile Generic RGE Profile y Printer Profile Genetic CMYK Profile T Include color profiles on export Tl Read color profiles during import Edit Colors Dialog _ Rendering Intent Perceptual y FT Show RGB profile colors Color Illuminant Lighter D65 C Darker D50 Monitor Profile Select a device profile to use as the color profile for your document window RGB Profile Select a device profile to use for the image export color profile DeltaGraph will calibrate the colors within the exported image to match the selected profile If you choose to embed profiles within export
121. key To Apply Layouts to Canvases If the Layouts window is not visible from the menus choose View Layouts In the Layouts window select a layout Do one of the following 227 Standardizing Charts and Documents m Click the Apply Layout tool on the Layouts window toolbar to apply the layout to the current canvas only m Click the Apply to All Canvases tool on the Layouts window toolbar to apply the layout to all canvases in the open document Tip You can also drag a layout from the Layouts window onto the chart canvas To Remove Layouts from Canvases If the Layouts window is not visible from the menus choose View Layouts Drag and drop the Blank layout from the Layouts window onto the chart canvas Using Backgrounds Backgrounds form the backdrop of a chart canvas like a sheet of paper with the company letterhead There are three types of backgrounds master backgrounds which apply to all canvases in your document custom backgrounds which apply to individual canvases and linked backgrounds which are linked to specific layouts To Show or Hide Backgrounds From the menus choose View Backgrounds To Create Backgrounds From the menus choose Format Backgrounds New 228 Chapter 15 Create the background by doing any of the following m Add colors shadows or gradients using the Format Object dialog box m Add drawing objects or text using the Drawing
122. l charts typically have a value axis category axis and series axis Charts such as polar and ternary have specialty axes specific to each chart The following are the various axis types that you may encounter Value The value axis displays a continuum of values such as numbers dates or currency amounts For example in a column chart representing product sales for the year the amount of sales for a product is a value In a 2 D chart the value axis is usually the y axis or vertical axis In a 3 D chart the value axis is usually the z axis or vertical axis 165 166 Chapter 12 Category The category axis displays the various categories that divide the data into smaller groups For example in a column chart representing product sales for the year the products represent categories A category axis uses text to label the data and does not have any of the scale properties of a value axis In a 2 D chart the category axis is usually the x axis or horizontal axis In a 3 D chart the category axis is usually the x axis or the back right axis Series The series axis works as another category axis in that 1t divides the data into smaller groups For example in a column chart representing product sales for the year by region each region represents a series A series axis uses text to label the data and does not have any of the scale properties of a value axis In a 3 D chart the series axis 1s usually represented on the y axis
123. le each value in column A is divided by 9 and the remainder is written to the corresponding cell in the destination column The second example is the same but each value in column A is divided by the corresponding value in column B Mx Function Writes the maximum value of a column to the first cell of the destination column Syntax Mx one column Example Mx A 47 Preparing the Data RSum Function Creates a running sum of all of the values in the source column Writes the sum of each value plus all of its preceding values to the corresponding cell in the destination column Syntax RSum one column Example RSum A Smooth Function Adds the value in each cell in a column to the values in a specified number of following cells Writes the average of these values to the corresponding cell in the destination column Syntax Smooth one column number of following cells Example Smooih A 5 This example calculates the average of each cell in column A plus the five cells following it It outputs that average value to the corresponding cell in the destination column Sqrt Function Writes the square root of each value in the source column to the corresponding cell in the destination column Syntax Sqrt one column or number Examples Sqrt A Sqrt 16 Squash Function Compresses all entries in a column by removing all empty cells Syntax Squash one column Example Squash A 48 Chapter 2 Std Functio
124. le by the revenue from each sale for three customer types with color used to show the time required to close each sale 96 Chapter 6 Setting up your data Each data series has three columns of data The first column contains the x coordinate of the point the second column contains the y coordinate of the point and the third column contains the z value or color of the point Because the paired intensity scatter chart uses values on both axes there are no category axis labels Figure 6 3 Paired intensity scatter chart Data for Document 1 BE Point 1 1 2 Paint 2 1 3 Point 3 1 9 Point 4 0 8 Point 5 0 9 Data 10 Cell 5 For Help press F1 mx O x 0 10 20 30 40 50 60 97 Scatter Charts Intensity Scatter Charts An intensity scatter chart is a scatter chart in which each point is colored or shaded along a spectrum to show its value on a third z value For example a catalog order company could plot a customer profile for the number of new repeat and valued customers including the average sale amount as another value Setting up your data Each data series uses the same x coordinates only the y coordinates and z coordinates vary The first column contains the x coordinates The second column contains the y coordinates The third column contains the z coordinates To label each data series of a scatter chart enter labels over each column of y coordinates Because the s
125. le name Choose a format from the drop down list Date Select to show the date Choose a format from the drop down list Time Select to show the time Choose a format from the drop down list The controls in the Use Date and Time At group let you select options for the date and time used in the header or footer Print Select to use the time and date at the time of printing Save Select to use the time and date from the last save Document Creation Select to use the time and date from when you created the document 8 Chapter 1 Header Footer Properties Position You can use the Position tab in the Header Footer Properties dialog box to specify the position of the header or footer on the canvas Click one of the six marked areas on the thumbnail to set the position Figure 1 3 Header Footer Properties Position tab Header Footer Properties E Contents Position Text To set the location of the header or footer click one of the dotted regions on the page I Show on first page Page 1 of 3 areapie 7124100 DK Cancel Help Show on first page Select to display the header or footer on the first canvas of the document Header Footer Properties Text You can use the Text tab in the Header Footer Properties dialog box to change the font properties of headers or footers 9 Welcome to DeltaGraph 5 Figure 1 4 Header Footer Properties Text tab Header Footer Properties E Contents
126. lect the first sort key column to be sorted by and optionally a second and third Click OK Labeling Data Labels help you to keep your data organized They also categorize and serialize data for your chart axes and legends The labels you need will depend on the type of chart that you want to create For example a bar chart uses both row and column labels while a paired scatter chart uses only every second column label A contour fill chart does not use labels at all The top row and leftmost column in the data grid are reserved for labels Unlike regular data cells label cells are automatically formatted as text cells and cannot be formatted using the Format Cells dialog box Some chart labels are taken from the Data window m The labels for the series are displayed as part of the chart legend m The row labels in the Data window are the value labels of the categorical axis usually the x axis m Ifyou select a range of data from somewhere in the middle of the grid and the first row and or column of the selected range is text then that row or column is treated as a label 39 Preparing the Data To Add Column or Row Labels If the first row and or column that you select in the Data window contains text you can use it as an axis label when you plot your chart If there are no labels in the data you can add them in the Data window In the Data window click the label cell of the row or column that you want to label
127. lick OK Using the Drawing Toolbox The Drawing Toolbox contains drawing tools for creating objects of all shapes and sizes and it also contains shortcuts for editing the appearance of charts and objects The drawing tools allow you to add text arrows lines curves freehand shapes and polygons The formatting tools allow you to change line color line style line thickness object pattern and object color You can also add a gradient or a shadow effect To Zoom In and Out If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Zoom tool a To keep the tool selected double click it Do one of the following To zoom in click the chart canvas To zoom out press the Ctrl key while clicking the chart canvas When you are finished press Esc or click the Zoom tool to deselect it Tip You can also select the Zoom tool by pressing Z on your keyboard 194 Chapter 13 To Draw Lines If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Line tool w To keep the tool selected double click it Click and drag to draw a line Tip You can also select the Line tool by pressing L on your keyboard To Draw Bezier Curves If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Bezier tool 4 Click once to mark the starting point of the curve Position the cursor at the end point of the curve and c
128. lick and drag to draw it A tangent line appears to help gauge the position of the curve it disappears after the shape is completed Do one of the following m Double click to finish the curve m Continue adding more curves to the line Tip You can also select the Bezier tool by pressing B on your keyboard To Change the Bezier Curve Size Select the curve Drag the handles to adjust the size 195 Working with Chart Objects To Change the Bezier Curve Angle Select the curve From the menus choose Format Reshape Object Drag the handles at either end of the arc to change the angle To Draw Curves If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Curve tool eo To keep the tool selected double click it Click and drag diagonally in any direction to extend the curve Tip You can also select the Curve tool by pressing C on your keyboard To Change the Curve Size Select the curve Drag the handles to adjust the size To Change the Curve Angle Select the curve From the menus choose Format Reshape Object Click and drag the handles at either end of the arc to change the angle 196 Chapter 13 To Draw Freehand Objects If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Freehand tool ml To keep the tool selected double click it Click and drag to draw a segment Release the
129. line charts Vector charts Radius angle vector charts XY vector charts Contour Fill Charts A contour fill chart shows surface variation based on two sets of evenly spaced values such as latitude and longitude at 10 intervals and a unique number such as elevation at a given point The values vary in pattern or color Setting up your data Contour fill charts require at least two columns and two rows of data The vertical or y axis shows the category the horizontal or x axis shows the series Row labels name each category on the y axis Column labels name each series on the x axis 117 118 Chapter 8 Figure 8 1 Contour fill chart Longitude Longitude B Longitude C Longitude D Latitude B Latitude C Latitude D Ea Cell F 6 For Help press F1 EER BRZ Elevation Latitude A Latitude B Latitude C Latitude D Longitude A Longitude B Longitude C Longitude D 119 Contour and Vector Charts XYZ Contour Fill Charts An XYZ contour fill chart shows variations and relationships over three sets of varying values for example latitude longitude and elevation The values vary in pattern or color and are represented in the legend For example an engineer could plot the strain on a metal part in various areas Setting up your data Each data series requires three columns of data The first column contains the values for the x coordinate points The second column contains the y coordinat
130. ll Label Label For Help press F1 To Open Multiple Data Windows If you have more than one document open you can display multiple Data windows so that you have easy access to all of the data If you do not have multiple Data windows open the Data window reflects the data for the active document On the Data window toolbar click the Always Open tool the pushpin Tip Because the Always Open tool is on the far right of the Data window toolbar you may need to resize the Data window to see it To Show or Hide the Data Window From the menus choose View Data Tip You can also show or hide the Data window by clicking the Data Window tool on the Chart window toolbar 15 Preparing the Data To Roll Up the Data Window Click the arrow on the right corner of the Data window title bar Tip To unroll the Data window click the arrow again To Add Data Sheets From the menus choose Data Insert Sheet Tip You can also add new data sheets by clicking the New Data Sheet tool on the Data window toolbar To Remove Data Sheets You can remove a data sheet only if its contents are not used in a chart Inthe Data window click the tab of the data sheet that you want to remove From the menus choose Data Delete Sheet Click OK Tip You can also remove data sheets by right clicking the tab of the data sheet and choosing Delete Sheet 16 Chapter 2 To Rename Data Sheets
131. lors Lines Shadows Text Background Color Click in sample to set Foreground Color sa rly C Gradient fill swe mmm Fd Cancel Apply Help Background Color Click the color swatch and choose a color from the palette The background color appears only if the object has a pattern or gradient fill Foreground Color Click the color swatch and choose a color from the palette to change the color of a chart element or drawing object Pattern fill Select to apply a pattern fill to a selected object To select the colors that appear in the pattern select a foreground and background color Pattern Style Click the arrow to select a pattern from the palette Gradient fill Select to apply a gradient or blended fill to a selected object To select the beginning and ending color of the gradient choose a foreground and background color Gradient Style Choose a gradient style to set a color blend pattern Steps Enter a larger number to create a smooth blend Enter a smaller number to create a striped blend that uses fewer colors Gradient direction Click the gradient preview along the edge in the center or in the corner to set the direction of the gradient 179 Working with Chart Objects To Apply a Gradient Fill If the toolbox is not visible from the menus choose View Drawing Toolbox Select the object Click the Gradient Fill tool P To keep the tool selected double
132. m the Libraries window onto the canvas To Show or Hide Libraries When you open or create a library the Library window automatically opens If you have multiple libraries open you can switch between them using the menu in the Libraries window Closing the Libraries window does not close your open libraries From the menus choose View Libraries Note You can display the Libraries window only if you have one or more libraries open 231 232 Chapter 16 To Create a Library From the menus choose File Library New In the Create New Library dialog box browse to the directory in which you want to save the library In the File Name text box enter a name for the library Click Save Tip You can also create a library by using the Open Library tool on the Standard toolbar or by using the menu in the Libraries window To Open a Library From the menus choose File Library Open 4 In the Open Library dialog box browse to the location of the library file and select it Click Open Tip You can also open a library by using the Open Library tool on the Standard toolbar or by using the menu in the Libraries window To Close a Library From the Libraries window menu choose Close Note If the Libraries window is not visible choose Libraries from the View menu 233 Using Libraries to Store Charts and Images To Add Items to a Library You can store images and charts in libra
133. mber of files displayed in the File menu enter a value in the Recently Used File List text box Click OK 265 Customizing the DeltaGraph Desktop To Modify Ruler and Grid Defaults From the menus choose Edit Preferences Click the General tab Click Rulers amp Grid To show the rulers select Show rulers To show the grid select Show grid Choose a unit of measurement in the Units drop down list e Enter a size for the grid squares in the Size text box This control uses the unit of measurement that you chose in the Unit drop down list If you want objects on the chart canvas to automatically snap to the nearest grid intersection select Snap to grid Click OK Click OK in the Preferences dialog box Preferences Charts You can use the Charts tab in the Preferences dialog box to set chart defaults such as whether to use color or patterns to differentiate series and whether to update charts automatically 266 Chapter 19 Figure 19 3 Preferences Charts tab Preferences x General Charts Data Profiles Libraries Drawing Toolbox New Charts Distinguish Series Using Text C Patterns only Tick Marks dd C Colors and patterns Symbols Update charts automatically MV Reduce superscripts and subscripts M Use perspective labels for 3D charts Cancel Apply Help Distinguish Series Using Choose Colors Only Patterns Only o
134. mouse button to complete the shape Tip You can also select the Freehand tool by pressing F on your keyboard To Edit the Shape of a Freehand Object From the menus choose Format Reshape Object Drag the handles to change the object s shape To Draw Filled Shapes If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Rectangle Rounded Rectangle or Circle tool E Click and drag to draw the shape To create a square or circle press the Shift key while dragging 197 Working with Chart Objects To Change Round Rectangle Corners Select the rounded rectangle From the menus choose Format Reshape Object Drag the handles to adjust the arc To Draw Polygons If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Polygon tool 4 Click once to begin the first segment Click again to complete the segment Single click to continue adding segments Double click to complete the polygon Tip You can also select the Polygon tool by pressing P on your keyboard To Change the Shape of a Polygon Select the polygon From the menus choose Format Reshape Object Drag the handles to change the object s shape 198 Chapter 13 Insert Image You can use the Insert Image dialog box to import clip art or other graphic images Figure 13 7 Insert Image dialog box Insert Image Fa x
135. n Writes the standard deviation for each row in the source columns to the corresponding cell in the destination column Syntax Std two or more columns or numbers Examples Std A B C D Std 6 4 8 12 TStd Function Writes the standard deviation for all of the cells in the source column s to the first row in the destination column Syntax TStd one or more columns or numbers Examples TStd A TStd A B C D Trigonometric Functions These functions write the sine cosine tangent etc for each value in the source column to the corresponding cell in the destination column Note that values are always assumed to be in radians Syntax sin one column or number Examples sin A sin 3 14 49 Preparing the Data The following table lists the trigonometric functions available for use in the Formula Builder Function Definition Sin Sine Asin Arcsine Sinh Hyperbolic sine Asinh Hyperbolic arcsine Cos Cosine Acos Arccosine Cosh Hyperbolic cosine Acosh Hyperbolic arccosine Tan Tangent Atan Arctangent Tanh Hyperbolic tangent Atanh Hyperbolic arctangent ZScore Function Function Cot Acot Coth Acoth Sec Asec Sech Asech Csc Acsc Csch Acsch Definition Cotangent Arccotangent Hyperbolic cotangent Hyperbolic arccotangent Secant Arcsecant Hyperbolic secant Hyperbolic arcsecant Cosecant Arccosecant Hyperbolic cosecant Hyperbolic arccosecant Converts each value in the source column int
136. n the y axis Based on the two percentages given a third value for the z axis 1s automatically calculated as a percentage of the remainder Figure 6 8 Ternary percent chart Data for scatter BE Sis Product 4 Cell H 7 For Help press F1 B Product A Y Product B Chapter 7 Area Pie and Table Charts Area charts emphasize the size or volume of a series For example you can use an area chart to compare the amount of products that a country exports and imports over a decade Pie charts provide a quick summary of a category s proportion in relation to the total This chapter describes the following chart types m Area charts Radar and spider charts Pie charts Stacked pie charts Multiple pie charts Area Charts An area chart emphasizes the volume or size of a data series over time Each data series is stacked on the preceding series in the chart For example you could compare the number of units sold over time for several products in a company division Setting up your data Each column of data corresponds to a data series a filled area on the chart The y axis shows values and the x axis shows categories Row labels name each category Column labels name each data series these labels appear in the legend 105 106 Chapter 7 Figure 7 1 Area chart Data for areapie mE A B Product4 Product B E area cata Cell J 7 For Help press F1 180 Product B
137. ndent variable Be unique and not used to name any other function anywhere in the dialog box Not start with a number Not contain an underscore _ or spaces After the equals sign the Constants and Parameters fields should each contain a definition for the name The following rules apply Constants may contain references to previously defined constants Parameters may be initialized with references to previously defined parameters or constants Letters of the alphabet may be used in the expression to represent columns of data within the Data window If you want to use letters in the expression to refer to something other than columns of data you must define them in the Constants or Parameters fields Letters that refer to columns are automatically capitalized Refer to a single cell by using brackets for example B 3 You can define multiple parameters or constants in a window be sure to separate each definition with a semicolon Rules for Using Functions You can use functions from the Formula Builder dialog box to define a curve fit Formulas are appropriate in three places The constant expression in a constant definition The initial value in a parameter definition The model formula in the model definition 216 Chapter 14 For constants and parameters you can use all of the functions from the Formula Builder with no restrictions You can use the following functions without restriction in the Formula field Sqrt
138. ng an iterative process The Estimation controls set stopping rules and define estimation weights The settings take effect the next time you click Estimate Maximum Iterations Enter a value between 1 and 32 767 to set the maximum number of iterations before the estimation process terminates Minimum Chi Square Enter a value between 0 and 99 999 to set the minimum chi squared value before the estimation process terminates Weights None weights each data point equally If you have a column in a data sheet that contains weight values you can choose this column from the list to apply the weights You can use the Display controls to set the contents of the Statistics field the next time you run an estimation Steps Choose whether to display all steps or only the last step Partial derivatives Select to display partial derivatives in the Statistics field Parameters displays parameter names in the derivative expressions and Estimates displays parameter estimates in place of parameter names in the derivative expressions Attempted parameter values Select to display both attempted and best parameter values 215 Equations Error Bars and Curve Fits Rules for Name Definition Each entry you make in the Independent Variable Formula Constants and Parameters fields within the dialog box begins with a name followed by an equals sign These names must Be limited to 63 characters Be followed by an equals sign except the indepe
139. ning limits represent the values that are two standard deviations or two sigmas away from the mean The upper and lower control limits represent the values that are three standard deviations or three sigmas away from the mean The defects per unit u chart plots the number of independent defects per unit This chart is appropriate for a complex assembly where many independent defects are possible The x axis shows the subgroups or lot numbers and the y axis shows the number of defects The number of defects c chart plots the number of defects in each subgroup The x axis shows the subgroups or lot numbers and the y axis shows the number of defects Setting up your data The first column represents subgroup size The second column represents the number of defects in the subgroup To label your data enter your lot or subgroup numbers in the label column over the first column of data Enter your label for the defects in the label column over the second column of data Enter your subgroup or lot numbers in the label row 143 Statistical and Quality Control Charts Figure 9 10 Number of defects c chart Data for Document 1 mE HI Sana A x Label A B Label Sub group size Number of Defects Cell D 15 For Help press F1 16 UCL 16 94 14 UWL 14 06 12 10 8 Mean 8 30 6 4 2 LWL 2 54 0 Chapter 10 3 D Charts 3 D charts allow you to divide your data into a variety of categories For example you co
140. not visible from the menus choose View Layouts Select a layout 225 Standardizing Charts and Documents Click the Duplicate Layout tool on the Layouts window toolbar To Rename Layouts If the Layouts window is not visible from the menus choose View Layouts Select the layout you want to rename Right click and choose Rename To Add Placeholders to Layouts Ifthe Layouts window is not visible from the menus choose View Layouts Double click the layout Click one of the placeholder tools on the Layouts window toolbar Click and drag to draw the bounding rectangle or dimensions of the placeholder Click the Exit Edit Mode tool on the Layouts window toolbar to return to apply mode To Format Title and Text Placeholders Ifthe Layouts window is not visible from the menus choose View Layouts Double click the layout Select the placeholder 226 Chapter 15 From the menus choose Format Object Click the Text tab and choose your formatting options Click OK Tip You can also right click the placeholder and select Format Object To Show or Hide Placeholders in Layouts From the menus choose View Layout Placeholders To Delete Layouts If the Layouts window is not visible from the menus choose View Layouts Select the layout you want to remove Right click and choose Delete Tip You can also select the layout and press the Delete
141. nt effect such as underline or strikeout Script Choose a font script such as Western or Greek Text shadow Enter horizontal and vertical values to set the direction of the shadow You can also drag the preview letter to set the font shadow direction Shadow Color Choose a color by clicking it on the palette To Set Default Text Box Properties From the menus choose Edit Preferences Click the Drawing Toolbox tab Click Text Make the desired selections Click OK Click OK in the Preferences dialog box 3 D charts area charts 151 column charts 145 ribbon charts 147 scatter charts 148 scatterline charts 150 surface fill charts 155 surface line charts 156 wireframe charts 153 XYZ surface fill charts 158 XYZ surface line charts 159 Absolute Value function 42 Add Chart Template to Library dialog box 240 adding images to a library 233 aligning data 35 objects 204 Always Open tool 14 angle of curve objects 195 appearance adding cell borders 36 arrows 184 charts 177 data cells 33 35 36 lines 185 196 objects 177 181 shadows 186 text objects 188 applying chart templates 241 images from libraries 233 layouts 226 library items 235 Index pictographs 235 area charts 105 151 Arrow tool 184 185 186 arrows creating 185 modifying 185 186 Average function 42 axes about 165 formatting 169 modifying 168 titles 61 backgrounds about 227 canv
142. nts each series Overlay Legend Displays the color or symbol that represents the overlay series Base and Overlay Legend Combined Combines the base legend and overlay legend into one legend box Scale Legend Displays a scale to represent the data value For example in a bubble chart the diameter of the bubble represents a data value Series Legend Displays the color or symbol that represent each series The Legends dialog box allows you to edit the symbol size and show hide the legend The Format Object dialog box allows you to edit the appearance of the legend the color of the symbols and legend frame and so forth 172 Chapter 12 Legends Dialog Box The Legends dialog box lets you change legend properties such as symbol size Figure 12 3 Legends dialog box E gt IV Show Base Legend y r Base Legend pf Overlay Legend T Reverse order Symbol Dimensions Width 204 Height 20 a Show Check to display legend s and uncheck to hide legend s Some legends are available only for certain chart types Reverse order Select to reverse the display order of the items in the legend This setting does not change the order of the data Width Enter a size for the width of the legend symbol Height Enter a size for the height of the legend symbol To Modify Legend Properties You can use the Legends dialog box to change the order of the legend items or the
143. nus choose Format Order Send to Back Select all of the images by pressing Ctrl while clicking them Drag the selected images into an open library Note You can group several elements together to make one image or part of the pictograph Grouping all of the images will prevent the pictograph from stretching 239 Using Libraries to Store Charts and Images Figure 16 2 Creating a stretched pictograph Yo About Chart Templates A chart template is simply a chart that you save in a library with its formatting but without its associated data You choose data to plot when you actually apply the template to a canvas You can make chart templates available in the Chart Gallery by loading your library into the Chart Gallery When you create a chart template give some thought to your data range and color schemes For example if you create a chart template with a custom value axis range of 0 to 20 you will not be able to see any data values above 20 even if your plotted data range contains values above 20 unless you first change the axis scale to display the higher values If your data values vary widely use the automatic settings for the axis controls to let DeltaGraph calculate the best axis range If your chart template uses custom or scheme colors that are different from the current schemes make sure that you open the matching color schemes so that your colors will display properly For example if you assign blue to the f
144. o a standard score To do this the computer determines the mean of all values in the source column and then calculates the deviation absolute value of the difference of each source value from the mean It converts the difference to a number of standard deviation units and writes that number to the corresponding cell in the destination column Syntax ZScore one column Example ZScore A Chapter 3 Creating Charts DeltaGraph offers an extensive selection of chart types Whether you are an engineer marketing manager or financial analyst DeltaGraph has the right chart for your data With more than 80 customizable chart types DeltaGraph provides you with virtually endless ways of visually presenting your data You can create charts using either the Chart Wizard or the Chart Gallery The Chart Wizard steps you through each stage of the process while the Chart Gallery provides all of the controls that you need within a single dialog box You may want to use the Chart Wizard the first few times that you create a chart until you become more familiar with the process or you may decide that you prefer its more linear approach to that of the Chart Gallery For information about specific chart types as well as what types of data they are suited for see the chapters that follow Chart Wizard Choose a Chart Category This panel of the Chart Wizard lets you choose your chart category The area on the left displays a thumbnail image of
145. objects on the current chart canvas and its background Resolution Specifies the resolution of the exported image file in pixels per inch To Export Image Files 4 You can export charts and the objects that they contain as images which you can then access through your favorite image editing application If you want to export specific objects rather than the entire chart select them before you begin Click the Chart window to make it active From the menus choose File Export Image In the Export Image dialog box choose whether you want to export selected objects all objects or the entire chart canvas Click the Save button In the Save As dialog box browse to the directory in which you want to save the file In the File Name text box type a name for the exported file In the Save as Type drop down list choose a file type Click Save Copying and Duplicating Charts and Objects The copy and duplicate functions handle chart data differently If you copy a chart the paste function inserts a copy of the chart data into a new data sheet and places the chart on the active page If you duplicate a chart the duplicate chart uses the same data sheet as the original chart and the duplicate appears slightly offset from the original chart 201 Working with Chart Objects If you copy an object you can paste the object onto any page Also dragging an object to a different document does not move the object
146. odify Data Do one of the following m Toreplace the cell contents click the cell and type the new text in the cell or in the cell contents area on the Data window toolbar m To edit the existing contents double click the cell and make changes as necessary Press Enter To Add Columns and Rows New rows shift the cells down while new columns shift the cells to the right Click a cell to select it as the insertion point 25 Preparing the Data From the menus choose Data Insert Row or Column Tip You can also add columns and rows by right clicking the data grid and choosing Insert Row or Insert Column To Remove Columns and Rows Click the label of the column or row that you want to delete From the menus choose Data Delete Row or Column Tip You can also remove columns and rows by right clicking the column or row and choosing Delete Row or Delete Column To Resize Columns or Rows In the Data window hover your mouse pointer over the split between two column or row headers until the mouse pointer becomes a double headed arrow Click and drag until the columns or rows are the size you want To Transpose Columns and Rows You can switch the position of rows and columns in the Data window so that rows become columns and columns become rows From the menus choose Data Transpose Note This affects all of the columns and rows in the data sheet not just the selected data
147. odify Pictograph Alignment Select the pictograph From the menus choose Format Pictograph In the Anchor drop down list choose a different alignment setting The thumbnail on the right displays a preview of the selected option Click OK To Use an Image as a Chart Background Select the chart Drag the image from the Libraries window onto the selected chart In the Pictographs dialog box select Align to plot frame Deselect the Hide fill line check box Click OK 238 Chapter 16 To Create a Stretch Pictograph In a stretch pictograph the size of the image reflects the data For example if you use a pencil to represent the number of students in various schools the body of the pencil stretches as the number of students increases With a two piece image the top image remains the same size while the bottom image stretches to fill the selected object With a three piece image the middle image stretches to fill the space The destination object does not determine the orientation of the pictograph For best results size your pictograph so that it is no wider than the destination object Create or import two or three images that you want to use to create the pictograph Position the images so that they appear as one complete object Select the images and from the menus choose Format Align If the pictograph contains three images select the middle image and from the me
148. olumn is the baseline and each subsequent data column is stacked in a series Each row of data corresponds to a single segmented bar graphic category Each series of data corresponds to a colored segment in a bar graphic Row labels name each category and column labels name each data series Figure 4 6 Floating stacked column chart aaao A D B l Division 1 Division 2 Division 3 Division 4 North merica 50 52 12 70 Europe 60 37 15 65 Asia 20 11 18 78 Cell G 6 For Help press F1 NUM Asia Europe North America 0 20 40 60 80 100 120 140 160 180 200 72 Chapter 4 Build Up Charts Build up charts typically show a progression of values that make up the total sum Each category s bar starts where the previous one leaves off For example you might plot a starting sales figure and then build it up monthly with each month s sales appearing in a separate category The final category s ending value would be the cumulative sales figure You could also plot conference attendance across several days Setting up your data Data rows correspond to categories while data columns corre spond to series Row labels name each category column labels name each data series Figure 4 7 Build up chart Data for barcol BE Tuesday Wednesday Cell D 5 For Help press F1 2500 2000 1500 1000 500 Monday Tuesday Wednesday Conferen
149. on Select to create bright or saturated images for business presentations This sacrifices the exact color representation to maintain color vividness when converting from one color space to another m Perceptual Select to improve the appearance of scanned graphics This compresses the gamut of one device s color space into the gamut of another device s color space when colors in the original image are out of the gamut of the destination color space Color Illuminant Select a light source intensity D65 uses a brighter light source than D50 and produces lighter values Include color profiles on export Select to include a color profile usually an RGB profile when exporting objects from the document window However eps files embed a CMYK profile within the postscript for printing and embed an RGB profile for the tiff preview image 276 Chapter 19 Read color profiles during import Select to import the color profile when importing files DeltaGraph uses a profile to profile color conversion to map the source colors into the current working space monitor profile based upon the embedded source profile Show RGB Profile Colors Select to display color squares in the Edit Colors dialog box to enable closer color management with RGB image exports Note The following file formats support color profile embedding and extracting jpeg png tiff pict qtif and eps To Modify Profile Preferences From the menus choose
150. ond example meaningful bins in column B must be defined If the data values range from 15 35 and you want the data to be grouped in bins incremented by 5 column B should contain the values 15 20 25 30 and 35 The output for the first cell in your destination column would be the number of values in column A that are less than 15 The output for the second cell would be the number of values in column A that are greater than or equal to 15 but less than 20 and so on for each bin up to the last values greater than or equal to 35 FreqL Function Often used in conjunction with the Freq function this function automatically generates labels that you can use in bar or column charts custom histograms You define bins or categories of numbers by referring to an additional column containing bounding specs The source column is compared to the bounding specs and a label for each bin is output For example if your source data values range from 15 35 and your bounding specs are 45 Preparing the Data 15 20 25 30 and 35 then your output would be 15 20 for the first bin 20 25 for the second bin etc 15 20 means greater than or equal to 15 but less than 20 If you use bounding specs the default rounding flag is less than parameter is 0 To specify a rounding flag of less than or equal to use 1 for the rounding flag parameter If you elect not to specify a column for bins your output is simply an ordered list of all values in yo
151. or the back left axis Primary By default each chart contains a primary value axis on the left and a primary category axis on the bottom Secondary Value axes and category axes may have a secondary axis displayed opposite the primary axis The secondary axis can display the same axis scale as the primary axis or a different one For example a primary axis may display degrees in Fahrenheit while the secondary axis displays degrees in Celsius Overlay An overlay chart combines two different types of numeric data For example in a column chart representing revenue the line overlay may represent expenses The primary value axis displays the scale of revenue in millions of dollars and the overlay value axis displays the scale of expenses in thousands of dollars You must add an overlay chart to display an overlay axis Angle Polar charts use a unique axis system consisting of a radius and an angle The angle axis sets the reference angle Bubble Bubble charts use a supplementary axis legend to represent a third data value with bubbles of varying size Radius XY vector charts use a radius axis to represent a third data value with vectors of varying length if you choose to compute the end points using radii and angles Polar charts use a radius axis to set the distance from the center of the plot to its edge Segmentation These charts use a supplementary axis legend to represent a third data value with segments of varying width 167
152. osses from natural and man made disasters Setting up your data Each column of data corresponds to one ribbon or data series on the chart You can have more than one series per data sheet Row labels name each category and column labels name each series These will appear in the legend Figure 10 2 3 D ribbon chart Data for 3dcharts 7 3 2 4 5 7 8 8 7 6 6 7 7 6 4 6 5 4 Cell F 18 For Help press F1 148 Chapter 10 3 D Scatter Charts The 3 D scatter chart plots data points created by the intersection of three different coordinate values Those points are connected to one of the chart planes with a drop line Each of the three values that make up a point corresponds to a particular axis in a 3 D grid For example you could explore high and low temperatures and precipitation for various locations Setting up your data Each data series requires three columns of data The first column contains the values for the x coordinate points the second column contains the y coordinate points and the third column contains the z coordinate points The column label for the first data column of each series names the series The labels will appear in the legend 149 3 D Charts Figure 10 3 3 D scatter chart Data for 3dcharts BE Cell 1 8 For Help press F1 New England J Plains EE Low Temperature _ NN Ne va DU A 68 150 Chapter 10
153. ou want to create more than one calculated column click Calculate Now when you are finished with the formula for the first column This creates your first calculated data column You can then create the next calculated column without first returning to the Data window m Youcan also access the Formula Builder by clicking the Formula Builder tool on the Data window toolbar To Regenerate Calculated Columns Calculated columns reflect the initial values of the data that you used to create them If you subsequently make changes to the source data you must regenerate the calculated column to reflect those changes To update the charts associated with the data click the Update All Charts tool on the Data window toolbar From the menus choose Data Recalculate Formulas 42 Chapter 2 Tip You can also update your calculated data by clicking the Recalculate Formulas tool on the Data window toolbar Functions List The Formula Builder contains a number of mathematical functions to help you create calculated data items The topics in this section provide brief descriptions of each function The syntax entries shown in square brackets are optional Abs Function Writes the absolute value of each number in the source column to the corresponding cell in the destination column Syntax Abs one column or number Examples Abs A Abs 9 Avg Function Writes the average of each row of numbers for two or more source columns to the
154. pes o oo o 196 To Draw Polygons o o e 197 Insert Image e ru Er A AA AA a e 198 To Import Images o o 199 Export Image Dialog BOX o o 199 To Export Image Files o 200 Copying and Duplicating Charts and Objects 200 To Copy a Chart and Data o o 201 To Copy a Chart without Copying the Data 201 To Move Objects to a Different Page 201 To Move Objects on a Page o 202 To Group Objects oo a o a eG 202 To Ungroup Objects o o 0 000000 203 To Change the Order of Layered Objects 203 To Lock Objects hd oe ne a A wd 203 Lo Rip Objects aes on Leet wa Yes Edam ea be wea Ale 204 To Rotate Objects soyai aus oe A a este noe we ania ie a ey 204 To Align Objects a ae ee Be boy ee ew bs 204 14 Equations Error Bars and Curve Fits 205 Equations cy 2 2 208 SE Coe Ze BES aS DAS GI BA 205 To Add Equations to a Chart Canvas 205 Error Bats eta is faded dy a Dt AO ke dc dal etd a 206 Configuring Error Bars oo o 207 Curve His da A A AGS e 209 Configuring Curve Fits o e 210 Custom Curve Fits gt r ceee a iee e ee 212 Custom Curve Fit Lage desa a a a Gh ee 213 To Create a Custom Curve 217 To Open a Custom Curve Fit o
155. ple 10 Sample 15 Sample 20 Cell 1 18 For Help press F1 153 3 D Charts Sample 1 Sample 20 3 D Wireframe Charts A 3 D wireframe chart shows surface variations based on two sets of evenly spaced values For example a product developer could see which fabric type and which fabric count is the strongest Setting up your data This chart requires at least two series and two categories per chart The x and y axis represent the fixed intervals The row and column labels name the categories and the series 154 Chapter 10 155 3 D Charts 3 D Surface Fill Charts A 3 D surface fill chart shows surface variations based on two sets of evenly spaced values For example an engineer could demonstrate how much fuel turns to vapor with increased temperatures in various fuel tank prototypes Setting up your data This chart requires at least two series and two categories per chart The x and y axis represent the fixed intervals The row and column labels name the categories and series Figure 10 7 3 D surface fill chart Tank Tank B Tank C Tank D a 00 0 00 0 0 00 0 amp Cell 11 For Help press F1 156 Chapter 10 3 D Surface Line Charts A 3 D surface line chart shows surface variations based on two sets of evenly spaced values For example a plant grower could determine the best amount of light to increase the growth of various flowers Setting up yo
156. r Colors and Patterns to determine how to differentiate series Update charts automatically Select to automatically update charts if any changes are made to the source data for the chart s Text To set the default text appearance for chart labels click Text Choose the desired text properties and then click OK Tick Marks To set the default axis tick appearance click Tick Marks Choose the desired measurements and then click OK Symbols To set the default appearance of symbols click Symbols Choose the desired symbol properties and then click OK 267 Customizing the DeltaGraph Desktop Reduce superscripts and subscripts Select to automatically reduce superscripts and subscripts by 20 Use perspective labels for 3D charts Select to position chart labels at an angle to the chart axis To Modify Chart Preferences From the menus choose Edit Preferences Click the Charts tab Make the desired selections Click OK Chart Text Preferences You can use the Format Object dialog box to set default text properties for chart labels Figure 19 4 Format Object dialog box Format Object Xx Text l Effects Drag white letter to set shadow Font E Arial y mi ro Sumer Subscript Size 9 x Ta pee I Strikeout Color E T Underline Alignment Script tar Horizontal o pts Westen y Color MH ES Western oe Vertical fo pts Continue Cancel
157. r Rows o o 25 To Transpose Columns and Rows o 25 To Plot Data Series from Rows o a 26 Formatting Dala tae tdo be ee ee Ee te 26 Format Cells Data Type o o 26 To Format by Data Type o oo 30 To Format Label CellS o ip Cue a ina a a 30 To Treat Date Time or Numeric Data as Text 31 Format Cells Texts 4 won it ee ee OH A a 31 To Change Text Properties o oo o 33 Format Cells Appearance 2 2 2 o 33 To Change the Alignment of Data 35 To Add Cell Borders o o e 36 To Change the Cell Color o o 36 Sort Dialog BOX y coc Rd Se OE Ra SE e NA 37 ToSsSort Datas II AAA a ae We Ps 38 Labeling Data aoe ce eae ee eee E PG 38 To Add Column or Row Labels 39 Calculated Data o oa ceee a a ee ee ee 39 Formula Builder aaa a 39 To Create Calculated Columns aooo 41 vi To Regenerate Calculated Columns 41 Functions List cai ear ewe oes BAER aes 42 3 Creating Charts 51 Chart Wizard Choose a Chart Category 51 Chart Wizard Choose a Chart Type 0 52 Chart Wizard Pick Data o o 53 Chart Wizard Add Titles o o 53 Chart Wizard Chart Placement a 54 To Use the Chart Wizard o o o o oo 55 ChartiGallery vs 2 a ae a S
158. r overlay Floating stacked column chart with step overlay Floating stacked column chart with area overlay Setting Up Saving and Exporting Documents When you first launch DeltaGraph it automatically opens a new document You can use this document to create new charts or you can open a DeltaGraph document from a previous session The Document Manager shows you which documents you have open A saved DeltaGraph 5 document has the extension dg3 and includes any data that you have imported along with all of the charts that you have created You can also save charts and data separately by exporting charts as images and exporting data as data files 3 Welcome to DeltaGraph 5 Exporting Data Files You can export data as any of the following file types SPSS sav Excel xls Lotus 1 2 3 wks wkl wk2 dBASE II dbf dBASE II I V Clipper FoxPro dbf Paradox db Quattro wkq Symphony wks Delimited Text txt dat csv asc Exporting Charts as Images You can export charts and chart objects as any of the following file types bmp Windows bitmap Jpg JFIF JPEG image pntg MACPaint bitmap psd Adobe PhotoShop image png Portable Network Graphics pct QuickDraw PICT image qtif QuickTime image sgi Silicon Graphics tga Targa bitmap tif TIFF bitmap eps Encapsulated PostScript file wmf Windows Metafile emf Enhanced Windows Metafile 4 Chapter 1 To C
159. reate Documents From the menus choose File New Tip You can also create a new document by clicking the New Document tool on the Standard toolbar To Open Documents From the menus choose File Open In the Open dialog box browse to the location of the document and select it Click Open Tip You can also open a document by clicking the Open tool on the Standard toolbar To Save Documents From the menus choose File Save Inthe Save As dialog box browse to the directory in which you want to save the document In the File name text box type a name for the document Click Save Tip You can also save a document by clicking the Save tool on the Standard toolbar 5 Welcome to DeltaGraph 5 Document Setup You can use the Document Setup dialog box to specify the size of the chart canvas and to add headers and footers to the document Figure 1 1 Document Setup dialog box Document Setup x Canvas Base Size Width 95 Height 11 0 Units Inches y I Show Header Footer Properties Cancel Help Base Size Specifies the size of the canvas Click a size in the list to select it Width Displays the width of the size selected in the list to the left If you have selected Custom enter a value into the box Height Displays the height of the size selected in the list to the left If you have selected Custom enter a value into the box Uni
160. rences between values For example you could examine the relationship between real estate sales profits and neighborhoods Setting up your data Each data series has two adjacent columns of data The first column contains the x coordinate of the point and the second column contains the y coordinate of the point Because the XY column chart uses values on both axes there are no category axis labels 13 Bar and Column Charts Figure 4 9 XY column chart Label 4 des Neighborhood 4 Neighborhood B Mm 3 4 5 6 7 8 9 _ b o 4 gt lip stack build up xy column Cell F 11 For Help press F1 MM Neighborhood A Neighborhood B O 10 20 30 40 50 60 70 80 90 100 Sales vs Profits by Neighborhood Chapter 5 Line Step and Range Charts Line charts show trends over time while step charts compare items that do not necessarily show a trend A range chart shows highs and lows such as the high and low temperature for a day This chapter describes the following chart types Line charts Step charts Range charts Open high low close charts High low charts High low close charts Volume open high low close charts Candlestick charts XY line charts Paired XY line charts Time line charts Line Charts Line charts show trends among data points over a period of time Line charts are best for plotting long series of data points For example you could see if ther
161. represents a value in the data sheet The vertical or y axis shows values the horizontal or x axis shows categories Row labels name each category and column labels name each data series Figure 4 1 Column chart Data for barcol 2 4 cee ia 5 4 m o wj o s Cell 4 13 For Help press F1 65 Bar and Column Charts 70 60 50 40 30 20 90 91 92 93 94 95 96 97 98 Home Runs Stacked Bar and Column Charts Stacked bar and column charts show how all categories in a series compare over time or compare parts to a sum For example a sportscaster could display the number and types of hits a baseball player makes Setting up your data Each row of data corresponds to one segmented bar category Each column of data corresponds to one segment of the bar in the chart Each bar segment represents a value in the data sheet The y axis shows categories the x axis shows values The series are stacked one after another within a single bar rather than placed side by side as in a regular bar chart Row labels name each category and column labels name each data series These labels appear in the legend 66 Chapter 4 Figure 4 2 Stacked column chart Data for barcol BE A B G D Home Runs Triples Doubles Singles 0 1 2 5 6 3 2 4 0 4 fi column stacked segementati Cell LabelLabel For Help press F1 200 Singles 180 Double
162. ries Charts and chart templates which are simply charts that are saved without data are stored on the Chart Templates tab while images which can be used as pictographs or simply as graphics are stored on the Pictographs tab Open the library to which you want to add the item Select the item in the chart window From the menus choose Insert Add to Library Tip You can also drag and drop the image into the Libraries window The Libraries window automatically places the item on the correct tab To Rename Library Items In the Libraries window right click the item and choose Rename Enter a new name for the item Press Enter To Delete Library Items In the Libraries window right click the item and choose Delete In the Delete Library Item dialog box click Yes To Use Library Items in Documents Open the library that contains the item that you want to use 234 Chapter 16 Do one of the following m Touse an image as a pictograph select the chart element that you want represented by the pictograph and drag the image onto it In the Pictographs dialog box choose a scaling type and click OK m Touseachart template drag the template onto the chart canvas Select the data that you want to use in the Data window and click Plot Chart m To use an image on a chart canvas drag the image to the desired location on the canvas m To use a stored chart drag the chart onto the appropriate cha
163. ries are represented as concentric circles within the main pie For example you can compare the number of units sold by age group and region Setting up your data The stacked pie chart requires at least two data series or columns of data and at least two categories or rows of data Row labels name each pie slice and column labels name the pies in the stack Figure 7 5 Stacked pie charts Data for areapie A B 20 s 30 s 40 s 50 s 60 s 70 s a gt poderea pe Cell K 7 For Help press F1 Ey ea D 113 Area Pie and Table Charts Units Sold by Age Group and Region West East North 20 s 30 s 40 s 50 s 60 s 70 s South Noth O East South West Multiple Pie Charts A multiple pie chart shows the relationship of the parts to the whole for two or more data series It plots a separate pie for each series For example you can compare the number of units sold by income bracket and region Setting up your data This requires at least two data series or columns of data and at least two categories or rows of data Each wedge of the pie represents a row value Row labels name each pie slice these labels also appear in the legend Column labels name each pie 114 Chapter 7 Figure 7 6 Multiple pie charts Data for areapie BE B E D Middle High Very High pie stacked pie multiple pie Cell J 7 For Help press F1 Sales by Income and Region Low H
164. rt canvas Adding Pictographs to Charts Pictographs are images that you apply to chart elements to represent the data For example you could add a pictograph of a dollar sign to a bar chart to represent revenue The image of the dollar sign appears in the bars of the chart Pictographs are small easily scalable vector drawings that can be filled with vector or raster images Pictographs You can use the Pictographs dialog box to choose formatting options for pictographs 235 Using Libraries to Store Charts and Images Figure 16 1 Pictographs dialog box Pictographs x Example Type Stacked Proportional Anchor Center IF Align to plot frame F Overlap edges P Hide fill line F Remove Pictographic OK Cancel Apply Help Type Determines the type of scaling used to display the pictograph in the selected object The thumbnail on the right displays a preview of the selected option Anchor Determines the starting point for tiling or alignment of scaled images Align to plot frame Select to align the image to the plot frame of any 2 D chart or to the actual bounding box of a 3 D chart This option is available only 1f you drop an image onto a chart element Overlap edges Select to prevent overlapping edges Hide fill line Select to hide the destination object lines and fills when you apply a pictograph Remove Pictograph Select to remove the pictograph from the chart or ob
165. rve type or function Change the options as necessary Click OK Custom Curve Fits You can define your own curve fits by choosing functions to represent or describe your data When you fit a linear curve to a scatter chart for example the software picks the best values of a and b such that the plotted function lies as close as possible to the data points according to the linear least squares method However as long as both axes follow a linear scale this curve is not curvy at all it is always a straight line Other curve fit options for example a second degree polynomial may give a curvier curve but each curve fit type has a limited set of possibilities Fitting your own curves offers more freedom to define particular curves For example a linear curve fit uses only addition and multiplication and the two parameters a and b Custom defined curve fits can use any operators any functions with a few restrictions on the arguments for some functions and any number of parameters 213 Equations Error Bars and Curve Fits Custom Curve Fit You can use the Custom Curve Fit dialog box to define your own custom curve fits Figure 14 4 Custom Curve Fit dialog box Custom Curve Fit El Model Estimation Independent Variable Formula Maximum Liquidity Melting b m T emp Iterations Parameters Minimum 0 1 im i Chi S quare Weights Constants i 5 b 5 y Reinitialize
166. s 160 140 Triples 120 Home Runs 100 80 60 40 20 0 1990 1991 1992 1993 1994 1995 1996 1997 1998 Career Baseball Hits 67 Bar and Column Charts Bar and Column Segmentation Charts Segmentation charts let you add a second value to a column or bar chart This second value is represented by the comparative widths of each column or bar Segmentation charts are also referred to as variable width column charts The width of the column showing the greatest second value is represented at 100 with the other columns represented as proportions In addition to series legends segmentation charts display segmentation legends by default Column and bar segmentation charts show two values per series As with column charts they are especially effective in showing dramatic changes between categories In particular you can show that series perform in markedly different ways between two sets of values For example you could see if there was a significant difference in rainfall based on temperature Setting up your data Place category names in the Label column Each series of data requires two columns In the first column enter values representing the height or length of the bar graphic The label that you enter at the top of the first column will appear in the legend In the series second column enter values representing the width of the column which will be displayed again
167. s 171 172 modifying 172 moving 173 sizing 173 libraries about 231 closing 232 creating 232 deleting items 233 loading at startup 277 opening 232 renaming items 233 using 233 235 240 241 viewing 231 Libraries window moving 261 showing or hiding 231 line charts 77 88 122 147 Line Color tool 182 Line Dash Style tool 183 Line tool 185 194 Line Width tool 183 linear curve fitting 210 lines 181 190 Bezier curves 194 195 curves 195 drawing 194 196 modifying 185 195 196 linking backgrounds 228 230 charts in other applications 256 to external data files 22 Links dialog box 21 lists creating 192 locking objects 203 logarithm for curve fitting 210 Logarithm function 45 margins 191 Marimekko charts 74 master backgrounds 229 Maximum function 46 47 Mean function 42 Median function 45 46 Minimum Value function 46 Modulus function 46 Natural Logarithm function 45 navigating the Data window 13 new features in DeltaGraph 1 2 np Charts 140 null characters in labels and titles 30 number of defectives np charts 140 number of defects c charts 142 numeric data 30 31 objects 199 aligning 204 287 copying 200 duplicating 200 exporting as graphics 200 filling 179 180 flipping 204 formatting 188 grouping 202 importing 199 layering 203 locking 203 moving 202 rotating 204 ungrouping 203 unlocking 203 ogive charts 130
168. s open Figure 3 3 Chart Wizard Pick Data Chart Wizard Pick Data Binning Col L Selected Columns Binnin Select the binning values by clicking on a column in the worksheet a Col Column 4 1 ae Help Cancel Finish Chart Wizard Add Titles This panel of the Chart Wizard lets you specify chart and axis titles Chart title Specifies the title for the chart The default chart title is the chart type You can type a new name for the chart X Axis Title Specifies the title for the x axis Y Axis Title Specifies the title for the y axis Z Axis Title Specifies the title for the z axis This option is available only if you have chosen a 3 D chart You can select axis titles in any of the following ways m Click one of the axis title boxes and type in the coordinates of the cell that you want to use as a title m Click one of the axis title boxes and in the Data window click the cell that you want to use 54 Chapter 3 Choose one of the axis titles in the drop down list The list contains the titles you have used most recently Figure 3 4 Chart Wizard Add Titles Chart Wizard Add Titles Select Axis Titles Mr tale Fe ww Enter specialized chart or axis titles for the new chart Histogram Chart X x Axis Title Year y Y Axis Title Average Sales y Z Axis Title z Help Cancel lt Back Next gt Finish Chart Wizard
169. s preferences because the symbol color is tied into the series color of specific charts Size Select a size Character Select a character or symbol Key Select a character symbol by entering a keyboard stroke To Set Default Symbol Properties From the menus choose Edit Preferences Click the Charts tab Click Symbols In the Series list select the chart series whose properties you wish to modify You can select up to 21 possible chart series Make the desired selections Click OK Click OK in the Preferences dialog box 272 Chapter 19 Preferences Data You can use the Data tab in the Preferences dialog box to set defaults for the century range and data text properties Figure 19 7 Preferences Data tab Preferences El General Charts Data Profiles Libraries Drawing Toolbox Century Range for Two Digit Years Begin Year 1930 End Year 2029 Custom Begin Year 1900 End Year 1999 New Worksheets CellT ext Cancel Apply Help Automatic Automatically defines the century value of date format data entered with two digits The range begins 69 years prior to the current date and ends 30 years after the current date Custom Defines the century value with a custom range for date format data entered with two digits Enter a four digit year for the beginning of the century range New Worksheets To set the default font appearance for data values clic
170. s that appear To complete the equation from the menus choose File Exit and Return Note For additional assistance with the Equation Editor use the Help menu within the Equation Editor When the Equation Editor is open F1 or the standard Help menu opens the Equation Editor Help Error Bars Error bars graphically illustrate errors confidence intervals or spreads in your data For example for some survey results you might show experimental errors in measurement or a 95 percent confidence interval Error bars appear as two short dashes called caps for the upper and lower values of the spread with a vertical line connecting the two dashes The measurement of the error bar can reflect the individual error of each data point the standard deviation or standard error of one or multiple series a specified numeric value or a specified percentage You can add error bars to the following types of charts Bar and column Bar and column segmentation Intensity scatter Line Paired intensity scatter Paired XY line Paired scatter Scatter Step XY column XY line 207 Equations Error Bars and Curve Fits Configuring Error Bars You can use the Error Bars dialog box to add error bars to selected charts Scatter intensity scatter paired intensity scatter XY column and XY line charts support error bars for both axes or dimensions You can display error bars for the X dimension and or the Y dimension Figure 14 2
171. s use circular shaped graphics on a grid to represent a third value For example a catalog order company could explore the effectiveness of various promotions on product sales Setting up your data In a bubble chart each data series requires three columns of data the first column produces the values for the x coordinate points the second column produces the y coordinate points and the third column determines the size of the bubbles Each data point represents a measurement that is the intersection of two values in a row and the diameter of a bubble All of the coordinates entered in a bubble chart measure values therefore both axes show values To label each data series enter labels above each column of x coordinates in the data sheet these labels appear in the chart legend A separate value legend provides a scale for the bubble size To change the size of the bubbles with respect to the data in the z component click and drag on the end of the small axis in the bubble size legend Stretching the legend axis makes the bubbles bigger shrinking the legend makes the bubbles smaller To ensure that you do not have bubbles covering each other change the fill of all the bubbles to None Figure 6 6 Bubble chart Data for scatter BE eee E Product Promo Cost Promo Sales ProductB Promo Cost Promo Sales Cell 4 6 For Help press F1 101 Scatter Charts Product A Product B 0 500 1000
172. size of the symbols Select the chart 173 Axes Symbols and Legends From the menus choose Chart Legend To Format the Legend Appearance You can use the Format Object dialog box to change the color line width or other aspects of the legend s appearance Select the legend frame or legend symbol From the menus choose Format object name Make the desired changes Click OK To Move the Legend Click the legend and drag to a new position To Change the Size of the Legend Click the legend Use the drag handles to change the size or dimensions of the legend frame Showing Values You can label the data graphics in a chart to add more detail or to show the exact value For example you can add numeric values and or percents to each piece of a pie chart show what percentage of the whole each column in a column chart represents or add category labels to a chart that has no category axis This command is available for the following charts stacked bar column stacked build up floating bar column all 174 Chapter 12 segmentation line step all pie paired scatter paired XY line XYZ contour line bubble polar ternary spider histogram Pareto and ogive Show Values Dialog Box You can use the Show Values dialog box to display values categories and percentages in a chart Figure 12 4 Show Values dialog box Show Values x m Base Chart
173. spectively The whiskers extend from the 10th percentile bottom decile and the top 90th percentile top decile While the box chart does not display individual outliers outlier caps appear at the top and bottom of the decile whiskers Any value falling beyond these caps is considered an outlier The symbol within the box represents the mean for the data range For example a real estate agent could compare land values in the various areas of the city Setting up your data Each row corresponds to a box or category Row labels are used to name each box while the column labels become the categorical labels in your box chart Figure 9 4 Box chart Data for Document 1 BEI ili 9 A amp 2 Sample 1 Sample 2 Sample 3 Cell J 3 For Help press F1 134 Chapter 9 12 10 Sample 1 Sample 2 Sample 3 Survival Charts Survival charts plot surviving elements expressed either as absolute numbers or as percentages A stepped line traces the gradual decline in survival rate For example a chart might show the survival of patients during an epidemic The plot typically starts at 100 but could begin at any starting numeric value that you enter on the y axis For example a chemical company researcher could report the effectiveness of a substance as a disinfectant Setting up your data In column A enter periods of time elapsed concentration of a chemical or other values In column B enter the number of surv
174. st the segmentation legend You can create multiple series in segmentation charts by entering two columns of data for each series Figure 4 3 Column segmentation chart Data for barcol mE January April July October Cell U 5 For Help press F1 68 Chapter 4 90 M Anchorage 30 BM Chicago 70 Miami 60 50 40 30 20 January April July October Temperature and Rainfall by City Stacked Bar and Column Segmentation Charts A stacked bar or column segmentation chart groups series and displays them as a stack with a second value for each series displayed as width With this kind of chart you can clearly show that categories perform in markedly different ways between two sets of values Differences in widths become much more apparent in stacked segmentation charts For example you could see if there was a significant difference in rainfall based on temperature and season Setting up your data Each row represents a bar or column Each series represents a segment within each bar Each series requires two columns of data 69 Bar and Column Charts Figure 4 4 Stacked column segmentation chart Data for barcol fx Anchorage 0 76 53 3 2 33 61 Chicago 3 53 69 3 3 73 80 3 Miami 5 9 85 67 7 43 89 Cell K 5 For Help press Fl NUM Autumn Summer Spring Winter Anchorage Chicago Miami Rainfall and Temperature
175. t based on the ascending order of the x coordinates For example a farmer could display the crop yields from various fields Setting up your data Each data series uses the same x coordinates The first column contains the x coordinates The second and following columns contain the y coordinates Each series is plotted in the ascending order of the x values 89 Line Step and Range Charts Figure 5 9 XY line chart Data for line BE Cell H 9 For Help press F1 0 1 2 3 4 5 6 7 8 Crop Yield by Field 90 Chapter 5 Paired XY Line Charts Paired XY line charts show the relationship between data points from one or more data series Each x coordinate is paired with a corresponding y coordinate A line connects each data point to the next based on the ascending order of the coordinates For example a financial analyst could report values for the GNP on a total and per capita basis Setting up your data Each data series has two adjacent columns of data The first column contains the x coordinate of the point and the second column contains the y coordinate of the point Each series is plotted in the ascending order of the x values To label each data series of a paired XY line chart enter labels over each column of y coordinates Because the paired XY line chart uses values on both axes there are no category axis labels If you want your data to remain unsorted create a paired
176. t will appear on your monitor Compare this to how the color appears in the CMYK color space which is used by most printers If you have chosen to show the RGB color swatch in the Color Edit dialog box available from the Preferences dialog box this swatch shows how the color will look on the RGB device described by the current RGB color profile This is useful for generating color calibrated RGB image files System Colors Opens the Color dialog box Use to select a new system color to add to the palette PANTONE Colors Opens the PANTONE Color Picker dialog box Use to select a PANTONE color to add to the palette 247 Preparing Your Document for Printing PANTONE Color Name Displays the name of the selected PANTONE color CMYK Displays the selected color as it will appear when printed using CMYK Compare this to how the color appears on your monitor your working space If one of the colors in your document is outside of the range of one of your color devices you can remap to a system color that the device is capable of reproducing RGB Displays the selected color as it will appear when printed using the RGB color model Compare this to how the color appears on your monitor your working space If one of the colors in your document is outside of the range of one of your color devices you can remap to a system color that the device is capable of reproducing Load Opens the Load Palette File dialog box Use to load a previo
177. tern fill Width Choose a line width Custom Enter a value to create a custom line width Dashes Select to create a dashed line Style Click the arrow and choose a line style from the palette Scale Choose the scale or proportion of the dashes Round ends Select to round the ends of the dashes To Change the Line Color Tf the toolbox is not visible from the menus choose View Drawing Toolbox Click the Selection tool and select the line Click the Line Color tool To keep the tool selected double click it Choose a color from the palette Tip You can also use the Format Object dialog box to change the line color 183 Working with Chart Objects To Change the Line Dash Style If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Selection tool and select the line Choose a line style from the palette Tip You can also use the Format Object dialog box to change the line dash style To Change the Line Width If the toolbox is not visible from the menus choose View Drawing Toolbox Click the Selection tool and select the line Click the Line Width tool To keep the tool selected double click it Choose a line width from the palette Tip You can also use the Format Object dialog box to change the line width 184 Chapter 13 Format Object Arrows You can use the Arrows tab in the Format Object dialog box to modify the position
178. that the selected model curve fit type describes the data being fit By minimizing the differences between the equation and the data the model represents the best approximation of a curve based on all data points Spline curve fits are not true curve fits because the curve is not determined by a single function Rather a spline curve is determined by a series of unique functions each function connects one data point to the next in order You can apply curve fits to the following chart types Line Paired scatter Paired XY line Scatter Step XY line 210 Chapter 14 Configuring Curve Fits You can use the Curve Fit dialog box to add curve fits to one or more series in your chart Series Select one or more series Function Choose a function to define the curve type You may want to experiment with the functions because some functions will model different data patterns more effectively None hides any existing curve fits Custom lets you specify the independent variable parameters and constants of the curve fit Formula Displays the mathematical equation and the R squared value for the currently selected function Display Digits Enter a number between 1 and 15 to set the number of decimal digits shown for parameter estimates in the Formula field The number of digits selected does not affect the calculation only what is displayed Direction Choose the direction of the function With Y F x you are trying to predict
179. the Canvas Size 2 o o e 6 To Add Headers or Footers o o e 6 To Edit Headers or Footers 10 To Reposition Headers or Footers 10 To Format Headers or Footers 20 11 2 Preparing the Data 13 Working in the Data Window o 13 To Open Multiple Data Windows o 14 To Show or Hide the Data Window 14 To Roll Up the Data Window 15 To Add Data Sheets o o e 15 To Remove Data Sheets o o 15 To Rename Data SheetS o o e 0200005 16 Bringing Data into DeltaGraph o o 16 Select the Import Range o o 17 To Import Data ss ot bdo se o A A de ale Ee 18 Select the Export Range o o o 18 To Export Dats sirate ee nao a ll Babs 19 To Paste Data into DeltaGraph o ooo 20 Links Dialog Box o o e e 21 To Link to Data in Excel Files 22 To Break Links with Excel Files 22 To Type Data into Cells o o ooo 23 Selecting and Editing Data o o o 23 To Select Datak eto ee a eee 24 To Modity Data ola rar ia ea oak 24 To Add Columns and Rows o o e 24 To Remove Columns and Rows o 25 To Resize Columns o
180. the selected chart category as well as a short description Many chart categories contain subtypes which appear after you select a category Select a chart category from the list and click Next 51 52 Chapter 3 Figure 3 1 Chart Wizard Choose a Chart Category Chart Wizard Create Chart Statistical Includes Histogram Box Plot Pareto Ogive OC Type and Survival Charts Help Cancel Finish Chart Wizard Choose a Chart Type This panel of the Chart Wizard lets you choose the subtype of the chart that you want to create The subtypes that are available depend on the category that you chose on the previous panel The area on the left displays a thumbnail image of the selected subtype as well as a short description Select a subtype from the list and click Next Figure 3 2 Chart Wizard Choose a Chart Type Chart Wizard Create Chart Histogram Chart Chart Types One column of data Data values are binned and placed in ranges represented on the horizontal 4 axis of the chart Chart columns represent frequencies of values in each range The vertical Y axis is the value axis Ogive Chart Pareto Chart QC P Chart QC U Chart OC XBar A Survival Chart Help Cancel Finish 53 Creating Charts Chart Wizard Pick Data You can select data for the chart before you launch the Chart Wizard or you can select 1t in the Data window while the Chart Wizard i
181. tion Defective p and Number of Defectives np Charts 140 Defects Per Unit u and Number of Defects c Charts 142 10 3 D Charts 145 3 D Column Charts a s ura o o e e 145 3 D Ribbon Charts 2 2 0 0 0 00002 eee eee 147 3 D Scatter Charts 2 ee 148 3 D Scatterline Charts o o e 150 3 D Area Charts so s p arias do ee ee a a 151 3 D Wireframe Charts o 153 3 D Surface Fill Charts o 155 3 D Surface Line ChartS o e 156 3 D XYZ Surface Fill Charts o 158 3 D XYZ Surface Line Charts o 159 11 Combination Charts 161 Bar and Column Charts with Line Overlays 161 Stacked Bar and Column Charts with Line Overlay 163 12 Axes Symbols and Legends 165 Types of Chart Axes 2 e a e e 165 To Modify Chart Axis Properties 168 To Format the Chart Axis Appearance 169 Modifying Symbols e 169 Symbols Dialog BOX o e 170 To Modify Chart Symbol Properties 171 Modifying Legends e 171 Legends Dialog Box e 172 To Modify Legend Properties o 172 To Format the Legend Appearance 173 To Move the Legend o e 173 To Change the Size of the Legend
182. tom C Left M Left Center Border Color Right C Right _ AA Cell Color E Example Dur Company ww teo The Cell Border group controls the line style color and thickness of cell borders Cell Border Specifies the style of the border Border Color Specifies the color of the border To change the color click the arrow and choose a color from the palette The Apply To group controls where the borders are placed All Borders Select to apply borders to the top bottom left and right sides of cells Top Select to apply borders to the tops of cells Bottom Select to apply borders to the bottom of cells Left Select to apply borders to the left side of cells 35 Preparing the Data Right Select to apply borders to the right side of cells The Vertical Alignment group controls whether cell contents are aligned to the top bottom or center of cells Top Click to align cell contents to the top of the cell Center Click to align cell contents to the center of the cell Bottom Click to align cell contents to the bottom of the cell The Horizontal Alignment group controls whether cell contents are aligned to the left right or center of cells Left Click to align the cell contents to the left of the cell Center Click to align the contents in the center of the cell Right Click to align the contents to the right of the cell Cell Color Displays the color of the cell background To change t
183. top 180 degrees flips the text box To Display Values or Categories within a Chart Select the chart From the menus choose Chart Show Values Choose a location and text label format Click OK Note If the label will not fit inside the graphic element the label appears outside Tips Here are several tips for working with the Show Values text boxes You can resize the chart for the text box to fit inside the graphic element You change the location or rotation of the text boxes You can click and drag the text box to a different position You can change the fill of the text box to make the label easier to read Change the fill to No Fill to create a transparent text box Chapter 13 Working with Chart Objects Each chart is composed of several elements or objects such as rectangles lines and text You can use either the Format Object dialog box or the formatting tools on the Drawing Toolbox to change an object s appearance Formatting chart objects can include m Changing the color and fill of objects adding shadows m Adding and manipulating graphics and drawing objects on the chart canvas m Adding and formatting text objects Format Object Colors You can use the Colors tab in the Format Object dialog box to change the fill style and foreground and background colors of an object 177 178 Chapter 13 Figure 13 1 Format Object dialog box Colors tab Format Object x Co
184. top list and then choose the column that you want to use to perform the function or calculation Functions Displays the available functions Double click a function to choose it Operators Displays the available operators Click a button to insert its operator into your formula Some of the operators require explanation n Exponentiation For example 10 2 means 10 squared Indicates a row number For example B 4 refers to the entry in the fourth row of column B Used with the Fill function to surround a date or time entry For example July 4 1999 or 11 21 32 Divides a number by 100 For example 25 equals 0 25 Identifies a constant For example True False or Rand Formula Displays the formula as you build it In addition to clicking functions or operators to insert them you can type formulas directly into this area 41 Preparing the Data Column selector buttons The column selector buttons let you choose a destination column for your calculated data To Create Calculated Columns Select the column that will contain the calculated data From the menus choose Data Insert Formula Select a function to use or build your own using operators For information about specific options click the Help button Select source columns from the list or type column letters into the Formula text box Once you are satisfied with the calculation click OK Tips m If y
185. ts An ogive chart uses a line to show the cumulative frequency across ranges The chart automatically divides the data into a set of equal ranges and creates a count total number of values for each range or bin The plotted line represents the cumulative sum of the bin counts It is often useful to overlay an ogive chart over a histogram or Pareto chart To do this select Show Ogive in the Options dialog box For example you could find out which age groups are more likely to purchase a product based on a taste test promotion An ogive overlay would emphasize the sample size Setting up your data Enter your data values into a single column If multiple columns of data are selected the columns are treated as one series Any labels for the categories or series are ignored Ogive bin labels take the place of category labels After you create the chart you can redefine the bins using the Binning tab in the Axis dialog boxes Figure 9 3 Ogive chart Data for stat mE 0 10 20 30 40 50 60 70 80 Age Groups ogive box plot survival Cell H 16 For Help press F1 133 Statistical and Quality Control Charts Box Charts A box chart summarizes the distribution of your data by showing the mean median and quartiles The top bottom and middle line of the box corresponds to the 75th percentile top quartile 25th percentile bottom quartile and 50th percentile median re
186. ts Specifies the unit of measurement Show Header Footer Select to add headers and footers to the document To set header and footer properties click the Properties button to the right Properties Opens the Header Footer Properties dialog box which you can use to set or modify the properties of headers or footers 6 Chapter 1 To Set the Canvas Size From the menus choose File Document Setup Choose a size for the chart canvas from the Base Size list If you choose Custom enter values into the Height and Width text boxes Click OK To Add Headers or Footers From the menus choose File Document Setup Select Show Header Footer Click OK Header Footer Properties Contents You can use the Contents tab in the Header Footer Properties dialog box to specify what is displayed in the header or footer 7 Welcome to DeltaGraph 5 Figure 1 2 Header Footer Properties Contents tab Header Footer Properties E Contents l Position Text M Page Number Page HH of HH I Show on last line I File Name y Use Date and Time At Print M Date Default zl C Save M Time y C Document Creation Page 1 of 3 areapie 7124100 DK Cancel Help Page Number Select to show page numbers Choose a format from the drop down list Show on last line Select to display the page number on the last line of the header or footer File Select to show the fi
187. typically show changes in these values over time For example you could examine how many calls are coming into a customer service center each work day Setting up your data Three columns of data are required for each data series the first two columns produce values for the high and low points and the third column produces values for the midpoints You can have more than one series per data sheet The y axis shows values the x axis shows categories Row labels are used to name each category To name the data series enter a label in the first column of each series these labels appear in the legend 81 Line Step and Range Charts Figure 5 3 Range chart Data for line BE A B Low Calls High Calls Average Cell G 6 For Help press F1 Mon Tues Weds Thurs Fri Call Volume High Low Charts High low charts show the highs and lows for different items or different periods of time They are commonly used for market analysis and are also seen in investment publications 82 Chapter 5 Setting up your data Two columns of data are required for each data series the first column is used for the high point and the second is used for the low point You can have more than one series per data sheet The y axis shows values and the x axis shows categories Row labels are used to name each category To name the data series enter a label in the first column of each series Figure 5 4 High low
188. uld use a 3 D column chart to display product sales by region and business units You could also use a 3 D XYZ surface fill chart to display a pattern among many data values such as elevation longitude and latitude This chapter describes the following chart types 3 D column charts 3 D ribbon charts 3 D scatter charts 3 D scatterline charts 3 D area charts 3 D surface fill charts 3 D surface line charts 3 D wireframe charts 3 D XYZ surface fill charts 3 D XYZ surface line charts 3 D Column Charts A column chart compares one item to another or compares the same or different items over a period of time Column charts effectively show dramatic changes from one category to another For example a financial analyst could display how investors distribute their investments in a region 145 146 Chapter 10 Setting up your data Rows define categories and are displayed along the x axis The columns series are displayed along the z axis The y axis shows values Row labels name each category and column labels name each data series Series labels appear on the chart and in the legend Figure 10 1 3 D column chart Data for 3dcharts BE B E D Cell 1 5 For Help press F1 NUM Investment Distribution 147 3 D Charts 3 D Ribbon Charts The 3 D ribbon chart is a variation of a 2 D line chart It is useful for showing trends in data For example an insurance adjuster could summarize financial l
189. up Click the Properties button In the Header Footer Properties dialog box click the Text tab Do any of the following m To change the font type select a type in the Font drop down list m To change the font style select a style in the Style drop down list m To change the font size select a size from the Size drop down list m To change the color of the text click the Color swatch and select a color from the palette that appears Click OK Chapter 2 Preparing the Data The first stage in creating a chart is to prepare the data that you want to use This includes bringing the data into DeltaGraph and editing and formatting the data as necessary Working in the Data Window Unlike the Data View of previous versions you can leave the new Data window open while you work in the Chart window This makes it possible for you to view your data and charts simultaneously The Data window provides you with many advanced features for organizing and editing your data such as Multiple data sheets that can handle large amounts of data Formatting options for specific data types Individual cell and border formatting Sort features Column and row titles The Formula Builder which you can use to create new calculated columns 14 Chapter 2 Figure 2 1 Data window Data for DeltaGraph RSS Our Company Si ano Al YE Label Label Our Company 1 Company A Company B Company E Ce
190. ur data This chart requires at least two series and two categories per chart The x and y axis represent the fixed intervals The row and column labels name the categories and series 157 Figure 10 8 3 D surface line chart 3 D Charts Data for 3dcharts mE B E Tulip Violet Daisy Cell G 5 For Help press F1 Violet 40 Tulip 158 Chapter 10 3 D XYZ Surface Fill Charts A 3 D XYZ surface fill chart shows three dimensional data One quantity plotted on the z axis varies depending on x and y values producing a solid three dimensional color coded plane An elevation map representing latitude longitude and elevation is an example of a 3 D XYZ surface fill chart For example a sociologist could examine the relationship among the birth rate death rate and literacy rate in various countries Setting up your data Each data series requires three columns of data The first column contains the x coordinates the second column contains the y coordinates and the third column contains the z coordinate points Each data point represents a measurement that is the intersection of the three values in a row You are limited to 32 767 data points when creating an XYZ surface fill chart To label each data series enter labels in the first column of each series in a data sheet Figure 10 9 3 D XYZ surface fill chart 4 gt Jourface ine wy2 til zine 7 Cell 6 13 For Help press F1 159
191. ur source column These list items are enclosed by brackets to indicate exactly equal to for example 25 Syntax FreqL one column one column for bounding spec rounding flag of O or 1 Examples FreqL A FreqL A B En Function Writes the natural logarithm of each value in the source column to the corresponding cell in the destination column Syntax Ln one number or column Examples Ln A Ln 9 Log Function Writes the base 10 logarithm of each value in the source column to the corresponding cell in the destination column Syntax Log one number or column Examples Log A Log 9 Median Function Writes the median of each row for two or more source columns to the corresponding cell in the destination column Syntax Median two or more columns or numbers Examples Median A B C D E Median 45 26 39 22 43 46 Chapter 2 TMedian Function Writes the median of all of the cells in the source column s to the first cell of the destination column Syntax TMedian one or more columns or numbers Examples TMedian A B C D E TMedian B Mn Function Writes the minimum value of a column to the first cell of the destination column Syntax Mn one column Example Mn A Mod Function Divides the first parameter by the second and writes the remainder to the corresponding cell in the destination column Syntax Mod one column one number or column for the divisor Examples Mod A 9 Mod A B In the first examp
192. usly saved color palette Save Displays the Save Palette File dialog box Use to save the current color scheme or custom colors as a dpl color palette file To Change Color Models A color model refers to the way different elements can be combined to create color For example in the 24 bit RGB color model each of more than sixteen million colors is created using a combination of red green and blue light From the menus choose Edit Color Palette Inthe Color Set group click Scheme colors or Custom colors From the Color Model drop down list choose one of the following color models from the list RGB is an additive color model that uses red green and blue to create colors m CMY isa subtractive color model that uses cyan magenta and yellow to create colors m CMYK is a subtractive color model that is based on CMY color but with the addition of a black ink K The black ink allows true black and increases the tonal range of the rest of the colors 248 Chapter 17 m HSL is an additive color model that uses hue saturation and lightness to create colors Hue represents a color such as blue saturation represents color depth and lightness represents the amount of white in the color Click OK Tip You can also access the Edit Colors dialog box by double clicking Scheme Colors or Custom Colors on the Documents tab in the Document Manager To Modify Document Colors From the menus choose Edit
193. want to import the entire worksheet or only a range of cells On the Worksheet Name drop down list choose the worksheet that you want to import In the Destination group choose where you want to insert the new data Click OK Tip You can also access the Select File for Import dialog box by clicking the Import Data tool on the Data window toolbar Select the Export Range You can use the Select the Export Range dialog box to specify a range of data to export and also to specify whether to include row and or column labels in the exported data file 19 Figure 2 3 Select the Export Range dialog box Select the Export Range E m Source Export from Entire Worksheet Selected Cells C Cell Range I Include Column Labels T Include Row Labels OK Select a range of cells to export into file compcost xls Cancel Preparing the Data Entire Worksheet Select to export the entire contents of the data sheet Selected Cells Select to export selected cells only Cell Range Select to export a range of data Include Column Labels Select to include column labels in the exported data file Include Row Labels Select to include row labels in the exported data file To Export Data Click the Data window to make it active From the menus choose File Export Data In the Export to File dialog box browse to the directory in which you want to save the file 20 Chapter 2
194. x 169 Axes Symbols and Legends Tip You can also access the axis dialog box by double clicking the axis or by selecting the chart and using the right click context menu To Format the Chart Axis Appearance You can change the color line width or other aspects of the axis appearance Click the chart Then click the axis component that you want to modify From the menus choose Format object name Make changes as desired Click OK Modifying Symbols Symbols distinguish the various series in a chart DeltaGraph comes with a font DeltaSymbol to display symbols If you share your documents with others the symbols will not display properly unless the others also have the DeltaSymbol font installed You have several options to ensure that the symbols display correctly Download the DeltaSymbol font from the Red Rock Web site www redrocksw com m Use the Built in DeltaGraph symbol setting in the Symbols dialog box The symbols are based on geometric shapes which do not need a font available to display properly m Use a font such as Symbol that will be available on all computers 170 Chapter 12 Symbols Dialog Box You can use the Symbols dialog box to change symbol properties such as color Figure 12 2 Symbols dialog box Symbols x a Style 7 Series 2 C Built in DeltaGraph symbol A Series 3 Font Tr DeltaSymbol Series 4 c Series 5 Library picto
195. xcel Select the range of data that you want to link to your DeltaGraph document From the menus choose Edit Copy Switch back to DeltaGraph In the Data window click a cell to select it as the insertion point From the menus choose Edit Paste Excel Data Link Note To set the data to update manually choose Links Manage Links from the Edit menu select the link in the list and click the Manual radio button Anytime you want to update the data choose Links Manage Links from the Edit menu select the link in the list and click Update Now To Break Links with Excel Files When you break a link with an Excel file the data remain in your document but are no longer updated when you open the document 23 Preparing the Data From the menus choose Edit Links Manage Links In the Links dialog box select the link that you want to break Click Break Link To Type Data into Cells To ensure that your data are plotted correctly remember that a column usually represents a series and a row usually represents a category Click a cell to select it as the insertion point Type in the data Do one of the following m Press Enter to apply the changes and move to the cell below the current one m Press an arrow key to apply the changes and move to the cell in the direction of the arrow Selecting and Editing Data You can edit the contents of the Data window in a variety of ways including m Adding
196. yle Select a location for the ticks relative to the axis Length Enter a value for the length of the ticks To Set Default Tick Mark Properties From the menus choose Edit Preferences Click the Charts tab Click Tick Marks Make the desired selections 270 Chapter 19 Click OK Click OK in the Preferences dialog box Symbols Preferences You can use the Symbols dialog box to set default symbol properties such as font type size and color Figure 19 6 Symbols dialog box Symbols x zs Style Series 2 C Built in DeltaGraph symbol A Series 3 Font Tr DeltaSymbol v Series 4 A Series 5 Library pictograph Series 6 No symbol PI Series 7 Series 8 m Appearance El Series 9 Color m Example Series 10 x Size 12 v a Character W v Key EN coca Series list Displays the current settings for all 21 possible chart series Select all series whose display properties you wish to modify When you select other options in this dialog box only the series you have selected here are affected Built in DeltaGraph symbol Select to use a built in set of symbols that is not dependent on font availability 271 Customizing the DeltaGraph Desktop Font Select a font Library pictograph Select a pictograph to use as a symbol No symbol Select to hide symbols Color This option is disabled when you are setting Symbol
197. you prefer to work in a linear fashion use the Chart Wizard Figure 3 6 Chart Gallery dialog box Chart Gallery x View Thumbnail List Charts 2 D Charts 3 D Charts Tan T 5Pies FT 1Bars Column I 6 Tables IV 2Lines T 7 Contours IV 3 Scatters Tl 8 Statistical I 4 Areas T 9Vectors Source Custom Libraries v Base charts Click to display v F Special charts F Custom Open Library High Low Line Chart ER m Description r Chart Options pe i papi eked ore pa E ais chanel girdled ie Plot Chart On Current Canwa ed ee M Auto plot MV Sample data T Use all data les er Chart Wizard Cancel Help The View group controls how the chart types are displayed in the area to the left Thumbnail Click to display thumbnail images of the chart types List Click to display a list of the chart types The Charts group controls which charts are displayed in the area to the left 2 D Charts Click to show only 2 D charts 57 Creating Charts 3 D Charts Click to show only 3 D charts All Select to show all 2 D or 3 D chart types Bars Columns Select to show all subtypes in the bar and column chart category Lines Select to show all subtypes in the line chart category Scatters Select to show all subtypes in the scatter chart category Areas Select to show all subtypes in the area chart category Pies Select to show all subtypes in the pie ch
198. ze of the cell contents The Effects group controls the formatting of the cell contents Strikeout Draws a line through the selected cell contents Underline Adds an underline to the cell contents 33 Preparing the Data Color Displays the color of the cell contents To change the color click the arrow and choose a color from the palette Script Displays the script type of the cell contents Example Displays how the cell will look using the current settings To Change Text Properties Select the cell s that you want to format From the menus choose Data Format Cells In the Format Cells dialog box click the Text tab Specify the properties as desired Click OK For information about specific options click the Help button Tip You can also access the Format Cells dialog box by clicking the Format Cells tool on the Data window toolbar or by right clicking any cell Format Cells Appearance You can use the Appearance tab in the Format Cells dialog box to control how the data in your cells appear You can specify the horizontal and vertical alignment of the data as well as the cell border style and the background color 34 Chapter 2 Figure 2 9 Format Cells Appearance tab Format Cells x Data Type Text Appearance m Cell Border Vertical Alignment Apply To C Top All Borders Center C Bottom M Top i j Horizontal Alignment M Bot

DeltaGraph 5 User`s Guide for Windows

Contents

Download Pdf Manuals

Related Search

Related Contents