MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?

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