View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Sean Sean is offline
external usenet poster
 
Posts: 208
Default Charts - How to have multiple charts share a legend.

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