•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
=YEARselect formula in Excel
Our take
If you've inherited a Gantt chart in Excel displaying years 2025 and 2026, and you wish to show only 2026 and 2027, understanding the =YEARselect formula is crucial. This formula likely references a data source or range that defines the visible years. Instead of deleting it, investigate where the formula retrieves its values. You can modify the underlying data or adjust the formula parameters to ensure only the desired years appear. This approach empowers you to tailor the chart to your needs effectively.
I have recently taken over a spreadsheet from a colleague who has left. They had a Gantt chart created on a tab which shows the year and months below.
The years it shows are 2025 and 2026. I don’t want 2025 to be visible anymore. Instead I want to see 2026 and 2027.
I’ve found that there’s a formula hidden on the page which says =YEARselect, there is nothing more than this. If I delete it, both 2025 and 2026 disappear. I have no idea where it’s pulling the years from. What can I do?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience