Here is the BETA version of my Colour Manager, and tool for creating colour pallets in Excel:
It’s a VB6 com addin, the only thing you really need to know is that you load a picture on the left and then click that picture to get the colour at that point. You can then click a pallet square to place it where that square is. Click the send to workbook button to send it to the active workbook.
However I have also made a video to show how to use it. Bosh!
Sometimes I trawl the internet trying to find new ideas. Quite often it’s charts and graphics that I’m looking for. This stopped me dead in my tracks and I had to post about it.
Sometimes we want to hide our data but still display the values in a chart. By defult Excel will remove the chart content when we hide rows or colunms.
The answer is to change a setting in the Excel Maze, sorry options box.
Select the chart you wish to change then goto: Tools > Options > ;Chart
then unselect the “Plot Visible Cells Only” option.
Another option to consider is putting the data in another worksheet then hiding that sheet.
