klutz
03-14-2011, 07:51 AM
Hello
I have a chart in excel that is used as a timeline. When I start a new task I have to format the X axis on the Chart manually to the dates I choose.
Can someone help me with a macro that can copy the START and END date from a field in the file and update the chart?
I tried recording a macro with the same steps, it works initially except that when I changed the dates and ran the macro to update the new dates the X axis did not changed, it kepted the old dates.:dunno
Thanks-
I have a chart in excel that is used as a timeline. When I start a new task I have to format the X axis on the Chart manually to the dates I choose.
Can someone help me with a macro that can copy the START and END date from a field in the file and update the chart?
I tried recording a macro with the same steps, it works initially except that when I changed the dates and ran the macro to update the new dates the X axis did not changed, it kepted the old dates.:dunno
Thanks-