Excel/MINITAB graphing - scaling the x axis

Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 3K views
sunfleck
Messages
6
Reaction score
0
I'm trying to make a bar graph from data which were taken at irregular intervals over 100m. I want the x-axis to be scaled instead of showing each data point one after another. (i.e. I'm coming out with 1-4-5 when I want 1-----4-5). I hope this makes sense - I'm not sure of the proper terminology :/
I've been trying to do this on excel 2007, but I also have access to minitab (newer version - don't know which one exactly since I'm not at school).
 
Last edited:
Physics news on Phys.org
You could change it to a histogram and adjust your values accordingly. It should have a scaled axis in that case.
 
Thanks for replying :) I tried a histogram but then it just gave me counts... but since we can draw things by hand I've decided to make a scatterplot and just draw bars overtop since I can't seem to get the whole thing to work out