Forum Discussion
Solved
Format Date with Trend Line
Hello, I want the date format on X-Axis to be (i.e. 28/01 intead of 28 Jan) while displaying a trend line. The Trend Line needs the type on X Axis to be"Continuous". The date format as desired ...
Hi mballerio ,
Trend lines can only be used in the analysis pane when the dates are continuous.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mballerio , Trend line is auto formatted based on data range and level. I doubt you can do much on the format