percentage symbol goes the wrong way
Hi So I have this huge spreadsheet with Arabic text and some Hebrew (both are RTL languages) with many many tables and charts that are connected to them. In the cells of most of the tables, I see the % symbol in the right, where it should be, 15% for example, but in the pie charts' labels that are connected to those tables the % is on the left: %15 (i'm attaching two print screen maybe it will be more clear). I tried to delete the labels completely and add them again and it looks fine for a moment but then, I saved the file, closed it and open it again and problem came back. The add more mysterious to the situation in bar charts\graph line ETC the percent labels look fine. Hope some one can help me solve this mystery... Thanks
Pie Chart - legend missing one category (edited to include spreadsheet)
I have set of pie charts and when I add data to some of them, there is one category name that is missing in the legend (it is also missing in the "Horizontal (category) Axis Labels," see below) even though I have selected it a million times! The data for this category does show up in the pie chart and the color for the category also shows up in the legend (see below). I tried putting the category name on the data label to see if it would show up, and it did not show up there either. I've also tried making the category name short, removing the legend & adding it back, and making the legend larger. None of these fixed it. I also deleted all the category labels, selected all new ones, and all 3 did show up. When I selected the real ones again, that one does not show up. This is driving me crazy. Please help. thanks!
