chart colors to match colors in chart

**ammartino44** · 08-19-2015, 04:20 PM

Hello. How can I get the colors in my chart to match the colors in my table? Spreadsheet attached.

**6StringJazzer** · 08-19-2015, 04:29 PM

It can't be done automatically unless you use VBA code.

To do it manually, right-click on any of the vertical bars in your chart then click Format Data Series. On the panel on the right click the paint bucket, click Fill, click Solid Fill, then click on the color palette to select the desired color.

**ammartino44** · 08-19-2015, 08:41 PM

I know. I want vba code haha.

**6StringJazzer** · 08-19-2015, 09:33 PM

Oh, I'm sorry, I didn't notice which subforum you posted in.

Let me get back to you on this.

**6StringJazzer** · 08-20-2015, 06:49 PM

You have three colors, but only one data series. Columns in a single data series must all be the same color. You would have to create three series. See attached for revised chart plus code to format.

This assumes that each data series has a single data point.