1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

Numbers (iPad/iPhone) Graph Axis Formatting

Discussion in 'iWork Forum' started by kkovak, Jan 10, 2012.

  1. kkovak
    Offline

    kkovak iPF Noob

    Joined:
    Oct 23, 2011
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I need to display the x axis of a graph as a date format, e.g.: 1/9/2012. I have set the x axis "number format" to the "same as source". The column where the x axis data is formatted as a date format and displays as 1/9/2012. However the graph shows the x axis values as large numbers, e.g.: 340000000.

    Can anyone help me turn it to the required date format?

    Thanks
    Ken
  2. twerppoet
    Offline

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    15,935
    Thanks Received:
    1,807
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +1,914 / 1
    I can't guess at what is going on without more info. I'm just not familiar enough with the chart settings to do it by remote guess.


    If there is no personal or privileged information in the spreadsheet, I'd be happy to look at it. You'll need at least one more post before you can offer a link or attachment.
  3. Pauljoanss
    Offline

    Pauljoanss iPF Noob

    Joined:
    Oct 15, 2012
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    I have same problem, big numbers instead of dates.
    Also want to add several lines to this simple scatter chart but seem to be limited to one series.
  4. hpulmer
    Offline

    hpulmer iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    730
    Thanks Received:
    31
    Trophy Points:
    28
    Location:
    Germany
    Ratings:
    +31 / 0
    Just checked it out, and works perfectly for me...



    image-2023955876.jpg

    (Unfortunately in German...)

    Are you sure you have the date formatted correctly??

    ☠ stay safe ☠ stay legal ☠
  5. Pauljoanss
    Offline

    Pauljoanss iPF Noob

    Joined:
    Oct 15, 2012
    Messages:
    2
    Thanks Received:
    0
    Trophy Points:
    0
    Ratings:
    +0 / 0
    Thanks for pic.
    Thought your point about formatting had given me the answer. Although data was formatted to date, I had the header title in first cell of the column. Moved the column title into the top shaded bit and formatted the whole column to date, now cannot get anything to show on bottom axis.
    Looking at help stuff, they show some toolbars at the very top, including an "insert chart" button, but cannot find how to show this and now see in your example that you do not have these toolbars either.
    My data consists of a column of dates and one of blood pressure, the dates are not concurrent so from my excel experience this requires a scatter chart, otherwise dates are treated simply as labels and not values. Would be useful if you could send me a copy of a working chart, but forum will not let me post my address until I have 3 posts, so maybe next time.
    I have used Excel for many years and after a lot of hard work have come to understand lots of stuff about the wide range of charts, so feeling very frustrated that I have to start all over again and without and USEFUL help or manual.
  6. hpulmer
    Offline

    hpulmer iPad Junkie

    Joined:
    Aug 30, 2011
    Messages:
    730
    Thanks Received:
    31
    Trophy Points:
    28
    Location:
    Germany
    Ratings:
    +31 / 0
    No need for a scatter chart. Just make sure you choose the correct table where you are going to insert the data - see pic:


    image-1656774285.jpg

    Select the data and the menu will pop up


    image-4231510844.jpg

    Hope this helps,

    ☠ stay safe ☠ stay legal ☠

Share This Page

Search tags for this page
create a 2 axis chart in ipad numbers
,
define x axis data number ipad
,
edit graphs in numbers ipad
,
editing chart value axis in numbers on ipad
,

graphing dates in numbers

,

how do i graph dates in numbers

,

how do i set the axis values on ipad numbers

,
how to chart in numbers on ipad
,
how to create a scatter chart on numbers ipad
,
how to edit graphs in pages ipad
,
how to make x and y axis on number ipad
,
imac numbers how to add x-axis data
,
ipad charts trendline
,

ipad numbers chart date axis

,
ipad numbers chart x axis scale
,
iworks numbers chart shows integers not dates
,
iworks numbers date format on horizontal axis
,
label axis in numbers ipad
,

numbers for ipad trendline

,
trendline how using ipad numbers