If its on public, then can you please share the link since its available to everyone to see at least. You can restrict the workbook download but allow us to download the data in excel format. I will try same and then we can probably compare.
I can't due to the nature of the data sorry, I realise this isn't much help but my hands are tied there. I could make a copy of the data and remove all references to anything so it's just a bunch of numbers but as I said in my original post the charts in question display perfectly in the desktop and our work server version, it is just the public version where an error occurs but disappears if you download the workbook and view on the desktop. A colleague has tried downloading to her desktop version and that works fine as well.
It's like the public version is struggling to process certain outputs correctly or something, as you can see in the images the data pattern and location of the reference line is correct, just the incorrect sizing for the bars, like a chunk has been removed for some reason. I am not making any changes between uploads either. I'm no expert but if it is displaying fine in 2 out of 3 versions and the version with an error when downloaded to a desktop version is fine I don't see how can't be an issue with the underlying data. If it is a data issue then it is occurring somewhere on the upload on a handful of charts in a very specific way, then somehow being fixed when downloaded as a workbook and viewed on a desktop, if that is the problem I don't see how that could be recreated. All the data for all charts is in one excel sheet and all the data is the same format.