In a workbook there's a chart which I've finished formatting that is plotted from a mirror data table below it.
In the main data table I've used checkboxes to hide/unhide Chart series. For example, if I click on the checkbox in the main data table then a short macro (that is assigned to that specific checkbox) runs to hide/unhide a row (a series) in the mirror table.
This causes the chart to be a bit more dynamic such that it hides/unhides data in the chart, unfortunately the chart doesn't keep it's sets format for the data that's plotted and reverts back to 'automatic format' in some cases, which is a pain. So I want the chart to be able to keep it's set formatting.
I've tried to open the workbook in Excel 2010 and it seems to be working fine, Excel 2013 is another story.
It could be just a bug of some sort in Excel 2013 so if it can't be resolved, I'd appreciate it if you could advise another possible solution to this problem.
I will email the file if there's interest.
*Payed 10% via PP