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

Charts - How to have multiple charts share a legend.
 

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

http://pubs.logicalexpressions.com/P...cle.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/micro...f1758ea2695e89

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Sean" wrote in message
...
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

Charts - How to have multiple charts share a legend.
 

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

- Sean

"Jon Peltier" wrote:

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

http://pubs.logicalexpressions.com/P...cle.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/micro...f1758ea2695e89

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Sean" wrote in message
...
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