Browse » Home
Tuesday, July 24, 2012
How to Make a Series the Same Color Across Multiple Charts in Excel 2010
1. Launch Excel and open the spreadsheet that contains the charts for which you want to create a common color for a data series. Click the chart to display the “Chart Tools” menu in the ribbon.
2. Click one of the data series in a chart for which you want to create a common color. Click the “Format” tab and locate the “Current Selection” section. Click the “Chart Elements” menu and select the “Data Series” option. Click the “Format Selection” button, which will open a separate window.
3. Click the “Patterns” tab and click a color in the “Area” section. The series will automatically take on the selected color. Repeat steps 2 and 3 for the same data series in each chart, selecting the same color each time.