Chart type not working with Office 2000
Last post Nov 07, 2019 06:47 PM by Ben-T100
Mar 07, 2005 12:21 PM|Anonymous|LINK
Has anyone been able to get the chart output to work with Microsoft Office 2000. I've tried this on 3 different computers all with Office 2000 and I keep on getting the same error: This output format requires a licensed microsoft office chart web component
to be installed on the local machine. I tried the same script on a machine with Office 2003 and this worked fine. The problem is that I need to run this on a machine with Office 2000.
The script I'm trying to run is the script that generated the site statistics page.
Any help will be much appreciated.
CHART output target
Mar 07, 2005 02:34 PM|Anonymous|LINK
Mar 08, 2005 01:03 AM|Anonymous|LINK
Mar 08, 2005 06:56 PM|Anonymous|LINK
Nov 07, 2019 06:47 PM|Ben-T100|LINK
Although Excel contains a number of interesting chart types with their subtypes (or variations), at times you need something a little more... a little different. One place to start is the Custom Types tab in the Chart Wizard dialog box.
The Custom Types tab is on step 1 of the Chart Wizard. It contains 20 built-in custom chart types. Some of these are merely standard charts to which some interesting formatting has been added, or they have been modified by the selection of certain chart
options. Others are quite distinctive, including the mixed chart types and the logarithmic chart type. If none of these are appealing, you can create and save your own custom chart types.
TIP: 3D charts and flashy fill options are eye-catching. However, the most important question to ask yourself when creating charts is -- Does the chart clearly communicate the data? Creating an elaborate graph is pointless if your audience
is distracted instead of enlightened by it.
If you find that you use the same chart type over and over, you can either set that chart type as the default chart type (replacing the column chart as the default) or you can establish a user-defined custom chart type.
If you typically use a specific chart type when you graph worksheet data, or if you spend a lot of time changing the settings on one of standard charts, you will save a lot of time if you make that chart type (or those settings) the default. You can use
one of the charts you have already created as the basis for the new default chart type. This is especially useful if you have specific chart options or formatting that you usually want to appear on the chart.
To change the default chart type, follow these steps:
1. Display the chart that you want to use as a sample for the default chart type. If the chart is an embedded chart, click the chart to select it. If the chart is on a chart sheet, make it the active sheet.
2. Right-click in a blank area of the chart, away from the chart objects. From the shortcut menu, choose Chart Type. In the Chart Type dialog box select the Custom Types tab.
3. Click the Set As Default Chart button. A message appears confirming that you want to change the default chart type. Choose Yes. The Add Custom Chart Type dialog box may appear. If it does, enter a name and description for your new
default chart. Choose OK to accept the name and description.
4. Choose OK to complete the default chart type change.
The Custom Types tab lists the built-in custom chart types. If you select the User-Defined button on this tab, the list changes to display the default chart type and any custom chart types you have added. Displaying the User-Defined list is not a requirement
for changing the default chart type, but you can use it to verify the change.
Suppose that you have agonized over a chart (customizing the data series, the axis scale, the data labels), and you know your boss is going to want you to use the same settings for other charts you routinely create. You can try to re-create the chart based
on a hard-copy printout (not smart), or you can save the chart and settings as a user-defined custom chart type (smart) and just tell your boss how time-consuming it is to create those charts (very smart).
To create a custom chart type based on an existing chart, follow these steps:
1 Display the chart that you want to use as a custom chart type. If the chart is embedded in a worksheet, select the chart. If the chart is on a chart sheet, make it the active sheet.
2. Choose Chart, Chart Type from the menu. In the Chart Type dialog box, select the Custom Types tab.
3. Click the User-Defined option button; then click the Add button.
4. The Add Custom Chart Type dialog box appears. Enter a name and description for the new custom chart. Then choose OK.
5. The new chart is added to the User-Defined chart list and the description appears in the lower-right corner when that chart type is selected.
6. Close the dialog box.
After you've created a custom chart type, you can share it with other people so that it can be used as a template. All user-defined custom chart types are stored in the xlusrgal.xls file, which is located in the Windows folder in Office 2000:
If you are using another version of Office, you may have to search to locate the xlusrgal.xls file.
Before you share these custom chart types, you should be aware of the following:
* You are, in fact, replacing the xlusrgal.xls file on someone else's machine with the one from your machine. Any custom chart types they had will be lost. If they have not created custom chart types, then this does not present a problem. However, if they
want to preserve any custom charts they have created, it would be better to create a sample workbook containing the custom charts you want to give them. Using the steps outlined in the previous section, they can add your custom charts to their existing files.
When working with less-experienced Excel users, consider creating a macro that performs these steps and adding a macro button to the sample workbook.
* Use Windows Explorer to copy the xlusrgal.xls file to the appropriate folder (listed previously). Because you are replacing the existing file, a dialog box appears, confirming the replacement.
* Although Excel can be open when you copy the xlusrgal.xls file to your machine, it's better to close it. If Excel is open and you have created a chart during the active session, you won't be able to copy the xlusrgal.xls file. When you create a chart,
the xlusrgal.xls file is automatically opened, and you can't copy over an open file. Even if you close the Excel workbook that contains the chart, the xlusrgal.xls file remains open until you terminate the active Excel session.
NOTE: You can also share the xlusrgal.xls with users who have Excel 97. However, it is located in a different folder, typically:
C:\Program Files\Microsoft Office\Office\