With DocHub, you can easily rework legend in xls from anywhere. Enjoy features like drag and drop fields, editable textual content, images, and comments. You can collect eSignatures safely, include an extra level of defense with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make adjustments to your xls files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Manage, send, print out, or convert your file into a reusable template. With so many robust tools, it’s easy to enjoy smooth document editing and managing with DocHub.
Hey. Welcome back to the MrExcel netcast. Im Bill Jelen. Well, we almost have this chart working perfectly. We can choose UNDER, AVERAGE, or OVER and Excel will change the color of the chart. Now, we set that up in the last 2 days podcast. The one last thing that really drives me crazy about this chart is the legend is showing both the red, the yellow, and the green when, in fact, we only have one of them on the chart. So, Iamp;#39;m actually going to get rid of the legend. Im going to click on it and press the DELETE key. I want to make our chart a little bit smaller, reduce the size of the plot area to give me some space at the top, and Iamp;#39;m going to add a text box, draw a nice, little text box in here, and thatamp;#39;s going to hold the words UNDER, AVERAGE, or OVER. I will format that text box to be a little bit larger and now, somewhere in my worksheet, I need to come up with a formula that will give me the words UNDER, AVERAGE, or OVER, and so, right here next to whe
