![]() ![]() So these are two simple and easy ways to switch the axis in Excel charts. Also, this way you don’t need to change any data in your sheet. Switching the axis option in a chart gives you more flexibility for adjusting the chart axis. In this case, you can just move Quantity in column B, and Sales in column C. I think you will find that creating combo charts and modifying them to get to your final polished output is much easier now.The above method works great when you have already created the chart and you want to swap the axis.īut if you haven’t created the chart already, one way could be to rearrange the data so that Excel picks up the data and plots it on the X and Y axis as per your needs.Įxcel by default sets the first column of the data source on the X-axis, and the second column on the Y-axis. Set the Category to Currency and the Decimal Places to zero. ![]() Right click on the secondary axis (Total Transactions) and choose Format Axis.ģ. Edit the axis title text Format total transactions axis as $ġ. ![]() Click the Add Chart Elements button next to the chart.ģ. So the two steps left are to add axis titles and format the Total Transactions axis as $.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |