And please use the Share buttons to share this post with others who might benefit. Leave a comment about your experiences with data order in PowerPoint charts. How do you control the order of the data in your charts? Some people go back to their original data, whether in the datasheet or in Excel and change it there, but if you don’t want to do that, one of these methods should work for you. Strangely, the colors of the chart change. Click in the Chart data range box, and then select the data in your worksheet. On the Chart Design tab, select Select Data. You can then use the Move Up and Move Down buttons to move the selected item up or down. On the Insert tab, select the chart type you want. Don’t uncheck an item or you’ll remove it from the chart. (I also found that using this dialog box sometimes froze PowerPoint, so save your work first.)
With the chart selected, click the Chart Tools Design tab. Plotly Chart Studio Create charts and graphs online with Excel, CSV, or SQL data.If I use Select Data from the ribbon, I can only change the overall chart data, and I cannot even select the data, I have to type in the new address.
#Make line graph on excel for mac select data source windows
You can manage the order of items one by one if you don’t want to reverse the entire set. I believe Excel Online is more advanced than other non-standard (standard being Windows or Mac) endpoints for Excel. If you’re reversing the values, the check box reads “Values in Reverse Order.” 2. If you want to change the order that the items appear on the horizontal axis, click that axis. In the Axis Options section (click the Axis Options icon if necessary–it looks like a graph), check the Categories in Reverse Order check box.
0 kommentar(er)
