Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#3
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format charts legend | Charts and Charting in Excel | |||
Increase size of Legend Key in Pie Charts | Charts and Charting in Excel | |||
Matching the colors Column Charts and Pie Charts | Charts and Charting in Excel | |||
How do I share User-Defined Custom Chart Types in Pivot Charts? | Charts and Charting in Excel | |||
combing two bar charts to share one axis | Charts and Charting in Excel |