XY scatter keeps duplicating X-axis values when pulling dates

[Kan]

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: Imgur: The magic of the Internet

Thanks in advance!

[ve3oat]

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”.

[mikekaganski]

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.

[Kan]

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.

[ve3oat]

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