D
Dewayne
I have created numerous tables where the row fill colors
represent a country's name i.e. US is a red fill, Mexico
is green fill etc. When I make a chart either bar or pie,
I want to have the bar representing the US be red, Mexico
green ect. and must manually change all of the country's
bars to match their row fill color in the table. I there
any way to automate this proceedure so that the bar or pie
piece will be the same color as the fill color of the row?
Thank you for any help.
represent a country's name i.e. US is a red fill, Mexico
is green fill etc. When I make a chart either bar or pie,
I want to have the bar representing the US be red, Mexico
green ect. and must manually change all of the country's
bars to match their row fill color in the table. I there
any way to automate this proceedure so that the bar or pie
piece will be the same color as the fill color of the row?
Thank you for any help.