Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I m having a continuous X axis based on field storing Dates. This x-axis field has only Weekending date stored in it and when enabling the X-axis as continuous X-axis is getting displayed the dates based on the width of the chart and not Weekending date as stored in field.
Help me how can I format Continuous X-axis field.
Thanks,
Rakul.
May be assign your formatting here
Thanks for writing back,
My issue is not the Number formatting, the date field displays date in date format but it displays dates on auto interval but not Weekending dates.
I want the x-axis to be continuous and at same time controlling what dates needs to displayed. Tried with Static Min, Max and Step too but it has no effect on continuous x-axis.
Thanks,
Rakul.
Can you share a sample to try and test it out?
Hi Sunny,
Please find below sample data. I want to draw a vertical reference line on few WeekEnd. To achieve this I have to enable Continuous X-Axis but after enabling it the WeekEnd are not displaying the WeekEnd but auto Date based on the chart area.
WeekEnd | Data |
7/12/2015 | 4247 |
7/19/2015 | 7392 |
7/26/2015 | 1807 |
8/2/2015 | 2387 |
8/9/2015 | 5362 |
8/16/2015 | 1424 |
8/23/2015 | 3317 |
8/30/2015 | 3122 |
9/6/2015 | 4738 |
9/13/2015 | 1378 |
9/20/2015 | 5037 |
9/27/2015 | 1470 |
10/4/2015 | 1568 |
10/11/2015 | 3962 |
10/18/2015 | 2678 |
10/25/2015 | 4414 |
11/1/2015 | 3085 |
11/8/2015 | 3259 |
11/15/2015 | 3190 |
11/22/2015 | 4114 |
11/29/2015 | 1121 |
12/6/2015 | 4678 |
12/13/2015 | 3330 |
12/20/2015 | 4963 |
12/27/2015 | 4632 |
1/3/2016 | 1302 |
1/10/2016 | 5215 |
1/17/2016 | 1849 |
1/24/2016 | 3774 |
1/31/2016 | 2298 |
2/7/2016 | 3147 |
2/14/2016 | 3278 |
2/21/2016 | 4991 |
2/28/2016 | 1837 |
3/6/2016 | 5845 |
3/13/2016 | 1589 |
3/20/2016 | 4980 |
3/27/2016 | 3779 |
4/3/2016 | 3327 |
4/10/2016 | 4598 |
4/17/2016 | 3540 |
4/24/2016 | 4416 |
5/1/2016 | 3023 |
5/8/2016 | 1819 |
5/15/2016 | 3622 |
5/22/2016 | 4433 |
5/29/2016 | 4528 |
6/5/2016 | 3152 |
6/12/2016 | 4143 |
6/19/2016 | 4304 |
6/26/2016 | 5513 |
7/3/2016 | 1304 |
7/10/2016 | 1020 |
7/17/2016 | 6181 |
May be here is this one possibility
This will work only if there is space for the labels to show up... so if you make the chart smaller is probably start to not work.... But I guess that's one limitation of continuous axis