Excel/MINITAB graphing - scaling the x axis

Click For Summary
SUMMARY

The discussion focuses on creating a bar graph with a scaled x-axis in Excel 2007 and Minitab. The user seeks to represent data collected at irregular intervals over 100m, aiming for a visual representation that accurately reflects the spacing of data points. While attempting to use a histogram in Excel, the user encountered issues with count representation, leading to the decision to create a scatterplot and manually overlay bars. This approach highlights the limitations of Excel 2007 for this specific graphing requirement.

PREREQUISITES
  • Familiarity with Excel 2007 graphing features
  • Understanding of Minitab graphing capabilities
  • Knowledge of scatterplot and histogram concepts
  • Basic skills in data visualization techniques
NEXT STEPS
  • Explore advanced graphing options in Excel 2016 or later
  • Learn how to create and customize scatterplots in Minitab
  • Research techniques for scaling axes in data visualization
  • Investigate alternative software for complex data representation, such as R or Python's Matplotlib
USEFUL FOR

This discussion is beneficial for data analysts, statisticians, and anyone involved in data visualization who seeks to effectively represent irregularly spaced data points in Excel or Minitab.

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
 

Similar threads

Graphing f(x)=√x but shifted 2 units to the left and then reflected
  • · Replies 12 ·
Replies
12
Views
8K
Which software to use to create this graph?
  • · Replies 3 ·
Replies
3
Views
3K
Logarithmic Regression Question (TI-84 Plus Graphing Calculator)
  • · Replies 4 ·
Replies
4
Views
2K
Where Do the Graphs of |3x-2| and 1/x Intersect and Diverge?
  • · Replies 4 ·
Replies
4
Views
3K
Graphing sinusoidal tangent functions
  • · Replies 17 ·
Replies
17
Views
3K
Graphical Transformations and Finding the Equation of a Curve
  • · Replies 3 ·
Replies
3
Views
2K
How to format x axis to a smaller scale in Gnuplot?
  • · Replies 2 ·
Replies
2
Views
3K
How to graph by hand: y=log((x/(x+2))
  • · Replies 3 ·
Replies
3
Views
2K
Suitable range of values for x
  • · Replies 10 ·
Replies
10
Views
2K
How Do You Form and Expand a Cubic Equation from Given Intersections?
  • · Replies 30 ·
2
Replies
30
Views
3K