Whether you deal with papers day-to-day or only occasionally need them, DocHub is here to assist you make the most of your document-based tasks. This tool can shade chart in bill, facilitate user collaboration and create fillable forms and legally-binding eSignatures. And even better, everything is kept safe with the highest protection standards.
With DocHub, you can access these features from any location and using any device.
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