Posted to microsoft.public.excel.charting
|
|
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
|