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.

On Sat, 3 Mar 2007, in microsoft.public.excel.charting,
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.

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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

On Sat, 3 Mar 2007, in microsoft.public.excel.charting,
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.

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

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

http://peltiertech.com/Excel/NumberFormats.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Thanks! I'll try tha now!


"Del Cotter" wrote:

On Sat, 3 Mar 2007, in microsoft.public.excel.charting,
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.

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

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

http://peltiertech.com/Excel/NumberFormats.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Amazing site - it helped me perfectly after I struggled and was frustrated
for days!!! Thank you!


"Del Cotter" wrote:

On Sat, 3 Mar 2007, in microsoft.public.excel.charting,
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.

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

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

http://peltiertech.com/Excel/NumberFormats.html

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

On Sun, 4 Mar 2007, in microsoft.public.excel.charting,
margie said:

Del Cotter said:
Have you tried Jon Peltier's site?

http://peltiertech.com/Excel/NumberFormats.html

Amazing site - it helped me perfectly after I struggled and was frustrated
for days!!! Thank you!

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

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.