Trying to group graph bars by color based on month

[aejerome]

I am trying to get each month to have its own bar color for easier reading...

[addmaster666]

Hi! If you switch around the rows and the columns you can manipulate the colors of each bar

[aejerome]

Thanks for the reply! Do you know if there is a way to 'group' colors. For example, make the first four bars (Jan) red, the next four bars (Feb) green, etc...?

[sandy666]

You can try with PivotTable/PivotChart

[aejerome]

I'll give it a shot...thanks!

[sandy666]

You are welcome

If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
If you did it already - ignore it.
Thank you.

[dflak]

I invented a similar wheel for someone who wanted to show countries by color. So that explains the table name and column header. As it turned out, I had to change one line of code. Go to sheet one and select the colors you want for each month. The macro is called ListChart.

[aejerome]

That's it - perfect! Thanks!