When you edit documents in different formats every day, the universality of the document solution matters a lot. If your instruments work with only a few of the popular formats, you may find yourself switching between software windows to finish chart in excel and manage other document formats. If you want to eliminate the headache of document editing, get a solution that can easily manage any format.
With DocHub, you do not need to concentrate on anything but actual document editing. You won’t need to juggle programs to work with different formats. It will help you revise your excel as easily as any other format. Create excel documents, edit, and share them in one online editing solution that saves you time and boosts your productivity. All you have to do is register a free account at DocHub, which takes just a few minutes.
You won’t need to become an editing multitasker with DocHub. Its feature set is sufficient for fast papers editing, regardless of the format you need to revise. Start by creating a free account and discover how effortless document management might be having a tool designed particularly to meet your needs.
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