Create a Dot Plot in Excel. When you use this approach to create dot plots, you can change the color of the dot chart by just changing the font color. In the example below, I've used conditional formatting in Excel to automatically make the maximum value red. Using conditional formatting to highlight the Max. Make a copy each time of a clean worksheet with your layout. 2: Right click on the sheet tab and choose 'Move or Copy.' Or hold the Alt key down and drag the sheet tab to the right or left with your mouse. When you release the mouse button you will see the copy of the sheet.

If you need to capture a short video, you can also use this application. Mac screen capture video.

I'm working on a spreadsheet which was created in an earlier version of Excel (2003 I think), and it makes extensive use of color-coding for organization. Unfortunately, it was built using the color-scheme from the older version, and basically none of the colors match those in the 2010 theme (except for pure white and pure black). So every time I want to make something conform to the previously existing color-scheme, I either have to choose a custom color and select it by hand, or I have to copy formatting from an existing cell and paste into the target cell (which is annoying because it also copies stuff like borders, etc.) I've found the Page Layout/Themes/Colors setting, but it seems all I can do there is change the selectable colors to one of their presets, or create a completely new palette - and I only get to select a few colors in that palette, not the full set. It creates the rest by making lighter or darker versions of the colors you choose. Plus, doing either of these things will change the colors already used on the spreadsheet if and only if they exactly match colors used in the previous scheme. This means that things which used to be colored in similar tones to denote their relationship are now colored differently, some remaining in the old scheme and others being automatically changed to the new.

It basically breaks the whole system. What I want is to be able to just add the specific colors I use from the old document so that they appear in the color chooser and I don't have to go searching for them. Older versions of Excel had this capability - there were a bunch of customizable squares that you could make any color you want and they'd be saved with the theme. I think you could even add more squares, I forget.

(Don't have the old version installed anymore.) Did they remove this feature in favor of their 'Themes'? Or is it hidden away somewhere? I'm not at all interested in this color schemes feature.

I just want to use whatever colors I want to use (particularly the ones that match this document) without having to worry about whether they match some arbitrary preset palette or not. I'd really rather not have to re-color this entire sheet using the new schemes setup just so that I can maintain a level of consistency here. Hmm, I'm afraid you're out of luck. In Excel 2003, there was a colour palette with 40 customisable colours for worksheet use and 16 additional colours for chart use.

The default palette settings could be customised and changed with the file, chart colours could be used in worksheet cells and vice versa. Starting with Office 2007, this principle was replaced with the 'theme' colour, which consists of two text and six accent colours and different intensities of these to choose from. Themes are consistent across all Office applications.