Forum Discussion
Post Prodigyconcatenate x-axis does not work for all char types?
Microsoft EmployeeHey Everyone,
Please try resorting your axis alphabetically (even if it is that way now, sort by something different and then alphabetically again). The hierarchical axis works for combo charts just the same as column charts currently.
IkeumlautAdvocate I
This seems to work now for line and stacked column chart! Thank you very much!
Hi!
I'm currently having the same problem! My x axis has week numbers and year.
Tried the tip that Amanda posted, but it is just working for descending order and I want my chart in ascending order. Anyone who have experienced the same and have a solution for this?
tiztrainHelper I
I experienced the same. I ended up creating the exact same bar chart on another tab and it worked as should. The only thing that I have found to work so far.
Ok, but what if I don't want the x-axis to be sorted alphabetically? Is there a solution where I can keep concatenate labels off while also not sorting alphabetically?
I sorted my x-axis alphabetically and the concatenate labels option was turned off, but when I tried to resort by a different metric (e.g. total sales), the concatenate labels option was turned back on.