Forum Discussion

ChristophEmrich's avatar
ChristophEmrich
Frequent Visitor
7 years ago
Solved

Chart shows more years than in data

Hi everybody!   I'm having a regular LINE AND STACKED COLUMN CHART, populated with data from the years 2008 to 2019. The years are on the x-axis of the chart. The problem is that one the chart I se...
  • vivran22's avatar
    vivran22
    7 years ago

    ChristophEmrich 

     

    Hi,

     

    Try this:

     

    Go to the visual option> Sort by > Order Year

     

    You need to convert the X axis to Categorical.

     

    Rgds,

    Vivek

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.