Separate Two Sets Of Data On One Chart With A Space

[WelshNoob]

Hi there

 

I am trying to include more than one full set of data on a single chart and am struggling with XML code to add in a blank column to separate those data sets.

 

In the code below, what needs to be in the rows with 'xxxxx' to create a space on the chart? The current code doesn't leave any space so the horizontal lines (2008 & 2009) in the dataset for Salesman X are joined with a sloping line - I want there to be no join, just two separate horizontal lines at different levels.

 

<graph palette="2" caption="Average Monthly Sales" subcaption="2008 & 2009" showValues="0" divLineDecimalPrecision="2" limitsDecimalPrecision="1" formatNumberScale="0">

<categories>

<category label="S" />

<category label="SE" />

<category label="SW" />

<category label="N" />

<category label="NE" />

<category label="NW" />

/> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<category label="S" />

<category label="SE" />

<category label="SW" />

<category label="N" />

<category label="NE" />

<category label="NW" />

</categories>

- <dataset seriesName="Team Averages" renderAs="Column">

<set value="6.67" />

<set value="6.92" />

<set value="7.13" />

<set value="7.52" />

<set value="7.83" />

<set value="7.92" />

<set value="" /> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<set value="6.25" />

<set value="6.83" />

<set value="6.05" />

<set value="6.48" />

<set value="6.77" />

<set value="8.14" />

</dataset>

- <dataset seriesName="Salesman X" renderAs="Line">

<set value="7.05" />

<set value="7.05" />

<set value="7.05" />

<set value="7.05" />

<set value="7.05" />

<set value="7.05" />

<set value="" /> xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

<set value="6.97" />

<set value="6.97" />

<set value="6.97" />

<set value="6.97" />

<set value="6.97" />

<set value="6.97" />

</dataset>

</graph>