how to assign color for a data type

[R Krishna]

Hi
i have made a chart for sales of 12 items in 28 outlets over a period of 4
years (ie total sale for the year), not all outlets have all 12 items. the
outlest only stock what they think they can sell. so they may have sold an
item one year, and not sold it next year.

when I make a bar chart for each outlet I have 4 bars, one for each year,
and each item is stacked up on the other on the bar, now only problem is
that when i select another store, the bars all change colors, as in even if
item 7 were there in both shops, the color representing item 7 is diffrent.
In other words, irrespective of the shop I am looking at each item needs to
have a predetermined color that is same accross the shops.

I hope I am making sense

TIA
RKrishna

 

[Tushar Mehta]

How exactly are you creating these charts? If I use a PivotChart, the
results look just fine. Lacking a test data set, I made one up. Of
course, it is a very small set!

--
Regards,

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

 

[R Krishna]

Hi
I have data in ColA to G
ColA is shop name/Location
ColB is Item name/No
ColC is Item Code (cosmetic, hygenie etc)
ColD to G is the total sale for the year

now this is made into a pivot table, where ColC item code is page field,
ColA Shop name/location is Row field, ColDto G form the Data, and ColB form
the Coloum field.

but because of the large number of items when this is made into a chart
(Default Bars) it gets too crowded so the drop down is used to select only
one shop at a time. now the selection of colors for the bars are automatic
and every time you change the location the colors if items vary.

What I want to do is to set each item in ColB to be represented by a
specific color in every graph, if the item is not there the color should not
be there.

I can send you a sample data set, if you want (text file or xls), please
send me an e-mail add.

Thanks

RKrishna