Benches Uncategorized

5

How to set Minimum Value

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

When I create a chart from a table, I find that Numbers chooses a minimum value which may not be zero. As a result the proportions tend to highlight a greater disparity between results than I'd like to show.

You can see that with the chart on the right in which the Minimum Value on the Y Axis is 50%

In order to change this to 0% I had to add another column with a 0 in it. You can see the results in the chart on the left. The small differences between bars better exemplifies what I'm trying to present. The problem is I now have an empty space on the right side of that chart.

I can't crop the chart or otherwise do anything to the column in the originated table to make it invisible in the chart.

Is there a way to handle this that I'm overlooking?

5 replies

Sign in or join Beachball Help to reply.

  1. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Help tends to be sparse. Different people learn in different ways, but I've found with Numbers charts there is no substitute for just experimenting. Studying the Charting Basics template (at File > New in your menu) is also helpful. And, when you can't figure out how to do what you need, Ian and other charting experts here often have the solution. Better than any static "manual."

    SG

  2. 0

    Yellowbox

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Hi Craig,

    Click on the chart then look at Format Panel > Axis > Value (Y)

    Under Axis Scale > Min, type 0 to replace Auto.

    Now change the number of Steps on the Y axis so that we humans can get a sensible Y axis. I used 11 Major steps for this example.

    Regards,

    Ian.

  3. 0

    Craig Seeman

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank You. I'm using Numbers 5.3 (current version) and no where in Numbers Help could I find that. Search terms like Minimum Value or even Axis showed no results. I couldn't find it looking directly through Create and modify charts either.

    Is this not in the Help file?

    If so can you point me in the direction?

    I tend to be a copious reader of manuals and was surprised that I could find no mention of this at all.

  4. 0

    SGIII

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Help tends to be sparse. Different people learn in different ways, but I've found with Numbers charts there is no substitute for just experimenting. Studying the Charting Basics template (at File > New in your menu) is also helpful. And, when you can't figure out how to do what you need, Ian and other charting experts here often have the solution. Better than any static "manual."

    SG

  5. 0

    Craig Seeman

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Alas I do wish the application help were more useful. I vaguely remember a past where Apple may have even posted some basic How To video's.