hi my code is
Dim xmlpath = "C:\Users\Kiran\AppData\Roaming\SRSConnectGraphs\Settings\Customers\Manohar.xml"
Dim ds1 As New DataSet()
Dim xmlfile1 As XmlReader
xmlfile1 = XmlReader.Create(xmlpath, New XmlReaderSettings())
ds1.ReadXml(xmlfile1)
'While xmlfile1.Read()
Dim xmldoc As New XmlDocument()
xmldoc.Load(xmlpath)
Dim nodeList As XmlNodeList = xmldoc.SelectNodes("//NewDataSet/Set")
For Each node As XmlNode In nodeList
Dim custname As String = node("CustomerName").InnerText
lblCustName.Text = custname
Next
If (lblCname.Text = lblCustName.Text) Then
With locWorkbook.Worksheets(1).Range("A5:B5")
With .Font
.Name = "Arial"
.FontStyle = "Bold"
.Size = 12
End With
With .Interior
.ColorIndex = 15
End With
End With
For i = 4 To ds1.Tables(0).Columns.Count - 1
locWorksheet.Cells(i + 1, 2) = ds1.Tables(0).Rows(0).Item(i)
locWorksheet.Cells(i, 1).BorderAround(Excel.XlLineStyle.xlContinuous)
locWorksheet.Cells(i, 2).BorderAround(Excel.XlLineStyle.xlContinuous)
Next
End If
xlCharts = locWorksheet.ChartObjects
myChart = xlCharts.Add(100, 80, 300, 250)
chartPage = myChart.Chart
chartRange = locWorksheet.Range("B5", "B" & ds.Tables(0).Columns.Count - 1)
chartPage.SetSourceData(Source:=chartRange)
chartPage.ChartType = Excel.XlChartType.xlLine
chartPage.HasTitle = True
chartPage.ChartTitle.Text = "Wipro Cylinder Test Rig.."
and my xml file is
="1.0"="yes"
<NewDataSet>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag1</TagName>
<ReferenceValue>2.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag2</TagName>
<ReferenceValue>2.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag3</TagName>
<ReferenceValue>2.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag4</TagName>
<ReferenceValue>2.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag5</TagName>
<ReferenceValue>4.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag6</TagName>
<ReferenceValue>4.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag7</TagName>
<ReferenceValue>0.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag8</TagName>
<ReferenceValue>6.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag9</TagName>
<ReferenceValue>6.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag10</TagName>
<ReferenceValue>6.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag11</TagName>
<ReferenceValue>6.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag12</TagName>
<ReferenceValue>6.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag13</TagName>
<ReferenceValue>8.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag14</TagName>
<ReferenceValue>8.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag15</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag16</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag17</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag18</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag19</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>SampleTag20</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>CUSTOMER</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>CYLINDERSLNO</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
<Set>
<CustomerName>Manohar</CustomerName>
<Tolerence>10.00</Tolerence>
<TagName>LogData</TagName>
<ReferenceValue>9.00</ReferenceValue>
<UpdatedOn>6/26/2013 12:56:10 PM</UpdatedOn>
</Set>
</NewDataSet>
i want to create a graph
in y axis as referencevalue as positive and -ve and i am generationg x axis as pressure
can anyone help