Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bar graph colors?
Hello everyone, I have data with 5 variables for 10 countries, and I have made horizontal bar graph for each variable (so 5 graphs). This data i linked to another page, and it is divided by variable within the sheet For example, the format is: Country Variable 1 US ### China ### India ### UK ### Country Variable 2 US ### China ### India ### UK ### There is a macro that sorts each of this mini-tables, and then eac graph draws from its respective variable table. The same 10 countrie are in each table, but they are not in the same order, because they ar sorted from largest to smallest so that each horizontal bar graph i sorted largest to smallest. My question is, how can I make it so that each country has the sam color bar in each of the 5 graphs? For example, the US has a red bar i each graph, regardless of its position. Is there a way to do this? I' no VBA expert, but is there some sort of conditional macro I can d (any code someone has would be extremely helpful)? Is there an easie way? Thanks! -- anantathake ----------------------------------------------------------------------- anantathaker's Profile: http://www.excelforum.com/member.php...fo&userid=1813 View this thread: http://www.excelforum.com/showthread.php?threadid=38006 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line graph colors | Charts and Charting in Excel | |||
how to paint different colors in a graph? | Charts and Charting in Excel | |||
Graph colors automatically change | Charts and Charting in Excel | |||
Modify the default graph colors | Charts and Charting in Excel | |||
How do I set transparent colors in a graph? | Charts and Charting in Excel |