Now that we have a way to determine the horizontal axis labels that will be highlighted, we can create our formulas. If so, you should put a formula like this in cell c2 and copy it down to the end of your data set: =IF(RANK(B2,$B:$B)<=5,”y”,””).
For instance, if you want to highlight any row that has more than a certain threshold or if you want to highlight the top 5. Highlight Horizontal Axis Labels Picker ColumnĪlso, you can create a formula here if you like if you want to highlight different types of data. So our final chart will show something different for the horizontal axis for the Florida and California labels. Now you can just create another column and put a text “y” or in the row you want to highlight. If our original data is in columns A and B, then we just need to add a column C where we will indicate if the horizontal axis label should be highlighted. Step-by-Step 1) Add a Horizontal Axis Picker/Highlight Column to Data Setįirst, we need to add a column next to our original data set.
0 kommentar(er)
