![]() |
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? |
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? |
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