Hi,
I created a pivot table and a pivot chart to match. It orders data by year, and the order of the years was fine and chronological.
The issue: When I change the layout of the pivot chart from "Line" to "Combo" and make the first two series (2023 & 2024) a "line" and the last series (2025) a "bar", the sorting of the years becomes out of order in the chart (but not in the table). 2025 becomes top series, and 2023 and 2024 is below. I can't get the chart series order in sync by refreshing or manipulating the table; I've tried.
It gets weirder: Changing to other chart types for the individual series removes the problem (but it is chart types that I don't want). For instance 2023-2025 ~ "Line/Line/Bar" creates the issue as mentioned above, but with "Bar/Bar/Line" the series are chronological like the table. I attached a picture of both examples.
Any suggestions? I really hope someone has an idea
I created a pivot table and a pivot chart to match. It orders data by year, and the order of the years was fine and chronological.
The issue: When I change the layout of the pivot chart from "Line" to "Combo" and make the first two series (2023 & 2024) a "line" and the last series (2025) a "bar", the sorting of the years becomes out of order in the chart (but not in the table). 2025 becomes top series, and 2023 and 2024 is below. I can't get the chart series order in sync by refreshing or manipulating the table; I've tried.
It gets weirder: Changing to other chart types for the individual series removes the problem (but it is chart types that I don't want). For instance 2023-2025 ~ "Line/Line/Bar" creates the issue as mentioned above, but with "Bar/Bar/Line" the series are chronological like the table. I attached a picture of both examples.
Any suggestions? I really hope someone has an idea
