Modify scale on an axis of a graph

Luis Cazares
Luis Cazares ✭✭
edited 12/09/19 in Formulas and Functions

Good Day

t´s possisble modify scale in an axis of a graph exist? for example, I have a graph, in the vertical axis the scale it´s 0.5 to 0.5, but i want that scale will be 1 to 1, it´s possible?

 

regards

Comments

  • Debbie Sawyer
    Debbie Sawyer ✭✭✭✭✭✭

    Hi Luis

    I believe you have come across a limitation in charts, I don't think you can manually edit the vertical axis as this is a dynamic setting determined by your data.

    If this were my issue, I would try a workaround, by adding a test column of data to my table, with data in it to force the Axis to increase to show the numbers I want.  Then I would change the colour of that series to the same colour as the background of the chart to "hide" it.  That way you get your axis updated dynamically, but there will be a "space" in the chart.  I would make the test column the last column in the data table, that way it might not be so noticeable.

    Hope this helps.

    Kind regards

    Debbie Sawyer Consultant & Training Manager

     

     

    Smarter Processes mean happy people in successful businesses

     

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!