Help creating chart in Numbers (iWork '09)

[Oblivious]

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?

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

 

[Oblivious]

Nevermind, figured it out myself... finally.

 

[mysterytramp]

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

 

[dbwie]

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?