excel chart not showing the latest date

[daveyc18]

when I change the axis to text axis, it doesnt capture the latest date (march 27 data), but rather shows march 25 ..any way to fix this?

(if I change axis to date, it does show march 27, but then the graph is not accurate because it includes weekends.)

 

[Kaper]

of course we don't see your data nor your graph type.
is the axis labelled day by day? or every 5th ot nth day?
are the data points/lines/bars presented in both cases properly, or are they shifted in one case?

 

[daveyc18]

of course we don't see your data nor your graph type.
is the axis labelled day by day? or every 5th ot nth day?
are the data points/lines/bars presented in both cases properly, or are they shifted in one case?

5th day

if using text axis, it's represented accurately