The above action will take you to the chart editor in Sheets. You can also use the keyboard shortcut Alt+I+H to insert a chart from the selected range in a flash. To plot the chart, select the data range and go to the menu Insert > Chart. This can be valuable for newbies to column chart in Sheets. How to solve this?īefore going to explain how to show month and year in x-axis using the workaround, see the chart settings of the above column chart. In this, you can see that the x-axis is crowded with values.
This is the normal way of displaying the month and year in a column chart. In that, the category axis (x-axis) will contain the month and year values. Here I am going to create a column chart which is more common in such type of visualization. Must Read: Built-in Charts, Dynamic Charts and Custom Charts in Google Sheets. With that data, I can plot a column, bar, line, etc. I have that data in a Google Sheets file, formatted as above. If you have monthly consumption data as below, it’s possible to show month and year in x-axis in a combined form.Īssume I have the monthly consumption of gasoline by a fleet of trucks (fleet fuel spending data) in our company for the last two years. How a Normal Column Chart Displays Monthly Data
I hope the below workaround will address that moderately. Here the limitation means, the chart will display the years in the x-axis, but the month names will be displayed as x-axis labels.īy displaying month and year in the x-axis, we intend to use years as the main category and months as it’s sub-category. Here in this workaround that to show month and year in x-axis in Google Sheets, you will see that limitation. But it’s limited and not like the ones that you may have experienced in other applications. Google Sheets Column, Line, and Bar charts do have the capability to display multiple categories in the x-axis.
0 kommentar(er)
