F fergusonlaura Apr 4, 2008 #1 I have a big data series and want to manually assign three different colors to the bars. Can this be done?
I have a big data series and want to manually assign three different colors to the bars. Can this be done?
J Jon Peltier Apr 4, 2008 #2 Click once to select the entire series, then click again to select one point (one column). Then go to Format menu > Point, and apply a format to the selected point only. To do it automatically, you could set up a conditional chart: http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon
Click once to select the entire series, then click again to select one point (one column). Then go to Format menu > Point, and apply a format to the selected point only. To do it automatically, you could set up a conditional chart: http://peltiertech.com/Excel/Charts/ConditionalChart1.html - Jon