Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Smoothing Line Graphs - Excel 2000
I am working on an elevation comparison on a coastal region and trying to
display the differences on Excel. While I have easily displayed the two elevations in a line graph, it is not easy on the eyes. There is so much change in the data the lines are rough and compact. Is there any way, aside from expanding the size of the graph or eliminating data, to make the lines smoother or more presentable? http://img135.imageshack.us/img135/7...000lineua7.jpg Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Smoothing Line Graphs - Excel 2000
If you right click on your line, choose Format Data Series, you can select
the option to smooth lines. "A. Preine - Texas GLO Coastal Resources" wrote: I am working on an elevation comparison on a coastal region and trying to display the differences on Excel. While I have easily displayed the two elevations in a line graph, it is not easy on the eyes. There is so much change in the data the lines are rough and compact. Is there any way, aside from expanding the size of the graph or eliminating data, to make the lines smoother or more presentable? http://img135.imageshack.us/img135/7...000lineua7.jpg Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Smoothing Line Graphs - Excel 2000
Did you look at his chart? Using smoothed lines is a dubious approach to
charting in any case, but it will not help at all with the OP's data. Try using a moving average of the data. You could construct your own averages in the worksheet, or add a trendline (Chart menu) that consists of a moving average of a user-defined number of points. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Randy L" wrote in message ... If you right click on your line, choose Format Data Series, you can select the option to smooth lines. "A. Preine - Texas GLO Coastal Resources" wrote: I am working on an elevation comparison on a coastal region and trying to display the differences on Excel. While I have easily displayed the two elevations in a line graph, it is not easy on the eyes. There is so much change in the data the lines are rough and compact. Is there any way, aside from expanding the size of the graph or eliminating data, to make the lines smoother or more presentable? http://img135.imageshack.us/img135/7...000lineua7.jpg Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Smoothing Line Graphs - Excel 2000
Forgot to mention that doesn't do anything for me.
"Randy L" wrote: If you right click on your line, choose Format Data Series, you can select the option to smooth lines. "A. Preine - Texas GLO Coastal Resources" wrote: I am working on an elevation comparison on a coastal region and trying to display the differences on Excel. While I have easily displayed the two elevations in a line graph, it is not easy on the eyes. There is so much change in the data the lines are rough and compact. Is there any way, aside from expanding the size of the graph or eliminating data, to make the lines smoother or more presentable? http://img135.imageshack.us/img135/7...000lineua7.jpg Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
other systems detecting excel 4.0 if excel 2000 is installed | Setting up and Configuration of Excel | |||
Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |