It would be wonderful, if you could please let me know if there is another trick to reorder groups of chart styles, if you have a chart with multiple styles say smooth scatter with straight line style.Workaround for this bug:1) change the type of graph to something else, Bar graph worked for me2) change the order of data series with any of the method described above, I used Select Data Source dialog 3) switch the type of graph back, in my case it was XY Scatter4) eventually fix some formatting lost by changing the graph type Sadly, even though this post is only a month old, none of what you say here matches what I see in my Excel. Your site matches many of the others that are out there, but I am just unable to change my legend order, I guess.Excel is putting all the columns in the legend first, then the lines after that in the legend.I need to be able to show a column then a line, then a column then a line in my legend, how can I accomplish that ?A colleague and I have an issue with the refreshing of charts in excel.The issue is the chart doesn't update when the source data is changed.
This method may also work for solving the issue of ordering the legend entries for a chart with mixed chart types.
Maybe it's because I'm using a map display?
To show a column, a line, another column, another line, etc., have you tried splitting the series onto 2 charts (one of columns, one of lines) using the same axis values?
Zoran would like to change the order of entries in the chart legend, but can't find a way how to make such a change.
When you add a legend to a chart, the order in which the legend items appear is dictated by the order in which the data series are charted.
He is president of Sharon Parq Associates, a computer and publishing services company. Check out When I tried this trick by reorder the listing in the select data menu, it did work within a group of charts which were smooth scatter, not for the ordering of whole groups.