programsam
Board Regular
- Joined
- Feb 10, 2016
- Messages
- 123
Greetings,
I'm having an issue with a chart that displays year-over-year data by month.
The issue is that 2021 displays January - December wonderfully however, 2022 displays January - July data and then immediately drops to 0. I am well aware of the Office 365 / Excel 2016 enhancement that allows you to show empty cells as Gaps and show #N/A as an empty cell and this works on my local file.
That said, I'm using VBA to copy/paste the chart to a new Workbook and where I have most everything working, this option does not carry over to the newly created Workbook. I'm wondering if there is a way to select these options using VBA? Can anyone point me in the right direction?
Not posting code because this is a smaller part of a much larger script and I'm almost positive that (if possible) it's only a few lines that need to be added. Is this possible and if so, any ideas on what said code should look like?
I'm having an issue with a chart that displays year-over-year data by month.
The issue is that 2021 displays January - December wonderfully however, 2022 displays January - July data and then immediately drops to 0. I am well aware of the Office 365 / Excel 2016 enhancement that allows you to show empty cells as Gaps and show #N/A as an empty cell and this works on my local file.
That said, I'm using VBA to copy/paste the chart to a new Workbook and where I have most everything working, this option does not carry over to the newly created Workbook. I'm wondering if there is a way to select these options using VBA? Can anyone point me in the right direction?
Not posting code because this is a smaller part of a much larger script and I'm almost positive that (if possible) it's only a few lines that need to be added. Is this possible and if so, any ideas on what said code should look like?