How to set the bar with same X-axis value in same colour?

T

Terry

I have a bar chart showing each team's values.
Total have "A, B, C, D" 4 teams. 2 teams each day.
Listed in X-Axis are date and team.
eg. 1 Jan A, 1 Jan B, 2 Jan C, 2 Jan D.
How to set the bar's colour to be the same to individual team?
Please advise!
FYI, i'm using MS Office 2007.
 
T

Terry

I just noticed the answer given by Herbert Seidenberg at below in 7 Mar.
Please ignore the question I raised here.
A lot of thanks to Herbert Seidenberg!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to set each gruop of columns into same color? 2
Set position of x axis labels 2
One extra x axis item that wont go away - can anyone help? 3
bar chart with dates on the x-axis 4
Secondary y-axis for certain x-axis categories (not by series) 2
Chart x axis problem 1
How to set up stacked bar charts with 2 axis? 1
2 axis chart stacked bar next to bar with line 1

Top