Just leave the volume as is, then use cell A6 (or A19 for chart...

  1. 19,112 Posts.
    lightbulb Created with Sketch. 3682
    Just leave the volume as is, then use cell A6 (or A19 for chart 3) to adjust the volume numbers on the chart.
    I think it is cell A6....the one with 100 in it anyway
    So change the value in cell A6 from 100 to .1, 1, 10, 1000, 10000, 100000 etc. or whatever you need and then click enter (the different numbers depends on if you need them larger or smaller) so that the numbers on the chart are are two or three digits (that size is easier to read I reckon, but whatever you want), the volume numbers are relative, so it doesn't really matter

    Yes, you will need to get used to excel, and more practice will help for sure.

    If you need to invert the numbers I can help, stand by.....

    cheers
    Last edited by Jako8557: 14/04/19
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.