As mentioned here, I am going to report this as a bug unless I hear back from a forum contributor (that it's something I've overlooked) or else find a fix in the newer releases of AOO.
Edit: I reported this as a potential bug to the AOO Bugzilla 21/10/2016/Edit] Two calc spreadsheet files are attached. Both relate to data which appear on the second worksheet of each. The idea is to colour code the curves applying to which currency (GBP or PEN) they relate to. To do that I need to set the colour and line dash appropriately. What happens is that after the first two curve specs (DataRowProperties) it isn't possible to set colour etc any more. You either put up with the Chart N colour or else things start disappearing. The first file contains evidence of four curves. The relevant part of the Basic macro is listed on the Chart worksheet. The second file contains evidence of LOSS of one of the curves. The Basic text has the additional lines highlighted in reverse. The third file is the full basic macro, just in case it's of material interest. Thanks for any insights or requests David |