Charting from Excel Data Links

Ce sujet contient 2 réponses, 2 participants et a été mis à jour pour la dernière fois par tim@gci.org.uk, le il y a 21 années et 8 mois.

Voir les messages de 3 - 1 à 3 (sur un total de 3)

Auteur

Messages
25.09.2003 à 02:32 #34287

tim@gci.org.uk
Participant

Hello I am a new FlexPro user. I have successfully created a set of charts by importing an excel workbook and saving off the collumns I need as “data sets”.
I want to make my charts dynamic, so I am trying to set them up with excel data links instead.

When I try to make the chart, I am getting the following error message.

“”The Y-component of the 9. curve has the wrong data type. Only numeric and Boolian values are permitted.””

my data links consist of one collumn of dates(for the x-axis) and several collumns of data to be plotted for diferent countries. The data is all numbers except for the identifying header at the top of each collumn.

Have you any advice for me,

Many Thanks,

Tim

25.09.2003 à 02:54 #34285

tim@gci.org.uk
Participant

Hello I am a new FlexPro user. I have successfully created a set of charts by importing an excel workbook and saving off the collumns I need as “data sets”.
I want to make my charts dynamic, so I am trying to set them up with excel data links instead.

When I try to make the chart, I am getting the following error message.

“”The Y-component of the 9. curve has the wrong data type. Only numeric and Boolian values are permitted.””

my data links consist of one collumn of dates(for the x-axis) and several collumns of data to be plotted for diferent countries. The data is all numbers except for the identifying header at the top of each collumn.

Have you any advice for me,

Many Thanks,

Tim

25.09.2003 à 02:54 #34286

Bernhard Kantz
Participant

To create the Excel data links in FlexPro proceed as follows:
[ol]
[li]select all columns including the headers and the time column in Excel-View in FlexPro Explorer.[/li]
[li]drag the selected rectangle with the mouse to the list view of FlexPro explorer.[/li]
[li]In the dialog box select [b]One data series per column[/b], check [b]The following column contains the X values[/b] and enter [b]1[/b] as the column number.[/li]
[/ol]
Now check the [b]contents[/b] column in the list view for each data series. They should all be numeric. If one of them is string, please check the data in the excel sheet.

If you cannot find the reason for the problem, please send the FlexPro database to support@weisang.com.
Auteur

Messages

Voir les messages de 3 - 1 à 3 (sur un total de 3)

Vous devez être connecté pour répondre à ce sujet.