Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2002 :How to reduce distortion upon pasting to Quattro Pro? | Excel Discussion (Misc queries) | |||
distortion while printing | Charts and Charting in Excel | |||
How to place excel charts into PowerPoint w/out distortion? | Charts and Charting in Excel | |||
How to choose a scale for the SECOND Y-Axis to avoid visual distortion | Charts and Charting in Excel | |||
Graphing | Excel Discussion (Misc queries) |