Hi, I have a need to produce a high-low chart, this is a simplified version of the Candle chart where a bar is displayed to represent the high and low values for a particular data row. The Candle chart can be used to produce this, but it has a significant limitation for my requirements - it insists on there being a datetime column!
I require the option to switch between using a datetime or a simple label column for the x-axis.
Is there a way to do this with a Candle chart, or is there a better chart type that I can use?
Thanks.
Brian
I solved my problem by using a line chart with two data columns for the max and min values, then handling the FillSceneGraph event and finding all the polyline objects, removing them, and replacing each point within the original polylines (for one data column only) with a new vertical polyline with two points from low to high.
This gives me the bonus of having a tooltip displayed for both the high and low values when hovering over the line ends.
I also have a name column and date column in the source data, so I can now switch between an ordinal and time-based X-axis by toggling the TreatDateTimeAsString flag.
I'm sure there is probably a better way to do this, but at least this seems to do the job. :)