How to change the series order in a LEGEND ONLY...not data
I am using Excel 2003 and need to change the order of the series listed in
the LEGEND only...not the data that drives the chart...is there a way to do this? |
How to change the series order in a LEGEND ONLY...not data
The order of entries in the legend is dependent on the order of data in the
chart, as well as the chart type of each series, and which axis each series is plotted on. Generally these constraints frustrate any efforts to modify the order of legend entries. What I have done with limited success is to make a dummy chart with series I need in the legend, arranged in the order to provide the legend I want. I use a screen capture program to copy the legend of this chart, then paste it into the "real" chart. Whenever something changes in the data or formatting of the main chart, I need to recreate this static image of a legend. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Steve P" wrote in message ... I am using Excel 2003 and need to change the order of the series listed in the LEGEND only...not the data that drives the chart...is there a way to do this? |
How to change the series order in a LEGEND ONLY...not data
Hi,
You can use a dummy series to generate a sort of "mock" legend in an empty part of the chart, the limitation being that it has to be within the plot area, not outside it. Dave url:http://www.ureader.com/msg/10297314.aspx |
All times are GMT +1. The time now is 02:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com