Forum Discussion

SamRounsevell's avatar
SamRounsevell
New Member
9 years ago
Solved

Formatting X Axis - display all values in order

I'm trying to show a count of sales alongside the quantity of outgoing communications on the same day:   If I choose Continuous it shows the dates in the correct sort order but hides most values: ...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)

     

    Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions

     

    Click the ... in top right corner of the Chart and Sort By Date

     

     

    Yes if you have all dates you can create a column

    Column = 0 and place it in the chart - that will force all dates to be seen

    however you won't be able to use the legend if you do this...

     

    HTH! :smileyhappy:

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

The other thing I noticed in your first post - in the second picture (when the X-Axis is Categorical)

 

Thy sorting the Chart - Sort by the Date - it looks like it was Sorted by Transactions

 

Click the ... in top right corner of the Chart and Sort By Date

 

 

Yes if you have all dates you can create a column

Column = 0 and place it in the chart - that will force all dates to be seen

however you won't be able to use the legend if you do this...

 

HTH! :smileyhappy:

SamRounsevell's avatar
SamRounsevell
New Member
9 years ago

Ah, I never knew the sort function was there :)  Perfect, thank you very much!