Forum Discussion
Dynamic Chart Depiction On Excel
I've a chart in excel that shows a person's start and end date. Depending upon day difference, it displays the data as follows: It shows person id in the left and the bar depicts the total ...
AT-2017 Is your problem solved now or do you still need something else? If not solved, I'm afraid I've lost you and just don't understand what you are asking for.
Riny_van_Eekelen please see this sample and just check the id with 1002 as well Date in the right. When the date will change, the bar chart will increase one by one. Though no functionality is required to change the date, just on daily-basis (After 24 hours) the bar will be increased.
- I think I might know what you are meaning, I think you want to have the formula to mark progression between dates. Like the progress of a time-limited contract.
Here is the formula: =IF(AND(C2>I2,(I2-B2)+1>=0),(I2-B2)+1,(C2-B2)+1)
Put this should show the progression between the dates assuming the Date is representing today's date. Any dates that start before the "today's" date will show as 0.
