Archive of Mr Excel Message Board

Check out Bill's new book on Charts and Graphs for Microsoft Office Excel 2007

Back to Charting for Excel archive index
Back to archive home

adding new source data to chart

Posted by LT on November 05, 2001 11:52 AM

I am adding a new data set to an existing line chart. The data needs to be inserted as the third set in an existing five set series in the source data => series window. However, I can only add the new data set as the sixth series at the end of the series. Is there a way to insert it in the middle of existing series?

Re: adding new source data to chart

Posted by Tracy on November 06, 2001 12:15 PM

Double click on the data series you just added. On the format data series box, choose the Series order tab. You can then move the series up or down to where you want

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.