ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graphing distortion (https://www.excelbanter.com/excel-discussion-misc-queries/182934-graphing-distortion.html)

jase

Graphing distortion
 
I have a set of Y data points:
1.017
0.9961
0.9958
0.9959
0.9949
0.9955
0.9958
0.9957
When i graph the points it basically gives me a straight line with a tail
that shoots way up at the first point. I want to be able to really see the
difference in all my points rather then looking at basically a straight line
with a big tail. Is there a way I can logarithmically calculate my points or
some other way to get a better picture?

smartgal

Graphing distortion
 
You should be able to set the scale increments (to show in increments of 10
or 100 or whatever). Alternatively, you might try a couple of other
varieties of charts, I find that sometimes even onet that looks similar might
perform differently. But overall I think adjusting your scale should do the
trick.

"Jase" wrote:

I have a set of Y data points:
1.017
0.9961
0.9958
0.9959
0.9949
0.9955
0.9958
0.9957
When i graph the points it basically gives me a straight line with a tail
that shoots way up at the first point. I want to be able to really see the
difference in all my points rather then looking at basically a straight line
with a big tail. Is there a way I can logarithmically calculate my points or
some other way to get a better picture?


Jon Peltier

Graphing distortion
 
Make two charts. One goes from 0.99 to 1.02, the other from 0.994 to 0.997.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jase" wrote in message
...
I have a set of Y data points:
1.017
0.9961
0.9958
0.9959
0.9949
0.9955
0.9958
0.9957
When i graph the points it basically gives me a straight line with a tail
that shoots way up at the first point. I want to be able to really see the
difference in all my points rather then looking at basically a straight
line
with a big tail. Is there a way I can logarithmically calculate my points
or
some other way to get a better picture?





All times are GMT +1. The time now is 10:05 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com