private BubbleChartAxisToColumnMapping GetBubbleChartColumnMappings()
{
//TODO: I know this is a disgusting algorithm. It was done in haste to accomodate the bubble chart needing 4 axis when all 4 may not be present in the chart data (i.e. several axis use the same column)
var mappings = new BubbleChartAxisToColumnMapping();
var numOfColumns = 1;
mappings.XaxisColumnIndex = 0;
if (PropChartYaxisField.ToLower().Trim() == PropChartXaxisField.ToLower().Trim())
{
mappings.YaxisColumnIndex = mappings.XaxisColumnIndex;
}
else
{
mappings.YaxisColumnIndex = 1;
numOfColumns++;
}
if (PropChartZaxisField.ToLower().Trim() == PropChartXaxisField.ToLower().Trim())
{
mappings.ZaxisColumnIndex = mappings.XaxisColumnIndex;
}
else if (PropChartZaxisField.ToLower().Trim() == PropChartYaxisField.ToLower().Trim())
{
mappings.ZaxisColumnIndex = mappings.YaxisColumnIndex;
}
else
{
mappings.ZaxisColumnIndex = numOfColumns;
numOfColumns++;
}
if (PropBubbleChartColorField.ToLower().Trim() == PropChartXaxisField.ToLower().Trim())
{
mappings.ZaxisColorColumnIndex = mappings.XaxisColumnIndex;
}
else if (PropBubbleChartColorField.ToLower().Trim() == PropChartYaxisField.ToLower().Trim())
{
mappings.ZaxisColorColumnIndex = mappings.YaxisColumnIndex;
}
else if (PropBubbleChartColorField.ToLower().Trim() == PropChartZaxisField.ToLower().Trim())
{
mappings.ZaxisColorColumnIndex = mappings.ZaxisColumnIndex;
}
else
{
mappings.ZaxisColorColumnIndex = numOfColumns;
}
return(mappings);
}
public string[] GetYFields()
{
return(PropChartYaxisField != "" ? PropChartYaxisField.Split(Separator) : new string[0]);
}