Axes in Charts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.
 
I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.
Click to expand...

Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4
 
margie said:
I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.
Click to expand...

Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4
Click to expand...

Sorry, too quick on the draw; I see you want formatting. Have you tried
Jon Peltier's site?

http://peltiertech.com/Excel/NumberFormats.html
 
Thanks! I'll try tha now!


Del Cotter said:
margie said:
I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.
Click to expand...

Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4
Click to expand...

Sorry, too quick on the draw; I see you want formatting. Have you tried
Jon Peltier's site?

http://peltiertech.com/Excel/NumberFormats.html
Click to expand...
 
Amazing site - it helped me perfectly after I struggled and was frustrated
for days!!! Thank you!


Del Cotter said:
margie said:
I need to format my charts to reflect 4 significant figures (not decimal
places) on both the x and the y axes. For example, I need to show 0.000,
5.000, but then continue on to 10.00, 15.00. A total of 4 digits (not
decimals must show). I am stumped.
Click to expand...

Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4
Click to expand...

Sorry, too quick on the draw; I see you want formatting. Have you tried
Jon Peltier's site?

http://peltiertech.com/Excel/NumberFormats.html
Click to expand...
 
Amazing site - it helped me perfectly after I struggled and was frustrated
for days!!! Thank you!
Click to expand...

Yes, and I also see there's a much more elegant alternative to my
rounding formula:

A1: [the number]
A2: [significant figures]
A3: =ROUND(A1,(A2-1)-INT(LOG(A1)))
Del Cotter said:
Use this formula:

A1: [the number]
A2: [significant figures]
A3: =10^(A3-INT(LOG(A2)+0.5)-1)
A4: =INT(A2*A4+0.5)/A4
Click to expand...
Click to expand...
Click to expand...
 
Back
Top