Excel/MINITAB graphing - scaling the x axis

AI Thread Summary
The discussion focuses on creating a bar graph with a scaled x-axis in Excel 2007 or MINITAB, specifically for data collected at irregular intervals over 100m. The user seeks to avoid displaying each data point sequentially and prefers a representation that reflects the actual distances between points. Although a histogram was considered, it resulted in counts rather than the desired visual format. As a workaround, the user plans to create a scatterplot and manually overlay bars to achieve the intended effect. The conversation highlights challenges in graphing irregularly spaced data in standard software.
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
 
Back
Top