Need help with Numbers

Discussion in 'iWork Forum' started by sunny day, Jul 5, 2011.

  1. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    I imported an Excel spreadsheet that included charts. I was able the to change the data range in ons chart. When I started in the next I got some unwanted data accidentally selected. I have looked at the help section and done what it said but never did get a choice of any kind. According to help, delete is supposed to appear so the data can be deleted. I have been using it for about 2 months. I see that it was updated May 31. Since I did not have to delete a data range before the update, I have no idea if this could be the problem.

    Someone mentioned exporting a Numbers file to be edited in Excel. How do you do that? I don't dee anything, so far in the help section that addresses that
     
  2. Tim SPRACKLEN

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,236
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 1
    At the bottom of a Numbers spreadsheet there's a curly arrow that allows you to email the spreadsheet in .xls format. You could then edit it on your PC. If you're a MobileMe subscriber, you'll also see the option to save the spreadsheet to the MobileMe cloud storage iDisk.

    Tim
     
  3. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Thanks. That may be the fastest way for me to edit my mistakes.
     
  4. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Just checked and there is no curly arrow. Had to select the wrench at the upper right, then share and print, then email. Then given choice of what format.
     
  5. Tim SPRACKLEN

    Tim SPRACKLEN iPad Legend

    Joined:
    Jan 3, 2011
    Messages:
    15,236
    Thanks Received:
    121
    Trophy Points:
    0
    Location:
    Scotland
    Ratings:
    +121 / 1
    I should have been clearer. Not when you're actually in the spreadsheet, but when you're in the My Document view. Bring the spreadsheet so that it's the highlighted one, but don't open it. Then you'll see the curly arrow at the bottom of the spreadsheet. Sorry I wasn't clearer...:(

    Tim
     
  6. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,455
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,993 / 1
    @Tim, That's right, you're still running the older version. Come on, be brave and upgrade. :D

    @Sunny Day, Export is now done with the document open. Tap on the wrench icon and choose the Share and Print option. Tap to email, and you will get a choice of export formats, one of which will be Excel.
     
  7. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,455
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,993 / 1
    Also, now that I've really read your original post:

    To delete unwanted data ranges;

    Double tap on the chart. All data ranges should be highlighted in the table. Tap the bar above the column (or to the left of the rows) containing the data. It might take a couple tries to hit the right spot. Aim for the dot. You will get a Delete Series option in a popup menu.
     
  8. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    That's my problem, the delete series choice does not come up. I double tap the chart and all the data series show up with blue boxes around them with a blue dot at the lower right. I have tapped this dot, held the dot, sent nasty thoughts at the dot, and I can't get the delete choice to come up. Frustration. I have to be doing something wrong, or not doing something right, but I have no idea what it is.
     
  9. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,455
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,993 / 1
    Wrong dot. I meant the dot at the top of the series, the one that shows what color the data in the chart is. Tap on the bar above the series, or to it's left if you are doing rows. The dot is just a convenient target to help make sure you tap in that bar.

    See attachment.
     

    Attached Files:

  10. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    Ok, I see what you mean. I found it, but still have a problem. This spreadsheet is long, I am working about the 220th row. After I double tap I the chart and scroll to the top, touch the dot, and as soon as I touch anywhere on the screen the delete series disappears. Any ideas?
     
  11. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,455
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,993 / 1
    Perhaps I'm misunderstanding. If you are seeing the Delete Series popup, why are you not just tapping it to delete that series? It will only delete the series that you tapped.
     
  12. sunny day

    sunny day iPF Novice

    Joined:
    Jun 13, 2011
    Messages:
    49
    Thanks Received:
    2
    Trophy Points:
    0
    Ratings:
    +2 / 0
    The light bulb finally comes on. I have succeeded in deleting several and working on the rest. Thanks for being patient.
     
  13. twerppoet

    twerppoet iPad Legend

    Joined:
    Jan 8, 2011
    Messages:
    17,233
    Thanks Received:
    2,455
    Trophy Points:
    113
    Location:
    Walla Walla, WA
    Ratings:
    +2,993 / 1
    No problem. Glad you're back in business.
     

Share This Page

Search tags for this page
apple numbers how to change range in graph
,
apple numbers spreadsheet blue highlighted line32
,
change graf colors in numbers for ipd
,
delete a line in numbers app
,
how do i delete a chart data set in iwork's numbers
,
how to change chart colors in numbers ipad
,
ipad how to change chart colors
,

ipad numbers chart colors

,
ipad numbers help
,
numbers graph change color ipad