In the attached workbook I have a dual axis to show the dates at the top. The data only has date up to 10/29 but the heading shows date up to 10/30. It always shows date up to the current date. Can anyone tell me how I can fix it so it only shows up to current date - 1 day?
Unfortunately I don't think there is a way to remove that date since you are using a continuous axis. The only way I can think of would be to make it discreet, but then you lose the intermediate days where there is no data.