Jump to content
Software FX Community

In Line chart, can I skip a empty points(no value) and still display line and marker?


Recommended Posts

I tried to build a line chart with 2 fields. My dataset is something like this.

datetime field1 field2 2009/01/01 12:00:00 24   34 2009/01/01 12:00:00  23 2009/01/01 12:00:00 25  2009/01/01 12:00:00    21   14 2009/01/01 12:00:00 12   ... ...   ...

field1 has 800rows, field2 has only 20 rows. i want field1 to be shown in line without marker, field2 in line with marker.

for field2, what i've got so far is marker only, there is no line link in between those markers.

can anyone tell me how to get line to display between these markers?

your answer will be deeply appreciated!!!!!!!!!!!!



Link to comment
Share on other sites

You need to rearrange your data in the following way:

datetime1 field1   datetime2   field2

 2009/01/01 12:00:00 24 2009/01/01 12:00:00   34

 2009/01/02 12:00:00  23  2009/01/04 12:00:00   14

 2009/01/03 12:00:00 25

 2009/01/04 12:00:00    21

 2009/01/05 12:00:00 12  

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...