Hi. I created a chart in EM using the data in the following screenshot. I am having an issue with sequencing the month and year so the results are chronological. The results should be displayed as 7/2025, 10/2025, 11/2025, 12,2025 and 1/2026. What actions/steps do I need to add to the Table and/or Chart to ensure the results are in chronological order? Thanks.
Your dates are text dates. You can see it from the text alignment in cells - text values are always aligned left. Therefore, they are sorted alphabetically in charts rather than in chronological order.
Use the "Convert data types" action to convert these dates to number dates. Or create a separate column with equivalent number dates and use it for sorting in the chart settings.
