AuthorKaren ArchivesCategories |
Back to Blog
Click the Shape Outline.When you know how Excel’s color system works, you can do some great work. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click the chart element that you want to use.Click the Shape Outline button Chart Tools Format tab, Shape Styles group and choose Purple, Accent 4, Darker 50 (eighth column). This displays the Chart Tools, adding the Design, Layout, and Format tabs. On a chart, click the chart element that you want to change, or do the following to select it from a list of chart elements: Click a chart.
![]() ![]() Also, the standard colors are unchanged.At the bottom of the list of color themes is a button labeled Customize Colors, which leads to this dialog. The color names have changed, but the percentages are all the same. I’ve actually grown to like working in Excel 2013, much more than in 2010 and especially in 2007 I suspect the happier colors have contributed to my acceptance of 2013.Here are the names of the colors in the Office 2013 theme. The Office 2013 colors are brighter, and look very good in charts. The 2010 theme’s colors are somewhat drab, although a major improvement over the default Excel 2003 palette, and reportedly friendly to those with color vision deficiencies. There are a slew of other themes too, but it seems most of them are skewed to much towards a particular color to be good for general use.Below are the color choosers for the Office 2007-2010 default theme (left) and the Office 2013 default theme (right). Turquoise, for example, is somewhat deeper than Aqua.Notice also the percentages. Notice that Excel tries to guess the names of the colors, or it probably has a lookup table. Then you can name and save your custom theme.Here I’ve populated the accent colors with pure, fully saturated versions of the Office 2007-2010 theme.Here are the color names for my custom palette. There is a preview of how the colors look together, and each color dropdown opens a color picker that lets you access all 16+ million combination of red, green, and blue pixels. ![]() I can’t say that it’s any more legible, but less drab is good.Here I’ve applied my bright and bold custom theme.Ouch! It’s a good reminder to use a reputable source for your color scheme. Much better than the default 2003 chart, though.Here is the same chart after changing to the Office 2013 theme. Legible but pretty drab except for the aqua bars on top. Purple Accent 4 Darker 50% Shape Outline For Excel Series In TheI use it so much I find myself trying to use it in other programs, and it never does anything.What Ctrl+1 does in Excel is open the formatting dialog or task pane for the selected object. I’ll illustrate with formatting the fill color of one of the series in the column chart.One of the most useful shortcuts in Excel is Ctrl+1 (that’s the numeral one). Formatting Chart ColorsOnce you have your chart, there are many ways to format its elements. Brewer, Pennsylvania State University. Safe free excel download for macIn Excel 20 there is a formatting dialog, which floats modelessly over the worksheet. Somewhat.I’ve floated the task pane over the chart and clicked the Fill Color dropdown to reveal the color chooser.The formatting task pane was introduced in Excel 2013. In this way it somewhat resembles the long lost floating tearaway toolbars from Classic Excel. I’ve clicked the Fill Color dropdown, and the familiar color chooser pops up.The taskbar can be undocked by clicking on its top edge and dragging it to where you want to use it. Its default position is docked to the right edge of the workbook window.
0 Comments
Read More
Leave a Reply. |