Associating Colors with data points.

  • Thread starter Shashank Khanvilkar
  • 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
 
T

Tushar Mehta

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
 
Top