Frequently Asked Questions

1. I HAVE A 3D BAR CHART WITH DATA SHOWN IN SIX SERIES. CAN I CHANGE SOME OF THE SERIES TO SOMETHING OTHER THAN BARS?

2. I HAVE A DATABASE WHICH IS NOT DIRECTLY SUPPORTED IN DATACHART. IS THERE ANY WAY I CAN USE DATACHART WITH IT?

3. WHEN I TRY TO MAKE A CHART FOR MY DATABASE I GET A "GENERAL SQL ERROR" INVOLVING A "SYNTAX ERROR". WHAT CAN I DO ABOUT THIS?

4. WHEN I HIT THE PRINT BUTTON, MY CHART COMES OUT IN 4 PAGES? HOW DO I GET IT ON ONE PAGE?

5. IF I NEED TO SHOW SOME VALUES ON MY CHART AS DIFFERENT FROM THOSE IN MY DATABASE, WHAT CAN I DO?

6. MY INK-JET PRINTER PRINTS CHARTS IN BLACK AND WHITE. HOW DO I GET A COLOR PRINT?

7. MY SURFACE CHART HAS A MIX OF COLORS AT THE VARIOUS CONTOUR LEVELS. HOW CAN I SET THE COLORS SO THEY GO THROUGH A RANGE OF SHADES WHICH I CHOOSE.




1. Yes you can. From the chart toolbar, click the "Change chart options" button (it looks like a bar chart with a wand superimposed). Choose the SERIES tab, and under the TYPE group check the box for MULTIPLE TYPES. You can choose Series one by one from the drop-down box, and for each one click the GALLERY TYPE button, and choose from several chart types for that series. Each series can be individually customized for chart style in this menu as well as color. Also, series shown as a 3D line can have the thickness changed, or series shown as 3D bars can be changed to triangles, circles, or cones.

2. Possibly. If you have an ODBC driver, you can try the following (which might work, depending on particular circumstances): If you have an ODBC driver for your database, you can set up an ODBC Connection, and then use a BDE alias for the ODBC Connection. Then, the alias should be available in DataChart. - In Windows, go Start, Control Panel, Settings, and start the 32-bit ODBC icon. - Create an ODBC connection to your database, using its appropriate ODBC driver. - In the Datachart program group, start the BDEADMIN program and see if the ODBC database connection is listed under the Databases tab. - If it is, you can run Datachart, choose a chart using the EXISTING ALIAS database connection, and choose the new alias corresponding to your ODBC connection. - Continue chart creation

3. DataChart has encountered a problem with your database, which occurs when trying to interpret the underlying SQL for the chart creation. This can sometimes happen with a Database where one or more field names have embedded blanks. In this case, you may have success if you can re-structure the database, or make a copy, where there are no field names with embedded blanks.

4. Click on the "Options:" drop down combo-box, and choose "Chart Spacing" from the drop-down list. In the "Chart Data Spacing" Dialog Box which appears, choose the "Custom" radio button under Horizontal Spacing. Move the marker on the slide bar at the bottom, in order to change the width of the data values along the X-axis. If you make the width narrow enough to show all of your graph on the screen (without a scroll bar), your chart should print on only one page.

5. Once you have created your chart, you can edit the values of some of the entries, if you need to. Click the Tools button (it looks like a hammer) and choose "Data Editor" to toggle it "on". The display changes to a numeric array showing the numbers behind the chart. If you edit these numbers, your chart will reflect the new values. NOTE, this changes only your current chart, it does NOT change the values within any database which you are using. You can go back to the chart view after editing by again clicking the Tools button, and clicking the Data Editor choice, to toggle it "off".

6. DataChart uses the default windows printer. If you set the properties of the default printer to color, your printouts will then be in color. (You may want to remember to change the default values back afterward.)

7. DataChart transposes the series colors (from, say, a bar chart version of the chart) to the contours. So, the Series 1 color becomes the color for the one contour, the Series 2 color becomes the color for the next contour, and so on. By setting the colors for the Series (use the "Change Chart Options" button to access colors on the "Series" tab), you can control the pattern of the contours for the surface chart, PROVIDED the number of contours you have do not exceed the number of series in the chart. You could use the same sort of features to highlight one particular contour, by giving it a distinctive color compared to the other contours. It could also be noted that the "Scale" tab of the same dialog can be used to change the size of the contour gap, thereby changing the number of contours.