megamind007
New Member
- Joined
- Sep 22, 2013
- Messages
- 43
Hi folks,
I have to sent a dashboard to my boss every EOB day in MS outlook.I have bar charts in MS excel which take data from the table in the same worksheet.What I do is update the data in the table which automatically updates the charts(sounds obvious) and then I paste special updated tables and charts as picture in MS outlook.
I want to avoid this futile exercise by using some functionality which is unknow to me,if there is any,by which when I update the data in excel sheet it automatically updates the tables and charts in MS outlook so that I dont have to paste it everyday and do the formatting stuff.
I hope there is some smart solution to this monotonous exercise,
Thanks already,
I have to sent a dashboard to my boss every EOB day in MS outlook.I have bar charts in MS excel which take data from the table in the same worksheet.What I do is update the data in the table which automatically updates the charts(sounds obvious) and then I paste special updated tables and charts as picture in MS outlook.
I want to avoid this futile exercise by using some functionality which is unknow to me,if there is any,by which when I update the data in excel sheet it automatically updates the tables and charts in MS outlook so that I dont have to paste it everyday and do the formatting stuff.
I hope there is some smart solution to this monotonous exercise,
Thanks already,