Hello,
I have A and B collumn
A column contains data dor Dates in the format 8/20/2006 23:00 in cell Property i have Category: Custom Type:m/d/yyyy hh:mm
For this Columns I have chart. In x Axis i display date from A column.
In Format Axes i choose Category: Date and Type: 14-Mar.
After updating datas in A and B collumn from external text file.
I loose chart series and values on x and y axes remain old ones.
I have to mention that worksheet where i have chart i have locked and protected.
I unprotected it but situation remains the same.
Can you please help me with this ?