I am moving along quite nicely in generating my reports and now wish to add an x-y graph.

 

My actual objective is to create a cumulative frequencey (descending) curve based on approximately 4M records.  As I can not see a simple way of doing this I have created an empty table with a column for the percentage ranging from 0 to 100 and another column for the value corresponding to that percentage.  I will have up to 4 values per percentage value.

 

I can generate the table, but the XY chart expert will only let me select 1 field for the x values, I need to select up to 4 fields for the x values and only 1 for the Y values.

 

Is there a trick that I can use here?

 

I can reformat my table and build the data in a different way, but even then I will almost certainly want to use different x values for each series.

 

Am I missing something 'obvious'?

 

Thanks for your help,

 

Alan.