customizing chart column color formats in code
 

papa jonah Mar 19, 9:48 am show options

Newsgroups: microsoft.public.excel
From: "papa jonah" - Find messages by this
author
Date: 19 Mar 2005 09:48:30 -0800
Local: Sat, Mar 19 2005 9:48 am
Subject: customizing chart column color formats in code
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I have some code that examines a set of data and generates a
x1columncluster chart. Depending on the set of data, I may have any
number of column clusters as a result. However, I currently format the
columns manually to make certain groupings a given color and another
group of columns a different color and so forth. I would like to
automate this.
Is there a way to go through each column like for x = 1 to
numberOfColumns
check group
If group = 1
set color accordingly
else set color differently
end if


Did that make sense?


TIA

Sorry for duplicate posting
 

Sorry for the duplicate posting

"Papa Jonah" wrote:

papa jonah Mar 19, 9:48 am show options

Newsgroups: microsoft.public.excel
From: "papa jonah" - Find messages by this
author
Date: 19 Mar 2005 09:48:30 -0800
Local: Sat, Mar 19 2005 9:48 am
Subject: customizing chart column color formats in code
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse

I have some code that examines a set of data and generates a
x1columncluster chart. Depending on the set of data, I may have any
number of column clusters as a result. However, I currently format the
columns manually to make certain groupings a given color and another
group of columns a different color and so forth. I would like to
automate this.
Is there a way to go through each column like for x = 1 to
numberOfColumns
check group
If group = 1
set color accordingly
else set color differently
end if


Did that make sense?


TIA