If you frequently work outside your workplace and accomplish tasks on the go, then DocHub is the document management service you need. It’s a cloud solution that works on any internet-connected device, and you can work with it just about anywhere. The interface is intuitive yet feature-rich, so you’ll need only a couple of moments to Add chart in Maintenance Agreement and make other necessary updates.
Stop wasting time trying to find an excellent document editor; explore DocHub today and prepare your paperwork no matter where you are!
In todays video, lets take a look at an Excel chart trick. Lets create a bar chart that automatically shows negative values in a different color to positive values. What Im 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. Lets check it out. (upbeat music) I have a list of products and the sales value for actual and budget. What Id like to do is create a bar chart for the actual sales, but Id also like to show the deviation to budget. So its going to be two bar charts that are grouped as one visualization. So lets 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 lets quickly update the formatting of this. Im going to remove the vertical grid lines here. Lets also remove the label axis. Lets right