I have a Chart with multiple series. Some of the data in the series is over different periods. For instance one set just started in August and the other set started in April and goes through August. In some Chart combinations the category axes (which is Date). Starts in August with the new data set and then connects into the April to July data set. I.E. August 2017, April 2017, May June Jul. In other Charts the same data graphs correctly. April, May, June, July, August
Here are the two charts. The similar data set is “Exceeded recommended Calories.” Notice in the top graph the dates are in order. The chart automatically enters 0 for the missing records. In the bottom graph the months are out of order as it shows the smaller August data set first and then chart the other data sets…
Can you help me determine how I can always keep the dates in order? I am assuming it is the order the series are rendering. If the data set that started in August renders before another I get dates out of order.
Thoughts?