I have a column chart that I need to display data points on. I'm not sure if this is the correct terminology so I'm including the chart I have in Excel. I need to be able to place the little triangles on the columns to represent an event that happened in that month. Make sense.
This isn't really supported out of the box. The only series that can display the triangle icons is the scatter series, but that one needs a pair of numeric coordinates and plots on numeric x and numeric y axes. The triangles would have to be added on manually by using FillSceneGraph event. You'd have to calculate the spot where you want the triangle to appear, create a Symbol primitive, set its icon and color and add it to the scene.
Symbol s = new Symbol();s.point = new Point(x, y);s.icon = SymbolIcon.Triangle;s.PE.Fill = Color.Blue;e.SceneGraph.Add(s);
Finding the x and y can be tricky. You have to loop through the SceneGraph to find the 2 Box primitives with matching Row and put the symbol between them.
Thanks Max. The triangles are actually represented by a numerical value just like the columns but my user likes the triangle for some reason. If I just use another column to display this data, most of the values are "0". How can I display the column and number if the value is greater than "0" but display nothing if the value is "0"?