Excel Change Legend Order. Click one of the data series in your chart. I'm building a stacked area chart with 8 items but they are not appearing in the order i would like them.
How to Add a Legend in an Excel Chart
Click anywhere on the chart step 2. While i know how to do change the order in a standard chart, i don't. Web excel orders legend entries by chart type first, then by series, and sadly for you lines comes after bars. To reorder the bars, click on the chart and select chart tools. Jon peltier has described his findings at. Web select the chart and use the buttons on the right (excel on windows) to adjust chart elements like labels and the legend, or chart styles to pick a theme or color scheme. In the select data source pop up, under the legend entries section, select the item. Select the chart and go to the chart design tab. Click one of the data series in your chart. In the formula bar, you should see something like this:
Click the layout tab, then legend step 3. Under the data section, click select data. Web how to change the order of your chart legend. Jon peltier has described his findings at. While i know how to do change the order in a standard chart, i don't. Select the chart and go to the chart design tab. Web as the charts are grouped, the display of the legend changes, so it is unlikely that the chart and the legend will be linked. Web the legend order is always tied to the data series order.) to change the data series manually, try this little trick: In the select data source pop up, under the legend entries section, select the item. Select show legend at right figure 2. Web does anyone know how to change the order of items in a legend in a pivot chart?
