default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 180
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hello,
I have a table with some data on the y axis and months on the x axis.
It looks something like this (I am unable to publicly share the actual chart or data):
<tbody>
</tbody>
The generated chart looks as it should...except for one problem.
--- image removed ---
The month labels in the x-axis stop at July.
I haven't been able to get the labels to continue on through the end of the data.
I have checked the Horizontal (Category) Axis Labels data range and it is correctly set to the entire month range ($B$1:$M$1).
I noticed that when I hit the Chart Filters button that the Category Name is blanked out after July for some reason.
I feel like the issue stems from this section of data but I cant figure out how to reassign it so that the names appear.
What am I doing wrong here? How can I correct those odd blanks in the Chart Filters window?
Thanks in advance
I have a table with some data on the y axis and months on the x axis.
It looks something like this (I am unable to publicly share the actual chart or data):
A | B | C | D | E | F | G | H | I | J | K | L | M | |
1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
2 | Plan | 10 | 15 | 20 | 20 | 20 | 15 | 10 | 10 | 15 | 10 | 10 | 20 |
3 | Actual | 10 | 15 | 22 | 18 | 18 | 10 | 8 | 5 | 14 | 7 |
<tbody>
</tbody>
The generated chart looks as it should...except for one problem.
--- image removed ---
The month labels in the x-axis stop at July.
I haven't been able to get the labels to continue on through the end of the data.
I have checked the Horizontal (Category) Axis Labels data range and it is correctly set to the entire month range ($B$1:$M$1).
I noticed that when I hit the Chart Filters button that the Category Name is blanked out after July for some reason.
I feel like the issue stems from this section of data but I cant figure out how to reassign it so that the names appear.
What am I doing wrong here? How can I correct those odd blanks in the Chart Filters window?
Thanks in advance
Last edited by a moderator: