Charts - How to have multiple charts share a legend.

[Sean]

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

 

[Jon Peltier]

There are a couple macros at the bottom of this page:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=390

One of them formats points in a series based on the category name.

Post 5 in this thread shows a more flexible approach, which uses a worksheet
range listing the categories, the list is color coded, and the macro picks
up the colors and applies them as appropriate to the chart:

http://groups.google.com/group/micr..._frm/thread/1c58329c4cd0fb5c/c6f1758ea2695e89

- Jon

 

[Sean]

wow, you understood my question exactly. Thank you so much!

- Sean