I need to get a zoomed picture of a specific part of the graph so my question is How to change x-axis min/max of Column chart in Numbers to specify what part you need ?
MacBook Pro, Mac OS X (10.7.1)
Oops,
For a Scatter Plot, put your X and Y data in Header Columns (or Header Rows).
I should have said: For a Scatter Plot, **don't** put your X and Y data in Header columns (or Header Rows). Put the data in Body Cells.
Regards,
Ian.
this doesn't work for the x-Axis ! Look for the previous post i posted for more explanation with screen shots !
Hi Chris,
Is this what you are looking for?
Click chart and look in Format pane on right.
SG
YellowBox 🙂
so what I want to do is (I already controlled the range of the Y axis.) that i want to restrict the graph to a specific part for example I want to see from 3 to 4 hours, How do I do that ?
when I press on Value(Y) the scale control the Y axis range.
Also the steps are the ones parallel to the X-axis and there is none for the other orientation.
and can't access the minor steps !
when I press on the Category(X) this is what appears
this doesn't work for the x-Axis ! Look for the previous post i posted for more explanation with screen shots !
Changing the scale on both x and y axis seems to be working here, and also for Ian.
One thought. If you're trying to change the scale on the x-axis, then shouldn't you be creating an x-y Scatter chart? It probably doesn't make much sense to try to change the scale on a category (Line and Column charts are category charts). To get an x-y Scatter chart you need to make sure you are not trying to plot a column that is defined as a Header Column.... and of course choose the Scatter chart type instead of Column or Line:
If you need a Column or Line chart instead of an x-y Scatter, and you want to exclude some data as being "out of range", then I think you could simply exclude it when you select the cells in the table before creating the chart.
SG
Hi Chris,
That is a Category graph (2-D Line).
A Scatter Plot will allow you to change the Scale and Steps on the X axis.
Click on the Chart (Graph) and Format Panel > Axis
To get a Connection Line or a Trendline on the Scatter Plot, Format Panel > Series
For a Scatter Plot, put your X and Y data in Header Columns (or Header Rows).
Regards,
Ian.
P.S. I see that SG has found the solution 🙂. Ian.
Hi Chris,
What type of graph are you creating? In a Category Chart (everything except a Scatter Plot) the X values are fixed categories.
Perhaps you want a Scatter Plot? If so, X and Y must be in Body Columns or Body Rows (X and Y are both variables).
Please reply with a screen shot of a small part of your screen (command shift 4 and drag). Full screen shots (command shift 3) are often difficult to read.
Wayne Contello has written a User Tip on how to post a screen shot.
https://discussions.apple.com/docs/DOC-6591
Regards,
Ian.
SGIII,
this will change the Y-axis and I need to change the X-axis !
this will change the Y-axis and I need to change the X-axis !
Here, I just click Axis, Value (Y), and then change the scale:
SG
You can change the labels under the X-axis tab.
David,
I know I can change the labels but I want to change the scale not the label ! From What I can find is that we can change the scale of Y axis but not X !
Thank you !!!
Thank you !
How to change x-axis min/max of Column chart in Numbers?
