XSL for multi-series Line Chart

[wnuzum]

Hi,

 

I have a multi-series line chart w/ Dates as the X-axis and dollar amounts as the Y-axis (tracking 3 different lines) and would like to format the XML using XSL for easier error-checking/reading/accessibility. The problem is, I would like to format it in a table w/ each row containing one date, and one dollar amount from each of the three dollar groups. (e.g. top table headers of 'Date', 'amt A', 'amt B', and 'amt C', w/ each row flowing accordingly)

 

Any suggestions on how to do this would be appreciated. Thanks!

-Will

 

Here is a sample of the XML:

 

<chart caption='Values by Date' yAxisName="Dollar">
  <categories>
 <category label="08/21/2009"/>
 <category label="08/22/2009"/>
 <category label="08/23/2009"/>
 <category label="08/24/2009"/>
 
  </categories>
  
  <dataset seriesName="Debt Subject to Limit" color="66cc00" lineThickness='4'> 
 <set value="11223"/>
 <set value="11226"/>
 <set value="11234"/>
 <set value="11225"/>
 </dataset>
 
  <dataset seriesName="Public Debt Outstanding" color="3366cc" lineThickness='4'>  
 <set value="11284"/>
 <set value="11286"/>
 <set value="11293"/>
 <set value="11285"/>
 </dataset>
  
  <dataset seriesName="Limit*" color="ff6600" lineThickness='4'>
 <set value="12104"/>
 <set value="12104"/>
 <set value="12104"/>
 <set value="12104"/>
  </dataset>
</chart>

Edited September 22, 2009 by Guest