خرید بک لینک

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.

http://i.stack.imgur.com/3PGR1.png

برچسب: نویسنده: استخدام کار تاريخ: پنجشنبه 2 ارديبهشت 1395 ساعت: 5:40

صفحه بندی