change chart column colors

W

WCM

Hi ...

Is there a way to make different columns that are in the same data series to
be different colors? I know about [format data series] > [options] > [Vary
Colors by Point], but this makes every data point a different color. I just
need certain groups inside the data series to be different colors.

For example, say on the X-axis I have India, China, UK and each country
comprises three month sub-categories (Jan, Feb, Mar) - so Jan, Feb, Mar are
child-categories within each country (parent) category. Sales Dollars on the
y-axis.

Is there any way to make Jan-Feb-Mar columns within each country the same
color, but Jan-Feb-Mar column colors are different across the countries?
(e.g., green columns for India, blue columns for China, orange columns for UK?

Jan Feb Mar Jan Feb Mar Jan Feb Mar
India china UK
 
W

WCM

Just found answer below: click once to select entire data series, left-click
again to get just the column (and then color format that one column).
 

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

Top