Number Number doesn’t work either as Excel thinks all three columns are data series and not category labels. This is not a deal killer as you can stub in text instead of the numbers and then after you make your chart, just copy and paste the number data back into the chart and problem easily solved.ģ) Number in Main Category and Number in Sub-Category What Excel is doing is that it thinks the sub-category is just another series. If we put text in the main category, but put any kind of number (numbers and dates) in the sub-category, then it doesn’t work. But as you will see in the video and the tutorial below, you won’t have to use just text. Based on his description, I determined that the problem was that he wasn’t using text for both the Main Category and Sub-Categories. Notice that the Multi-level Category Label check box was no longer an option. When he right clicked on the horizontal axis and selected Format Axis, he was seeing this: So he was having a problem with the getting the Multi-level Category Labels to work. Thank you so much for your tutorials! They are so helpful.” –MacUser I’ve been trying to do something similar to the second option you showed in this video: īut I can’t get the Multi-level category option to show up it just reverts provides the regular max/min/interval axis options.ĭo you know whether it’s possible to get Multi-Level category labels on Excel for Mac? How would I do that/How is it different? “Hi, I would like to know whether the Multi-Level Category Labels are available for the Mac 2011 version of Excel.
0 kommentar(er)
