How to Highlight the Incell Graph

 

In this article we will learn how to highlight the Incell graph on the basis of high score in Microsoft Excel. To solve this problem we will use Conditional formatting along with AVERAGE function.

Conditional formatting will help to highlight the Incell chart and Average function will help to choose the graph on the basis of criteria.

Let’s take an example and understand:-

We have sales data, on the basis of sales number we have created Incell chart in column C. Now we want to highlight those cell graph which is more than average number of sales to every agent.

image 1

 

In this query user wants to highlight those incell graphs that is more than average of sales.

Follow below given steps:-

  • Select the range C7:C16

image 2

 

  • Go to Conditional Formatting > Select “New Rules”

image 3

 

  • Use a formula to determine which cells to format
  • Enter the formula :- =($B7>AVERAGE($B$7:$B$16))
  • To highlight with the color, click on Format > Font > Selec the color > click on Ok

image 4

 

  • All the graphs will get highlighted with selected color

image 5

 

In this way we can highlight Incell graph on the basis of criteria’s in Microsoft Excel.

 

image 48

 

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.
We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com



Example:


Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>