A colleague has created an excel chart which has columns for a range of years from 2012 to 2022. All these years are selected in the 'Select Data Source' tool. In other words, the 'Range Details' field contains all columns and all rows with data in them.
However, when I view the chart on my mac (excel for Office 365) I can only see values for the years 2012 to 2017.
How can I use my mac to amend the chart to include say values for the year 2018? (Or do I need to go to a Windows machine to do this).