Making chart where for example distance has not equal footstep
Need to make cross section chart where for example distance has not equal footstep. On the picture the distance has its valuas but they are random. Like i have distance valuas in meters 1 2 10 30 31 35. On my graph 1-2 are same as 10 and 30. but they should not to be.
pilt1.jpg
Thaks who can make it right
You need to have all the values, 0 to 2232, and use formulas to either return the value of interest or N/A:
Capture.JPG
Bernie Deitrick
Excel MVP 2000-2010
What chart type are you using? It looks like you are using a line chart. If I understand what you are asking, I think you want an XY scatter chart.
Originally Posted by shg
Got it. Yes .. there was the problem. Thank you
Last edited by lengard; 03-14-2016 at 03:14 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks