Daily updation of chart-keeping x axis fixed

[amit_gupta123]

Hi..I am having simple data to be updated on daily basis. Dates are in column a and the data in column b. I want to keep dates from 1 to 31 fixed on x axis and dynamic dating of data on y axis.
Presently if no datais present for forthcoming dates then chart reflects only dates for which data is dated.

Pls advise

 

[NARAYANK991]

Hi Amit ,

Suppose your dates are in the range A2 through A32 ; your data will be in the range B2 through B32.

Just select your data range as that ; this will ensure that Excel displays the entire month along the X-axis , instead of the dates for which data is available.

Narayan

 

[amit_gupta123]

Thanks sir