Why serial chart on ArcGIS dashboard is different from MS Excel?

Question

I would appreciate your help on this: What might have caused the graph look different for the same data in Operational Dashboard and Excel? The first graph is serial chart on Op Dashboard, and second graph is a line graph on MS excel.  The MS Excel chart seems to be right. But why is the graph different in op dashboard? IS there something I am missing? I have attached the data table that created both graphs. Thank you.

Province comparisons.csv.zip

Indra_SharanKC · Answer

Hi Paul,

I did not do anything to match the values. I found that the staggering option should be turned off for the series. The  graph seems to work alright. It took long time to figure this out though. It would have been better if it was obvious and automatically handled.

Thank you.

Kind regards

Indra

PaulSweeney3 · Answer

* did you try matching your x and y axis ranges across both charts , at the moment your dates span a large range in excel and your values increment in 500 on your operations dash board