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 scali...
  • 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

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

rscully

 

Try doing this:

 

Enable Show Secondary

 

Put Start  0

 

Disabled Show Secondary

rscully's avatar
rscully
Frequent Visitor
9 years ago

That works, kind of.  I don't want the scale to start at 0 since it then really doesn't show variances/variations very well.  I want both axis' to be dynamic to the data but as mentioned it's not working that way for me.  Thanks again.

  • rscully's avatar
    rscully
    Frequent Visitor
    9 years ago

    Here's another example where/when I leave the Start field blank on the secondary axis.  Notice how the 2nd axis is dynamic while the primary axis is not (i.e. it starts at zero).  I have 2 pics here with the chart itself being the same.  The only difference is I show the setting for the primary Y-axis in the first pic and the secondary axis settings in the second pic.

    • rscully's avatar
      rscully
      Frequent Visitor
      9 years ago

      Figured out a little bit more and determined that it may be related to the chart itself.  If I select the 'line and clustered column chart,' the scale/start value on the y-axis is zero.  If I use a 'line chart,' the scale/start value on the y-axis is dynamic.  I prefer the line and clustered column chart though I'm thinking I might not to be able to unfortunately since the chart scaling doesn't work properly.

      • v-haibl-msft's avatar
        v-haibl-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        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