SarahC07 0 #1 April 24, 2009 I want to tell excel what color to make the series in a bar chart. Can this be changed in VB? I'll need to use the IF function or something similar, because the data in the series does not dicate what color I want it... another variable does. Does that make sense? Can anyone help? Quote Share this post Link to post Share on other sites
hypsin 0 #2 April 24, 2009 If you know a bit of VBA then this will help: Quote Use SeriesCollection(index), where index is the series index number or name, to return a single Series object. The following example sets the color of the interior for the first series in embedded chart one on Sheet1. Worksheets("sheet1").ChartObjects(1).Chart. _ SeriesCollection(1).Interior.Color = RGB(255, 0, 0) References: http://msdn.microsoft.com/en-us/library/aa213725(office.11).aspx http://msdn.microsoft.com/en-us/library/aa174298(office.11).aspx Hope that helps. Quote Share this post Link to post Share on other sites
SarahC07 0 #3 April 24, 2009 Yeah, I've got that figured out. Thanks Now I need to figure out how to insert an if...then... into a for... next... for that segment of code. Can I even do that? Quote Share this post Link to post Share on other sites
hypsin 0 #4 April 24, 2009 Are you looping through charts, series or each individual bar? Quote Share this post Link to post Share on other sites