5 Replies Latest reply on Mar 20, 2013 9:32 PM by Catherine Denmeade

# Connecting the dots: X, Y Coordinates

I have a data file that contains a series of X and Y coordinates that gives me a 'profile' - when I graph this, I want to see a line or perhaps an area chart (not a series of dots), but I can't work out how to make this happen.

The attached file has two sets of coordinates for 'axle 2' - one for the left side and one for the right side. You can see on sheet 1, I've plotted things so I get the right shape, but I only get dots rather than a line. I've tried a few things, but I'm very new to Tableau and I'm probably just missing something really obvious!

Note - the dimension called 'point' is basically the order in which the points should plot, if I remove it from the graph it gives me some crazy things.

What am I missing??

Thanks!

• ###### 1. Re: Connecting the dots: X, Y Coordinates

You have individual dots because Point dimension is discrete in your view.

If you change it to continuous, like so:

then you'll get a continuous line, which you can turn into an area, like this:

• ###### 2. Re: Connecting the dots: X, Y Coordinates

I did try that, and was very excited for a moment... but then I realised that, actually, what it plotted like that was meaningless.  What it does when I make the 'point' continuous, is plot the Y coordinate against the point, and then also the Y coordinate against the X: notice in your image that the area charts are actually for Y vs Point rather than for Y vs X.  The X got shoved off to the side...

I need for X to plot aginst Y in the order of 'point' (which is why I had to make it discrete).

Is there anything I can do while point is discrete??

Thanks!!

• ###### 3. Re: Connecting the dots: X, Y Coordinates

You can try moving Point to the Path shelf, then you'll get something like this:

But I can't tell if it would make any more sense, as I not familiar with the data.

1 of 1 people found this helpful
• ###### 4. Re: Connecting the dots: X, Y Coordinates

Catherine,

When using a Line mark type, the "Path" shelf defines the order in which the line is drawn.  In your case, put the Point on Path and it will draw the line in order.  Any discrete field on the Color, Label, shelf or Level of Detail will slice the mark into multiple lines.  So, for example, in your data if you put "Side" on color, you'll get two lines for L and R.

I've attached a workbook to demonstrate.

Regards,

Joshua

Here it is filtered to show only the R side.

1 of 1 people found this helpful
• ###### 5. Re: Connecting the dots: X, Y Coordinates

Hmm... using 'path' (a new one to me!) plots the data in a more correct way than I was trying to - but the line doesn't look right.  I wonder if that is more to do with **** data than what I'm doing.

This looks like the right way to go - just have to go chase down the provider of the sample data and see how much I can trust it!