40NZD Make chart hold it's set format and not go back to automatic setting

  • Hi guys,


    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.


    Many thanks,


    SChalaev


    *Payed 10% via PP

  • Re: 40NZD Make chart hold it's set format and not go back to automatic setting


    I will take a look if you have not heard back from SMC, will PM you my e-mail addy

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: 40NZD Make chart hold it's set format and not go back to automatic setting


    Sorry, I did not read the OP correctly, I do not have Excel 2013, and as you say it works perfectly with 2010.


    This is now open again to other developers.


    If it is due to an issue with a bug in Excel 2013 then all I can suggest is going back to square one and trying to use Pivot Charts instead.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: 40NZD Make chart hold it's set format and not go back to automatic setting


    Thanks GC, hope you can get it sorted.

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

  • Re: 40NZD Make chart hold it's set format and not go back to automatic setting


    I was able to replicate the problem (bug) on Excel 2013. First time that I see this, but I have to say that I don't work with chart + checkboxes very often.
    I found a work around that seems to work ok : instead of hiding the rows (and losing the format), I use a macro to hide the lines, the markers and the datapoints.
    I will send you the file by email so you can test on both Excel 2010 and 2013.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!