How would one go about using a custom formula to determine the format conditions for databars?
Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you caot specify the criteria that you want these bars to display for.
The scenario is that I have a range of data, and some of these values are irrelevant either due to their categorization, or being labeled as outliers. They are abnormally large and I would like for them to be excluded from the databar visualization as the bars are greatly skewed due to the large values.
برچسب:
نویسنده: استخدام کار