![]() ![]() So, for example, to work with the X-axis, I will double click batteries. If you want to format either of the axes, double click any value on that axis. And those are batteries, landscape, lighting and light bulbs, and solar panels. And the x axis, or horizontal axis, has the category data. The vertical axis displays the numbers, and those are the order counts for each of the years and each of the categories. The chart I'm working with here displays orders by category in year, and it's based on the data in the worksheet, some of which is obscured by the chart, but you can see that we have four different categories, and also values for 2016, 2017, and 2018. My sample file is the chart axes workbook, and you can find it in the chapter seven folder of the exercise files collection. I'll demonstrate how to make those changes in this movie. As with other elements of your charts, you can control the appearance of those markers. When you summarize data in a chart, Excel adds markers and labels to the chart's horizontal and vertical axes to help viewers interpret the chart's contents. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |