Jump to content
Software FX Community

Discontinuous graphs


DannE

Recommended Posts

Is it possible to create discontinuous line graphs? lets say I have data from 1985 to 1990 and missing data for two years 1987 and 1988, so I want these gap to be displayed as a discontinuity and not a straight line joining data point 1986 to 1989. Is is possible?

Link to comment
Share on other sites

Yes, it is possible to create discontinuous graphs, also is possible to draw a lito to Y=0 for each missing point, moreover you may also just not include the missing values to create a continuous graph.

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

There are two approached to accomplish this:

 

a)  Use chart1.Data.InitializeHidden = true; then each missing point between 1987 and 1988 will become zero and you will see a line going down from 1987 to Y=0, then a line going up from Y=0 to 1998.

 

:)Hide the points in your curve chart by doing: chart1.data[0, 0] = Chart.Hidden; This will create a discontinuous line...but perhaps you may want to create a nice continuous line from 1987 to 1988 omitting the missing points then you do chart1.Data.InterpolateHidden = true;

Link to comment
Share on other sites

I apologize for overlooking at the thread product section. As indicated by Max you may want to use the "Value" property to pass data to the chart. Here is some code Max kindly posted for you:

------------------------------------------------------------------------------------------------------------------

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

 

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...