By default Excel column and bar charts leave you with a lot of space between bars, which doesn’t look great visually and is a bit of a waste of space. Fortunately it is simple to change the gap widths between the bars. Right-click on a bar and select Format Series, under Series Options you will see Read More …
Month: April 2016
Why can’t I modify or delete my Excel custom slicer style?
Just a quick troubleshooting article on this one, as it can be a nuisance but it is very easily resolved. You may find that when you go to Modify, or Delete a custom slicer style you’ve created that nothing is happening. It will still let you Duplicate, but that just leaves you with a Read More …
Exclusive Or formulas with the XOR function
Most frequent Excel users will be familiar with both the AND and OR functions, but here’s a quick recap just in case. Both AND and OR are Boolean functions, which means they will return either TRUE or FALSE based on the set of conditions you pass them. The below table shows the top Read More …