00:00In my previous video, I demonstrated how you can draw this target line here, but
00:03someone had asked a question, what if you want to highlight any of this bar chart
00:07that's below this target line? That will make the chart look something like this.
00:11Well, this is how you do it. First, you're going to create a preparatory line or
00:16column, and you're going to use the formula to say, if this thing is less than or
00:21equal, or maybe say less than the target, we're going to show that total sales. If
00:27not, we're just going to show it blank like this, and you're going to apply the
00:30same formula to the rest of the row like this. Next, you're going to copy this in a
00:35clipboard by pressing Ctrl C, and click your chart, and then you press Ctrl V to
00:40introduce your line chart in place. Then you're going to right click this, and then
00:45you go to change series chart, and basically go to combo and change your
00:50line series, which you just added to a cluster, and click OK. Now that you added
00:55this bar chart here, now to merge them together, right click on this bar chart,
00:58the gray one, and you go data series here. Make sure you select this series
01:03option here, and series overlap, you're going to put it to 100% so that they
01:07overlap. Now to change the color of the bar chart, you right click on it, go to fill,
01:11and just change to whatever color you want. I'm going to change to red, so it's
01:14obvious, and then you're done.
Comments