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

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" <(E-Mail Removed)> wrote in message
news02D33B8-8E5E-45D6-902B-(E-Mail Removed)...
> 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

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" <(E-Mail Removed)> wrote in message
> news02D33B8-8E5E-45D6-902B-(E-Mail Removed)...
> > 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
>
>
>