Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
How to have multiple charts share a legend, so that the color properly
matches the same X value in each graph? Example: 3 different Data Tables: Name / Age, Name / Height, Name / Weight. Each table is sorted from highest to lowest, so when I goto graph them, a color is automatically assigned to each name. Problem: the color does not match with each name. "John" could be red in one graph, and blue in another. Is there a way to easily coordinate the colors to match throughout all 3 graphs, and continue to update the graph even if the data is re-sorted in a different order? (ie. simply put, is there a way to share legends between graphs?) Thanks! If you need more example, here is the file i'm working on: http://www.iamthanh.com/nba/wk3.htm |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format charts legend | Charts and Charting in Excel | |||
Increase size of Legend Key in Pie Charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
How do I share User-Defined Custom Chart Types in Pivot Charts? | Charts and Charting in Excel | |||
combing two bar charts to share one axis | Charts and Charting in Excel |