I am attempting to create a scatter chart to display the results of an SQL query. The chart appears like
I want to have the points joined by a line and tool-tips appearing when a single point is selected. My existing custom XML appears at the bottom of this post. I have tried different formats between the </tooltip_settings> tags but nothing appears. Similarly, I have tried different line format settings. Interestingly, if the #DATA# string is replaced with a block like ...
<data>
\<series name="Sales" type="Line">
\<point y="1.172" x="1063512000" />
\<point y="1.916" x="1095048000" />
\<point y="5.57" x="1126584000" />
\<point y="15.0" x="1158120000" />
\<point y="144" x="1189656000" />
\</series>
\</data>
... then a line and tool-tips appear. So it looks like whatever is in the #DATA# block is not sufficient to create a line and tooltips. The data is retrieved by a query which returns 4 columns LINK, LABEL, X_VALUE,Y_VALUE
Is there a way in which something can be configured to get line and tool tips to appear?
Existing custom XML
<?xml version="1.0" encoding="UTF-8"?>
<anychart>
<settings>
\<locale>
\<date\_time\_format>
\<format>%u\</format>
\</date\_time\_format>
\</locale>
</settings>
<charts>
\<chart plot\_type="Scatter">
\<data\_plot\_settings>
\<line\_series>
**\<tooltip\_settings enabled="True">**
**\</tooltip\_settings>**
\</line\_series>
\</data\_plot\_settings>
\<chart\_settings>
\<title>
\<text>Scatter Line\</text>
\</title>
\<axes>
\<y\_axis>
\<title>
\<text>Count\</text>
\</title>
\<scale type="Linear" />
\<labels>
\<format>{%Value}{numDecimals:0}\</format>
\</labels>
\</y\_axis>
\<x\_axis>
\<scale type="DateTime" major\_interval="1" minor\_interval="3" major\_interval\_unit="Year" minor\_interval\_unit="Month" minimum\_offset="0" maximum\_offset="0" />
\<labels>
\<format>{%Value}{dateTimeFormat:%yyyy}\</format>
\</labels>
\<title enabled="true">
\<text>Date\</text>
\</title>
\</x\_axis>
\</axes>
\</chart\_settings>
**#DATA#**
\</chart>
</charts>
</anychart>