I'm doing financial modeling and want to create a chart that shows annual and Last Twelve Month (LTM) data but only if the LTM is different from the most recent year end. For example, if a Company's fiscal year end is 12/31/2021, but their most recent quarter is 3/31/2022, I would want to pull in both the last year end and the LTM as of 3/31/2022. But if it is February and the the LTM and last year end are the same, 12/31/2022, I would essentially be duplicating data in my chart, which I would like to avoid.
I can do If then statements to manipulate the cells to be blank etc. but I haven't found a good way for the chart to skip and scale appropriately. If I have it skip blanks, it wont show the data but I have an obvious blank space at the end of my chart. Any help would be appreciated.
Bookmarks