Associating Colors with data points.

  • Thread starter Thread starter Shashank Khanvilkar
  • Start date Start date
S

Shashank Khanvilkar

Hi,
I am facing this problem im Excel.
I have a some data that needs to be plotted as a bar-chart. However,
each data-point in this data belongs to one of 4 categories.. Now I
want to assign each category a color, thus coloring all data-points
belonging to the same category with the same color.

How can this be done.. Please note that there are many data-points..
so manually doing this is not an option. Also I have already seen
sites like
http://www.geocities.com/jonpeltier/Excel/Charts/format.html
which do not seem to serve my purpose.
Thanks
Shashank
 
Suppose your data are in col. A. Then, based on whatever criteria you
use for developing the categories, put the corresponding data in cols.
B through E -- the best way would be some formula in B1 like
=IF(category-1-1-data,A1,NA())

Plot the data in B:E in a stacked column chart. Alternatively, create
a clustered column chart and set the overlap (double-click any column,
then select the Options tab) to 100%.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
Back
Top