how to show significant digits on an excel graph axis label

We indicate which variable is which by saying as a function of or “versus”, with the dependent variable coming first, and the independent variable coming second. It was initially divided into about 6 columns in excel that performed the various steps and at the end I merged all of the steps into one formula above.When we prepare a graph the independent variable is always on the “ x-axis”, and the dependent variable is always on the “y-axis”. To Treat Negative Numbers, I have included a concatenation with a negative sign if less than 0 and use the absolute value for all other work. I've also tested with a few values that gave me issues early on and all seem to produce the correct results now. I've also tested with a few values that gave me issues early on and all seem to produce the correct results. I've tested it against the wikipedia list of examples and my own examples so far in positive and negative. Note: I have a named range called 'sigfigs' and my numbers start in cell A1 I was interested in the accepted answer and it got close but as soon as my numbers were 0,sigfigs-1-(FLOOR(LOG10(TEXT(ABS(A1),'0.'&REPT('0',sigfigs-1)&'E+00')),1)),0))))) I went to this question/answer and many other sites but all the answers don't seem to deal with all numbers all the time. I was also looking to work with significant figures and I was unable to use VBA as the spreadsheets can't support them. You may use cell E2 for visualization purposes, and the number obtained in C2 for other math, if needed. Where cell C2 still has the formula above. (this replicates the VBA code) and then use (in, say, E2) =TEXT(C2,D2). 'fmtstr = WorksheetFunction.Rept('0', nint) & fmtstrfrac 'fmtstrfrac = '.' & WorksheetFunction.Rept('0', nfrac) Sub fmt(val As Range, sigd As Range, trg As Range)ĭim fmtstr As String, fmtstrfrac As String

You have to pass three parameters (val,sigd,trg), trg is the target cell to format, where you already have the number you want.

You have then to apply a number format specific for that combination (value,sigfigs), and that is via VBA. But if the last digit is zero, then it will not be shown with a General format. May give you the number you want, say, in C2.

How to show significant digits on an excel graph axis label