R
Risky Dave
Hi,
I would like to automatically apply some custom formatting to a standard bar
chart.
For example, I have a data set:
Student Name Score Country of Study
Alfie 70 US
Bart 80 UK
Charlie 60 France
Denise 75 US
My chart shows each student and their score (nice and easy) but I would like
the colour of the bar to reflect the country in which the students are
studying, so that, for example, all US students are Blue, all UK students are
Green and all French students are Yellow.
I could do this manually (I think!), but it would involve a huge amount of
effort with my actual data, so can this be done automatically, either through
manipulating the data layout or VB, or a combination of the two?
TIA
Dave
I would like to automatically apply some custom formatting to a standard bar
chart.
For example, I have a data set:
Student Name Score Country of Study
Alfie 70 US
Bart 80 UK
Charlie 60 France
Denise 75 US
My chart shows each student and their score (nice and easy) but I would like
the colour of the bar to reflect the country in which the students are
studying, so that, for example, all US students are Blue, all UK students are
Green and all French students are Yellow.
I could do this manually (I think!), but it would involve a huge amount of
effort with my actual data, so can this be done automatically, either through
manipulating the data layout or VB, or a combination of the two?
TIA
Dave