Creating Smooth Curves in Excel Charts (Office 2000) 
Author Message
 Creating Smooth Curves in Excel Charts (Office 2000)

When plotting x/y charts the resulting curves appear jagged.  Is there any
"add-in" I can use to smooth these curves and then save the graphic to file?
I have tried the suggestions in the help file.  They help somewhat....but
still leave a lot to be desired.  The alternative is to use another program
like SigmaPlot that can create "smoothed" lines and read excel files.
However, this just adds yet another program to learn and costs a lot a money
for just one feature.

Any suggestions will be welcomed.  Thank you.



Sat, 12 Apr 2003 03:00:00 GMT  
 Creating Smooth Curves in Excel Charts (Office 2000)
[This followup was posted to microsoft.public.excel.charting and a copy

If you are plotting a function, then, in addition to trying the 'smooth
lines' option as suggested by Ed [Ferrero], check out the free XL add-in,
Plot Manager, that you can download from my web site.

--
Regards,

Tushar Mehta

www.tushar-mehta.com



Quote:
> When plotting x/y charts the resulting curves appear jagged.  Is there any
> "add-in" I can use to smooth these curves and then save the graphic to file?
> I have tried the suggestions in the help file.  They help somewhat....but
> still leave a lot to be desired.  The alternative is to use another program
> like SigmaPlot that can create "smoothed" lines and read excel files.
> However, this just adds yet another program to learn and costs a lot a money
> for just one feature.

> Any suggestions will be welcomed.  Thank you.



Sat, 12 Apr 2003 03:00:00 GMT  
 Creating Smooth Curves in Excel Charts (Office 2000)
You could try formatting the series line (double-click to get the format
dialog) and checking the 'Smoothed Line' option :^)

If you want something better than that, e-mail me and I will put a
Henderson filter macro on my web site.

Ed Ferrero
http://edferrero.m6.net



Sun, 13 Apr 2003 06:54:32 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. smooth curve algorithm in excel 97 or excel 2000

2. excel's smooth curve algorithm in charts, deciphered, maybe

3. Smooth curves in Charts and titles.

4. crosshair cursor that tracks excels smooth curve

5. Excel 2000 Charting from a Pivot Table w/o creating a Pivot Chart

6. Curve smoothing

7. New Drawing - smooth curve

8. How 2 get expression for smoothed curve?

9. smooth curves

10. smooth curves


 
Powered by phpBB® Forum Software © phpBB Group