Hello!
There is a graph that I need to update on a monthly basis which contains:
- bars showing the value (left vertical axis) for each month for last 4 years
- line with no data labels (right vertical axis)
- line with the percentages (right vertical axis)
- months for the last 4 years (horizontal axis)
It has data labels on the bars and marker dots on the line with the percentages. If we are in October, I will have data labels and marker dots for October for 2011, 2012, 2013 and 2014. In November I have to delete all the labels and dots and create new ones for Novembers.
Is there a macro that I can use instead of doing this manually every month? I am using Excel 2010.
I'll try to attach sample graph below, hope it works.
There is a graph that I need to update on a monthly basis which contains:
- bars showing the value (left vertical axis) for each month for last 4 years
- line with no data labels (right vertical axis)
- line with the percentages (right vertical axis)
- months for the last 4 years (horizontal axis)
It has data labels on the bars and marker dots on the line with the percentages. If we are in October, I will have data labels and marker dots for October for 2011, 2012, 2013 and 2014. In November I have to delete all the labels and dots and create new ones for Novembers.
Is there a macro that I can use instead of doing this manually every month? I am using Excel 2010.
I'll try to attach sample graph below, hope it works.