Ok, I have a list of data that goes beyond what I want to graph; but I need the list as long as it is incase I make a change. I understand that will be confusing to all so, the list is engine related, intake valve lift to be specific (x). The data associated to it is velocity. If my cam only has .32" of lift and the list for lift goes to .6" (and back to 0" from there) and I want to graph velocity (y) ... I end up with a dead spot the size of the missing lift (x) and then velocity (y) graphs again.
How can I make it so either a range of data is mirrored and able to graph in a continuous line and the x axis labels correct per associated lift, .30, .31, .32, .31, .30, etc?
I can work everything I need manually but it takes too long, and if I select a different cam with more lift it's even more work/typing. The graph should look close to a U in shape with no breaks in the line.
Maybe there's a way to graph ranges of blocks of cells?
I tried using a semicolon but that didn't work, would be perfect if it did .
Because visual aids will help,
This is what I have graphed:
\1
Notice that the X ranges up to 1.20. This is because it was the only way I was able to manually get the lines in the correct orientation, I'm unsure how to use a mirror function.
Written another way,
I want to take a point on the X axis and mirror the data/graph up to that point from this graph/data:
\1
So it would look like the first picture minus the gap in the line.
Hopefully someone can make sense of my rambling/problem?
Bookmarks