A break in my series

[rkw6086]

I have a question.

I have a chart where I have 2 continuous series and then I have a single plot I need to put on the graph. My data table is structured like so

Row Header (X Axis)	Column Header	Value
1	Series 1	3
1	Series 2	5
2	Series 1	6
2	Series 2	9
3	Series 3	12
4	Series 1	5
4	Series 2	2
5	Series 1	7
5	Series 2	6

This is not the actual data, I can't reveal that. But, my data is structured just like this.

What this results in is Series 1 and 2 having a continuous plot until it's time for series 3. Series 1 and 2 stop trending and then series 3 gets plotted, series 1 and 2 continue after series 3 gets plotted and there is now a noticeable gap in the chart.

What I'm wanting is series 1 and 2 to trend uninterrupted and series 3 plot to plot on the graph with just a single plot point.

I'm currently using the CrosstabDataProvider to create the multiple series and some other people in my team have solved this issue by averaging series 1 and series 2 at point 3. I don't want to have to do since it could invalidate the data.

Does anyone have any suggestions? I'm open to try anything to get this working.

[TomasT]

Hi,

Please try using:

chart1.Data.InterpolateHidden =

true;

Does it help?

 Regards,

 TT

[rkw6086]

That works perfectly, and such a quick fix too. (My favorite kind of fixes)

Thanks for the help TT