Hi! I hope I explain this well enough ...
I have a chart with a two-layer X-axis. I wish to only display the data labels for the last data points in each grouping. On the image below, I only want to display the data labels for 05-Dec-2017 in the Red, White, Blue, Green, and Pink regions. While I can certainly add the labels manually, others will use the file who may not not be very Excel-savvy so I wish to automate this process.

I found code here on these forums that will update the data label for the last points in a series and it works well as you can see in the screenshot. (FYI, I've removed the fill for the text for the first two data series as I really only need the last two since they sum to 100%).
Does anyone have suggestions as to how to modify the VBA found in the link provided to achieve the desired result?
Thanks in advance for any and all help!
Chris
I have a chart with a two-layer X-axis. I wish to only display the data labels for the last data points in each grouping. On the image below, I only want to display the data labels for 05-Dec-2017 in the Red, White, Blue, Green, and Pink regions. While I can certainly add the labels manually, others will use the file who may not not be very Excel-savvy so I wish to automate this process.

I found code here on these forums that will update the data label for the last points in a series and it works well as you can see in the screenshot. (FYI, I've removed the fill for the text for the first two data series as I really only need the last two since they sum to 100%).
Does anyone have suggestions as to how to modify the VBA found in the link provided to achieve the desired result?
Thanks in advance for any and all help!
Chris