Using conditional formatting to create an hourly Gantt chart in Excel.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Ian wrote in looking for an array formula that would build a unique list of managers who belong to a selected VP. Since Ian has Excel 2013, I propose using Slicers instead of the insanely difficult array formulas.
jiayouluckystar from YouTube asks about controlling the word wrap of long labels along the x-axis. While the chart format dialog offers no control over word wrap, it can be done.
Dalia tried to use the Excel Interactive View to show data on the web, but she needs to show/hide columns instead of rows. Today, a way to filter by column using two pivot tables and a slicer. To try out the web app: http://tinyurl.com/lqwxwho
This duel started out as a simple question - do three lookups and multiply the results for an employee review system. But it evolved into a long discussion about array formulas and can you replace two function arguments with an array. Also along the way, a custom VBA function to solve the problem with a shorter formula.
Today's question: how do you change the font size in a chart legend in Excel. There are a lot of settings for the legend, but none appear to let you change the font size. The answer is hidden in plain sight.
Quinton from Jacksonville is searching for a way to have the Default Excel Table format persist from one workbook to the next, but the defaults only apply to one workbook. In Episode 1793, see how to use a custom Book.xltx template to store the table format for all future tables.
The second annual ModelOff competition starts on October 26, 2013. Play from your desk for a chance to win a trip to NYC for the ModelOff Finals. Or - compete against your co-workers for bragging rights. I am a judge for ModelOff 2013 and you can win one of 5 free entries to the competition.
Today, you have a column of numbers with a few #REF! errors scattered throughout. You want to sum the non-error cells. This is easy using Excel 2010 and AGGREGATE or more difficult using an array formula in earlier versions of Excel.
