Forum Discussion

rscully's avatar
rscully
Frequent Visitor
9 years ago
Solved

clustered chart scaling

Can anyone explain to me why when using this clustered chart a line total, which is many cases is higher than the bar, is shown LOWER than the bar?  I can tell it must have something to do with scaling between each (actual vs budget) but I can't for the life of me figure out why it's shown this way or worse - how to fix it?!?  Any help would be greatly appreciated!!!

 

Also, I wanted to upload a picture of the chart but could not figure out how one can do that?  The chart basically looks like this:

 

           Yr-Mth

Type       2016-01          2016-02         2016-03

Actual       13606            13052            13357

Budget      13547           13110             13547

 

^ in this post denotes 'greater than'

 

Result     Act>Bgt          Bgt>Act         Bgt>Act

Chart      Act>Bgt          Act>Bgt         Act>Bgt

 

As mentioned, I think the issue may be scaling because actual shows scaling of 0-14K while budget shows scaling o 12-14K.  I gather that maybe it's related to underlying data but I have not found any data in actuals that are zero. 

 

Thanks in advance for any help you can give to me.

 

Rich

  • v-haibl-msft's avatar
    v-haibl-msft
    9 years ago

    rscully

     

    The first Y-Axis of Line and column chart always starts from 0(default) or some other fixed number as you input in the Start Textbox. It is not dynamic as the secondary Y-Axis in current version.

    You can vote this idea here to push it become possible in future release.

     

    Best Regards,

    Herbert

8 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion
    9 years ago

    rscully

     

    In Format of the visual you can indicate that Secdondary axis start at 0 (Equal to your primary Y Axis)

     

    • rscully's avatar
      rscully
      Frequent Visitor
      9 years ago

      Hello Victor-

      Thanks for getting back to me!  What i would actually like is for both axis to be on a variable scale that is equivalent to the values being displayed.  As you can see from my example, both actuals and budgets are relatively close for this location but I can't hard code the axis scale since depending on which location I would select, the range can be quite different.  I.e. one location can have actuals/budgets around 13500 while another location can have actuals/budgets of 5000 or so.

       

      Thanks,

      Rich

      • Vvelarde's avatar
        Vvelarde
        Community Champion
        9 years ago

        rscully

         

        Try doing this:

         

        Enable Show Secondary

         

        Put Start  0

         

        Disabled Show Secondary