Look Who it Was Random video

Excel - Where is Chart Marker Fill in Excel - Episode 988

734 views · Published 8 April 2009 · 3:21 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Where is Chart Marker Fill in Excel 

Welcome to another episode of Where's it Wednesday on the MrExcel netcast! In this video, we'll be discussing a common frustration that many Excel users face when trying to create charts in Excel 2007. Our viewer, Don, has a nice Cluster Chart but is having trouble changing the color of the first series from red to black. Don't worry, we've got you covered with a simple solution.

First, let's take a look at the three tabs in the chart toolbar: Design, Layout, and Format. These tabs go from general settings to specific settings, with the Format tab being the most detailed. To change the color of a specific series, we'll need to select that series from the drop-down menu in the Format or Layout tab. In this case, we'll select the "CENTERS" series and then choose the Shape Fill option to change the color to black.

Another option is to go into Format Selection, which will bring up a dialog box similar to the one in Excel 2003. Here, you can choose a marker style and then change the fill color and line color. However, if you just want to change the color without changing the style, it's best to stick with the first method.

It's important to note that chart formatting has changed significantly in Excel 2007, which can be frustrating for those used to the old version. But with a little bit of practice and some tips from MrExcel, you'll be creating charts like a pro in no time. Thanks for watching and be sure to tune in next time for another netcast on Where's it Wednesday!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to Where's it Wednesday
(00:11) Changing color of Chart Marker
(00:42) Solution using the Design, Layout, and Format tabs
(01:14) Using the Format Selection option
(01:53) Changing marker styles in Excel 2007
(02:12) The frustration of finding solutions in Excel 2007
(02:49) Conclusion and thank you for watching
(02:59) Recap of Where's it Wednesday
(03:11) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Change series color in Excel 2007 chart
Changing fill color in Excel 2007 chart
Changing series color in Excel 2007 chart
Finding formatting options in Excel 2007 chart
Formatting options for specific series in Excel 2007 chart
Formatting options in Excel 2007 chart
Frustrations with formatting charts in Excel 2007
How to change marker color in Excel 2007 chart
Marker style and fill options in Excel 2007 chart
Using Design, Layout, and Format tabs in Excel 2007 charts
Using Format Selection in Excel 2007 chart
YouTube video transcript, Where's it Wednesday? Excel 2007 charts

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152341/




While creating a scatter chart, Don is trying to change the marker color in Excel 2007. This was relatively easy to find in Excel 2003. In Excel 2007, the equivalent dialog was split into several panes, but there is a much easier way to go. Episode 988 discusses the three charting tabs and shows you the solution.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

More from this channel