bar chart: vary colors by point option

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
Hi
Yesterday, I inserted a bar chart. I right clicked on any bar in that char and then clicked on "Format Data Series" then Click on Fill icon, but could not find []Vary colors by point!!

I am not able to reproduce that issue again! My question do you know under which circumstance that option might get disappeared?
Thank you.
 

Some videos you may like

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,771
Hi

That option is only for single series charts.

I guess that yesterday you had a chart with more than 1 series.
 

Watch MrExcel Video

Forum statistics

Threads
1,095,388
Messages
5,444,187
Members
405,272
Latest member
skipowers

This Week's Hot Topics

Top