Date of x-axis to represent

[#1]

Based on the current month to six months to draw the chart.
And the same standards should be expressed with the previous year's chart.

Date of issue distance between the x-axis data should be expressed as
(Up to 1-180 (6 months))

You expressed the x-axis: 1 May 7 May ... July 20 ... September 10
Only want to express the x-axis: 17 13 19 25 .... 180

Please help ...

[amars]

Hi,

I couldn't understand exactly what u want. But as far as I understand you can write an expression like =If( DateValue >= AddMonths(Now(0),6) and DateValue<Now(0) , DateValue) similrly for 1year will do.

With Regards

Amar

[#3]

Wondering how to express the x-axis

Current: May 1 / May 7 / May 13 ..... November 30
The way you want: 1 day / 7 days / 13 days / ..... / 180 days

(the interval between the date must be calculated)