![]() But if either a) you can't figure out another way to do this and it's SUPER important to achieve this by-bar sort, or b) the report will only be used for a limited amount of time and doesn't need to update and add new bars as time passes, this could be a perfectly workable (if inelegant) solution. If that's the case, you would have to manually add a new stacked bar visual for each new time period as it occurs, which is obviously not ideal. Close to many bars, shops, and restaurants, as well as subway links Bright, modern rooms decorated in tasteful neutral tones Flat-screen TVs, minibars, safes, and rainfall showers come standard Upgraded units add Nespresso machines and/or sitting areas Country-chic dining room serves expansive buffet breakfast Bar and tapas served in. ![]() This isn't a perfect solution, especially if the report will be used continuously for a long time while new time periods (quarters, for example, if each bar represents a quarter) pass. ![]() You can even insert shapes and text boxes to imitate the look of the shared x-axis that you would get if you'd stuck with a multiple-stacked-bar visual. You can sort each bar by the volume or count or whatever your key criterion is, then manually place the bars from left to right in order of date. I think the best solution for your situation would be this: instead of creating one visual with multiple stacked bars, create several visuals with one stacked bar each. I realize this question is a year old, but I found it while looking for a solution to a similar problem, and I think I might have the solution to THIS problem.so I'm sharing it for posterity.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |