Apr 24, 2012, 11:33 AM
Line chart grouping of dates on x-asis
Hello everyone,
When creating a line chart i am putting prices on the y-axis and dates on the x-asis.
One date can occur more than once.
What happens is as following: for example i have 6? on 12/10, and 4? on 12/10.
Both prices come to be on one 12/10 point but the dates repeat themself and dont get grouped. (screenshot attached)
This is the code i use for the chart:
Any ideas?
Thank you!
Naomi
When creating a line chart i am putting prices on the y-axis and dates on the x-asis.
One date can occur more than once.
What happens is as following: for example i have 6? on 12/10, and 4? on 12/10.
Both prices come to be on one 12/10 point but the dates repeat themself and dont get grouped. (screenshot attached)
This is the code i use for the chart:
<ext:Chart ID="chrtShipments" runat="server" Animate="true" StoreID="strChartData" Shadow="true" Legend="true" AutoHeight="True" Width="950" Flex="1">
<LegendConfig Position="Right" />
<Axes>
<ext:NumericAxis Grid="true" Fields="PriceOfShipment" Title="Vrachtprijs ? per ton" />
<ext:CategoryAxis Fields="DateOfShipment" Position="Bottom" Title="Datum" />
</Axes>
<Series>
<ext:LineSeries Axis="Left" XField="DateOfShipment" YField="PriceOfShipment">
<HighlightConfig Size="7" Radius="7" />
<MarkerConfig Type="Cross" Size="4" Radius="4" StrokeWidth="0" />
<Tips ID="Tips1" runat="server" TrackMouse="true" Width="110" Height="40">
<Renderer Handler="this.setTitle(storeItem.get('PriceOfShipment') + ' ? per ton op ' + storeItem.get('DateOfShipment'));"></Renderer>
</Tips>
</ext:LineSeries>
</Series>
</ext:Chart>
I have tried to use time axis instead of the category, or tried to use the time of the date but its all the same.Any ideas?
Thank you!
Naomi