Ask Your Question

XY scatter keeps duplicating X-axis values when pulling dates

asked 2018-07-22 23:48:33 +0200

Kan gravatar image

updated 2018-07-22 23:57:36 +0200

I'm trying to create a simple XY scatter that tracks monthly net worth over the course of one year (Y-axis is value, x-axis is each month).

The data source is simple: two rows. Row one is the list of months and row two contains the numeric values ($10, $20, etc.). However, regardless of what I do with the X-axis format, it refuses to stop duplicating month labels.

How can I get the X axis to only have 12 values, labeled by month? Forcing X-axis to start in January and end in December, with a major interval of 1 still gives me duplicated months.

Interestingly, the chart works if it displays the months as simple numbers (1 through 12), but not when it is pulling info from a DATE formatted cell.

Please see the following album for the sample chart:

Thanks in advance!

edit retag flag offensive close merge delete


I can't solve the problem (my test produces a graph even worse than yours!), but I can suggest un-checking Automatic for the minor interval count and changing the value to "1".

ve3oat gravatar imageve3oat ( 2018-07-23 03:26:19 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-07-23 09:01:46 +0200

It is normal. XY treats its X axis as numerical value, and date is a numerical value with day as the base unit. What you need is Line (Points and Lines) type.

image description

edit flag offensive delete link more


Can't believe I never thought about changing the chart type! This worked perfectly, thank you. Just changed the type and put the first row in the "categories" field.

Kan gravatar imageKan ( 2018-07-24 02:32:52 +0200 )edit

I never thought of it either and I'm not sure I would have. Learn something every day!! Thanks to @mike-kaganski

ve3oat gravatar imageve3oat ( 2018-07-24 04:01:42 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-07-22 23:48:33 +0200

Seen: 178 times

Last updated: Jul 23 '18