Macro for chart's bar accumilation each day

[Nimesh]

I want to make chart for daily effeciencies numbers and it
starts from 1st of the month with one bar on the chart and
keep on accumilating the bar for each day effeciencies.how
should i do this with help of macro.

 

[dvt]

I want to make chart for daily effeciencies numbers and it
starts from 1st of the month with one bar on the chart and
keep on accumilating the bar for each day effeciencies.how
should i do this with help of macro.

I don't think you need a macro. That is commonly called a dynamic chart,
and you can read all about it at these sites (among others):

www.tushar-mehta.com
http://www.geocities.com/jonpeltier/Excel/Charts/DynamicColumnChart1.html

Dave
dvt at psu dot edu