Axis labels in "Numbers"

Discussion in 'New Member Introductions - Site Assistance' started by eatlynnow, Nov 22, 2012.

  1. eatlynnow

    eatlynnow iPF Noob

    Joined:
    Nov 22, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I am creating a time column spreadsheet in Numbers. The data is in the secnd column. What should appear as the "X" axis values are in the first column. When I create the chart I find no way to have Number recognize the first column as the "X" values.

    When I go to the tutorial included with Numbers you can select the data and the "X" values are automatically included. What gives?
     
  2. AQ_OC

    AQ_OC Super Moderator Staff Member

    Joined:
    Apr 28, 2011
    Messages:
    6,411
    Thanks Received:
    431
    Trophy Points:
    83
    Location:
    SC
    Ratings:
    +431 / 0
    Chart type?
     
  3. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,454
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,992 / 1
    Labels are automatically created from the header columns. There is no way to assign other columns or rows.

    To make the first column a header:

    Select the table by tapping on it somewhere.
    Tap the Paint Brush icon.
    Tap the Headers tab.
    Change the Header Column to 1

    Freeze Column will make sure that the header column will stay visible as long as the table is visible (when scrolling)
     
  4. leelai

    leelai Administrator Staff Member

    Joined:
    Apr 24, 2011
    Messages:
    24,834
    Thanks Received:
    1,291
    Trophy Points:
    113
    Location:
    Brisbane, Australia
    Ratings:
    +1,370 / 0
    Hi and welcome to the Forum!

    The IPad Forum is a community of members from all walks of life and from all over the world coming together to share our experiences and to help each other learn about this wonderful piece of technology the Ipad. There is a wealth of information already here in the many threads we have so doing some searches will answer most of the questions you have. If then you cannot find the answer you are seeking then by all means post your question. There are many friendly and informed members here only too willing to help you.

    We also have our own App - It is a very simple app to navigate.
    http://itunes.apple.com/us/app/discussion-forum-for-ipad/id412896524?mt=8
    Tutorial on creating posts on the Forum
    http://www.ipadforums.net/new-membe...-creating-posts-starting-new-threads-how.html
    Reading the IPad manual is a great place to start so please download a copy of these.
    http://www.support.apple.com/manuals/ipad/
    3 very informative threads from which you will learn many tips and shortcuts for the IPad.
    http://www.ipadforums.net/ipad-general-discussions/21590-tips-tricks-those-us-who-dont-know.html
    http://www.ipadforums.net/ipad-os/49581-ios5-tips-tricks.html
    http://www.ipadforums.net/ipad-help...shortcuts-helpful-places-people-new-ipad.html
    We have rules like any Community so please read these also
    http://www.ipadforums.net/forum-rul...um-rules-everybody-please-read.html#post14697

    Once again we welcome you here and are so pleased you have joined us!
     
  5. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    51
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    I have the same question and I can't understand your answer.

    I have a simple two column chart. In the first column are the 12 months of the year. Second column contains data corresponding to each month. When I call up a 2 axis line chart, the data plots properly but how do I make the first column (months) appear across the bottom as x-axis labels, as they have done in the sample charts.

    Larry Cruzen
     
  6. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    51
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    X axis labels

    I have the same question. Can't understand that you reply you got. Did you ever figure out how to make the first column become X axis labels as they do in the examples?

    Larry Cruzen
     
  7. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,454
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,992 / 1
    To set a column as labels it must be the left most column and you must have that column set as a Header column.

    1. To change the left column to a header column tap something in the table, then select the paint brush icon, then the Header tab. Make sure the Header Column is set to 1. This will usually change the column into a darker background color.

    2. Now go back to the table and select the column you want to supply the data points. Do this by tapping the bar above the the table. the entire column will be highlighted and a menu will appear. Choose Create Chart from the menu. Pick the chart type you want.

    The left column will now become the labels along the x-axis (the bottom of the chart).

    Lables.png

    To adjust how the labels are displayed tap the chart to select it, tap paint brush icon, the X-Axis tab, and then the Label Angle.


    If you still can't make it work, or this isn't what you were asking for please discribe what you want to accomplish in more detail and I will do my best to explain; assuming it is possible.

    Good luck.


    Don't forget the ? icon. If you tap it then "Learn more about Numbers" at the lower left of the screen it opens a fairly decent online manual. You can find the same information and a bit more here: http://www.apple.com/support/ios/
     
    Last edited: Apr 3, 2014
    • Like Like x 2
  8. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    51
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    Really appreciate your detailed response. My problem was that I didn't have the X axis labels in the first column. Got it down pat now. Now if I could just move the legend away from the chart title........

    Larry Cruzen
     
  9. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,454
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,992 / 1
    It's tricky, but it can be done.

    When you tap on the chart to select it you'll notice that the legend has a box around it. You can drag this box just about anywhere you like. Tap and hold the legend for about a second and the selection outline of the chart disappears. Not letting up on the legend, drag it where you want.

    The two green dots (left and right) let you resize the legend so that items stack up instead of being all horizontal (if you have more than one data set selected). At it's smallest you end up with a vertical list.


    The Title can't be moved. If I don't like the Title placement what I'll do is turn it off in the Chart Options then create my own title using the Text shape, or if i want a bit of color use one of the other shapes and place text inside it.

    Good luck.
     
  10. larrycruzen

    larrycruzen iPF Novice

    Joined:
    Sep 17, 2012
    Messages:
    51
    Thanks Received:
    3
    Trophy Points:
    8
    Location:
    Watts Bar Lake, Ten Mile, Tennessee
    Ratings:
    +4 / 0
    Aha! Worked like a charm. Methinks you are a genius.

    Seriously, I really appreciate your contribution to this forum.

    Larry Cruzen
     
  11. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,454
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,992 / 1
    No problem. Glad to help.
     

Share This Page

Search tags for this page

apple numbers make column an axis ipad

,

ipad numbers axis labels