With DocHub, you can easily inlay legend in excel from anywhere. Enjoy features like drag and drop fields, editable text, images, and comments. You can collect electronic signatures securely, include an extra layer of defense with an Encrypted Folder, and collaborate with teammates in real-time through your DocHub account. Make changes to your excel files online without downloading, scanning, printing or mailing anything.
You can find your edited record in the Documents folder of your account. Prepare, send, print, or turn your document into a reusable template. Considering the variety of advanced features, it’s simple to enjoy seamless document editing and management 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