Forum Discussion

jaime-aaron's avatar
jaime-aaron
Frequent Visitor
8 years ago
Solved

Incremental Values

Good day!

 

Would like to ask, how to create a incremental value for my horizontal axis?

 

Scenario: Need to create report of revenue in 50,000 increment. See sample below:

 

 Thanks!

 

 

  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi jaime-aaron,

    I reproduce your scenario and get expected result. I create the following sample table.



    Then create a Clustered column chart, it will show the first screenshot automatically. If you want to create a incremental value, please right click ellipsis on the right top of chart->sort by Value, you will get the expected result as the second screenshot shown.

    The chart by defaultSort by value ascending

    Best Regards,
    Angelia

1 Reply

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    Hi jaime-aaron,

    I reproduce your scenario and get expected result. I create the following sample table.



    Then create a Clustered column chart, it will show the first screenshot automatically. If you want to create a incremental value, please right click ellipsis on the right top of chart->sort by Value, you will get the expected result as the second screenshot shown.

    The chart by defaultSort by value ascending

    Best Regards,
    Angelia