Comparing data year to year, month to month, day to day

[#1]

I have a table with with the columns Date and Value. The value is mesured once every day.

I would like to compare the values from year to year, month to month, day to day in the same diagram next to each other (not after each other). I want to see the difference between the values from the same day for each year.

How do I do this?

[#2]

Hi,

You could try adding in a few extra columns so that you have:

YEAR(Date) AS YEAR,

MONTH(Date) AS MONTH,

DAY(Date) AS DAY,

Then chose either day, month or year along the x-axis in your graph.

Hope this works ...

Cheers,

Emma