I have plotted a chart with dates in x-axis. These dates are formatted as `d-mmm-yy´ in the source table. But, x-axis labels in the chart has the following problems. Can the experts in this forum help please?
1. Day & month appear correctly, but year is displayed as yy only. For example, 18-jul-yy.
2. Weekends are not there in the table, but chart has weekend dates also. Not sure where is it picking from. For example, 28-jul-yy
3. Table has the dates in English format, but same dates are appearing in the chart in Spanish. For example, 15-ago-yy
Base table:
Chart:
1. Day & month appear correctly, but year is displayed as yy only. For example, 18-jul-yy.
2. Weekends are not there in the table, but chart has weekend dates also. Not sure where is it picking from. For example, 28-jul-yy
3. Table has the dates in English format, but same dates are appearing in the chart in Spanish. For example, 15-ago-yy
Base table:
| trial.xlsx | |||
|---|---|---|---|
| AG | |||
| 4 | Date | ||
| 5 | 18-Jul-24 | ||
| 6 | 19-Jul-24 | ||
| 7 | 22-Jul-24 | ||
| 8 | 23-Jul-24 | ||
| 9 | 24-Jul-24 | ||
| 10 | 25-Jul-24 | ||
| 11 | 26-Jul-24 | ||
| 12 | 29-Jul-24 | ||
| 13 | 30-Jul-24 | ||
| 14 | 31-Jul-24 | ||
| 15 | 1-Aug-24 | ||
| 16 | 2-Aug-24 | ||
| 17 | 5-Aug-24 | ||
| 18 | 6-Aug-24 | ||
| 19 | 7-Aug-24 | ||
| 20 | 8-Aug-24 | ||
| 21 | 9-Aug-24 | ||
| 22 | 12-Aug-24 | ||
| 23 | 13-Aug-24 | ||
| 24 | 14-Aug-24 | ||
| 25 | 15-Aug-24 | ||
| 26 | 16-Aug-24 | ||
summary | |||
Chart:
But still 2nd issue is there. Can the experts in this forum help please?
