If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Series order conflicts with line order
I've set my series in the order that I want, however, it conflicts with the
visual layout of the lines. One data line (less important) visually obstructs another line in the chart. Is there a way to change the layout order (without changing the series order), i.e., forcing it "back" or "behind" another line. Thanks. Diana |
#2
|
|||
|
|||
Series order conflicts with line order
Hi,
Perhaps you could use the secondary axis, which will plot lines in front of the primary axis series. Add a new series based on the same cells and set it to the secondary axis. That should sort the obstruction. You will then need to remove the addition legend entry, see here for details of how to do that. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy Cowtoon wrote: I've set my series in the order that I want, however, it conflicts with the visual layout of the lines. One data line (less important) visually obstructs another line in the chart. Is there a way to change the layout order (without changing the series order), i.e., forcing it "back" or "behind" another line. Thanks. Diana -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
|
|||
|
|||
Series order conflicts with line order
Hi Andy,
Thanks for the posting. I'll look into that. Without reading that info, I think I'll still need to keep that particular data set on both axis - don't want to lose it in the original legend (need it first on the list). Diana "Andy Pope" wrote: Hi, Perhaps you could use the secondary axis, which will plot lines in front of the primary axis series. Add a new series based on the same cells and set it to the secondary axis. That should sort the obstruction. You will then need to remove the addition legend entry, see here for details of how to do that. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy Cowtoon wrote: I've set my series in the order that I want, however, it conflicts with the visual layout of the lines. One data line (less important) visually obstructs another line in the chart. Is there a way to change the layout order (without changing the series order), i.e., forcing it "back" or "behind" another line. Thanks. Diana -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#4
|
|||
|
|||
Series order conflicts with line order
Plotting a series on the secondary axis also changes its place in the
legend. You could plot the series twice, format both the same in the chart, and then delete the legend entry which you don't want. To delete a single legend entry, select the legend, then click on the legend entry's label, and press delete. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "Andy Pope" wrote in message ... Hi, Perhaps you could use the secondary axis, which will plot lines in front of the primary axis series. Add a new series based on the same cells and set it to the secondary axis. That should sort the obstruction. You will then need to remove the addition legend entry, see here for details of how to do that. http://www.andypope.info/charts/deletelegendentry.htm Cheers Andy Cowtoon wrote: I've set my series in the order that I want, however, it conflicts with the visual layout of the lines. One data line (less important) visually obstructs another line in the chart. Is there a way to change the layout order (without changing the series order), i.e., forcing it "back" or "behind" another line. Thanks. Diana -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Charts Line Types for Multiple Data Series not Printing Properly | Seanb | Charts and Charting | 0 | August 22nd, 2005 06:35 PM |
line numbers | Al V | Running & Setting Up Queries | 7 | July 14th, 2004 07:33 AM |
Inhereting the sort order | Dan St.John | Setting Up & Running Reports | 1 | July 9th, 2004 03:30 AM |
Discontinue part of line in chart | Jon Peltier | Charts and Charting | 0 | April 1st, 2004 10:27 PM |
How to use (and move) a vertical line as a cursor in x-y plot | Rick Jones | Charts and Charting | 1 | November 3rd, 2003 05:52 PM |