Rajesh S
Member
Dear Team,
I am trying to prepare a dynamic chart based on the attached excel file.
Line Chart is required based on the value available in Column E, G & I (i.e., % of Late Comers, Stretch%, Working Hours non adherance%).
Data in Column E, G & I will be added on daily basis based on another input. While preparing a chart, output is having all the dates with blank data reading at bottom of the chart on those days.
I would like to have a dynamic chart where the chart should be prepared only till the date of data available & once the data is punched for the next day chart should get auto refreshed till such day.
Can anyone help me on this?
Regards
S Rajesh
I am trying to prepare a dynamic chart based on the attached excel file.
Line Chart is required based on the value available in Column E, G & I (i.e., % of Late Comers, Stretch%, Working Hours non adherance%).
Data in Column E, G & I will be added on daily basis based on another input. While preparing a chart, output is having all the dates with blank data reading at bottom of the chart on those days.
I would like to have a dynamic chart where the chart should be prepared only till the date of data available & once the data is punched for the next day chart should get auto refreshed till such day.
Can anyone help me on this?
Regards
S Rajesh