Help creating chart in Numbers (iWork '09)

Discussion in 'Mac Apps and Mac App Store' started by Oblivious, Oct 18, 2009.

  1. Oblivious macrumors 6502

    Joined:
    Jan 19, 2006
    Location:
    MA
    #1
    For the past several hours I've been struggling to use Numbers to create a few some charts from a table of data for an electronics lab. I managed to work out the first few after a bunch of time fiddling with the chart options (which there are not enough of... or are too hidden. Why can't there be one window with a big ****ing list of every single customizable chart option?). The problem I've run into now is in creating one line chart out of three different columns of data. I have two different sets of data where I found the gain across an RC circuit at range of frequencies. I want the column of data with the range of frequencies on the x-axis on a logarithmic scale and gain on the y-axis with two connected series of data. And I can't for the life of me figure out how to customize what series of data appears on what axis.

    Anyone know how to do this or should I just delete this potentially piece of **** program from my computer?

    [​IMG]

    tl;dr- All I want to do is basically combine those two graphs using the data that I've highlighted on the table.
     
  2. Oblivious thread starter macrumors 6502

    Joined:
    Jan 19, 2006
    Location:
    MA
  3. mysterytramp macrumors 65816

    mysterytramp

    Joined:
    Jul 17, 2008
    Location:
    Maryland
    #3
    Try this, the B column values you want to chart.

    Now hold down the command key, and select the I & J column values.

    Now hit chart.

    You should get a single chart with the two sets of values.

    mt
     
  4. dbwie macrumors 6502

    Joined:
    Jun 11, 2007
    Location:
    Albuquerque, NM, USA
    #4
    When these charting programs don't give you exactly what you want, one option is to use OmniGraphSketcher to draw out exactly the graph you want. I use this at times to create a quick chart for a presentations, but not for preparing figures for journals. It can make a quick graph based on data imported from a spreadsheet.

    Just curious, what was the solution to your issue?
     

Share This Page