Plotting a extra point on a graph
Hi Guys, Ok so basically i have a line graph that has 2 value lines each of those value lines plot a point every 5 minutes, what i want to do is add another event but it should only show at the time that value occured so basically i want almost like a label on the graph( the times this event happened) the value should match up to the other 2 values Regards Curt
May 29th, 2012 10:00am

Hi Curt, From your description, does the adding another event mean adding another series group or adding another instance for the current series group? If it is the former, I am afraid this cannot be achieved in a line chart. For example, the current series group has two values: 2011 and 2012. If we add another series group which has two values (Europe and Pacific), there will be four lines: 2011-Europe, 2011-Pacific, 2012-Europe, and 2012-Pacific. If the newly added series group has only one value, there will be two lines. In other words, there wont be three lines situation generated. If it is the latter, it means that the database changes and the series group has three values now. In this condition, you can achieve your goal by setting the line border width and marker type conditionally. For example, we want to hide the line for the newly added year 2010 and only display the corresponding data points. The steps below are for your reference: Click the series in the chart, open the Series Properties window, click the Border tab.Set the Line width to an expression like below: =Switch(Fields!CalendarYear.Value="2010","0.25pt",Fields!CalendarYear.Value="2011","1pt",Fields!CalendarYear.Value="2012","1pt") Click the series in the chart, expand Marker from the Properties pane.Set the Marker Type based on the following expression: =switch(Fields!CalendarYear.Value="2010","Square",Fields!CalendarYear.Value="2011","None",Fields!CalendarYear.Value="2012","None") The report looks like this: References: Series Properties Dialog Box, Markers If you have any questions, please feel free to let me know. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
June 4th, 2012 3:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics