How to show conditional formatting icon on chart? for eg. if i have multiple entries for sales column for a series of date as 200,500,600,300,400 etc. Now I apply conditional formatting so 0-250:Red, 250-500:Yellow, >500:Green now I came up with the indicator column. No I want these indicators to reflect on chart if I select a particular date. Could you please help me?
Hi Shashank,
Chart's cannot display conditional formatting or detect conditional formats in cells in order to display them. You would have to use a formula that returns a value that can be displayed in the chart, either in the data labels or series names.
Mynda
In that case, if I have store name column and corresponding sales values ranging from 100 to 1000 and I want to highlight only those sales whose sales is less than 300 on a dashboard. How should i approach?
Using a technique like this highlight min and max values in a chart. It obviously highlights the min and max, but you can change the formula to include sales <300.
Mynda
In the past I've used threshold lines in my charts. One data series as a bar chart, and an additional series as a line chart. Usually that does enough to show where sales hasn't met the criteria.
Another possibility is to have additional series with if formulas that meet your needs. Then add those series to your chart with 100% overlap and changing the colors of those series.
