Forum Discussion
Diagram hidden and empty cells settings not all options available
Hi, I experienced many times in Excel, when I create diagrams and selected my X and Y data, after some time I want to change the hidden and empty cells settings, and choose one of the options, ga...
Sheen1255 What version of Excel do you have? You should see another option below the drop-down. I don't know why it gives you fewer options in the drop-down in those 2 cases, but maybe this issue has been fixed in a recent version. Go to Help > Check for Updates and make sure you install recent updates.
A more recent version should have the option for "Show #N/A....".