Scan Boarder Conditional with airSlate SignNow

Graph header settlement

In today's video, let's take a look at an Excel chart trick. Let's create a bar chart that automatically shows negative values in a different color to positive values. What I'm also going to do is to show you how you can conditionally format the bar chart to highlight the bar with the highest value. Now the trick that you see here is something that you can apply to any chart that you want to conditionally format. Let's check it out. (upbeat music) I have a list of products and the sales value for actual and budget. What I'd like to do is create a bar chart for the actual sales, but I'd also like to show the deviation to budget. So it's going to be two bar charts that are grouped as one visualization. So let's start off with a simple part first. So select a product, select actual, go to insert, go to the bar chart area here and select 2-D bar. Now let's quickly update the formatting of this. I'm going to remove the vertical grid lines here. Let's also remove the label axis. Let's right mouse click and add the labels directly to the bars. Let's also update the product names by making them stand out a bit more. So I'm going to go with bold and make them bigger. Another thing that I usually prefer to do in bar charts is to reduce the gap width between the bars. So select a series and press Control+1 to bring up the series options, or you can also double click on the bars to bring this up. For gap width, let's go with 80%. With a series selected, let's also quickly adjust the shape fill. Okay, so so far so good. I'll just make this a bit thinner. Now just be careful about your labels here. So there are two things you can control. This is the chart area and this here is the plot area. So just make sure that there is enough breathing space for the labels. I'll make this even thinner. Now you might have noticed the order of the products is different to the order of the products in the table. It's the other way round. If you'd like them to be in the same order, you can directly adjust this in the chart. So click on the axis, go go to series options. Under axis options, place a check mark for categories in reverse order. Now we have the same order as our table. Another thing I'm going to add to this is the horizontal grid lines. Because I'm planning to add a second bar chart on the side that shows the deviation, it's going to to make it easier to read if I have horizontal grid lines in there. So let's go and place a check mark for the grid lines. But by default, it puts the vertical ones. I want the major horizontal ones. So let's place a check mark...