3 Replies Latest reply on Mar 14, 2014 1:56 PM by philmodjunk

# Line Chart X Axis Repeats and distorts line (Should be vertical) fm12

### Title

Line Chart X Axis Repeats and distorts line (Should be vertical) fm12

### Post

Can a line chart show a vertical line?  My first two data points in a line chart have the same x value but instead of showing the points directly above each other (after all they have exactly the same X value!) the second point is offset to the right and thus a diagonal line is drawn between them. The x axis scale repeats that x value!  When I use a scatter chart with the values it plots the points correctly but I need lines as I need to define an envelope.

• ###### 1. Re: Line Chart X Axis Repeats and distorts line (Should be vertical) fm12

A line FileMaker line chart is not a cartesian graph as illustrated by your chart. I don't know of a way for a FileMaker chart to show the data the way that you want.

• ###### 2. Re: Line Chart X Axis Repeats and distorts line (Should be vertical) fm12

Well its half cartesian I suppose... the Y-axis appears to scale based on the data values but the x-axis appears to place the data points equally along the axis regardless of data values. Kinda odd-- the point of line charts is to usually to graphically indicate slopes, trends, changes but if the x axis isn't tied to the data these trends will always be distorted or hidden.  Whats the point of drawing a line between points if the slope of that line is meaningless?   One idea I had was to use a scatter chart and generate additional data points that would (mathematically) exist between the two points I want a line between-- generate enough points and it starts to look like a line.

• ###### 3. Re: Line Chart X Axis Repeats and distorts line (Should be vertical) fm12

Yes but the X axis does not show a scale. This type of line chart is more like  bar chart or histogram but with a line drawn from top to top of each bar and then rwith the bars removed...

This type of line chart was never intended for the purpose to which you want to apply it.