I know this is an old thread - But I had a similar issue, and then solved it by using a scatter chart with lines