Hot answers tagged

12

Was having the same problem – apparently the options to swap axes moved to the bottom left when Editing Data References: Answer found here.


10

If you want a line graph with 2 y-axes. You to insert->Chart-> 2-Axis. Put in your data. One of the sets will be a line the others a bar. The way to fix that is: Select the one that is a bar then to go to the Inspector-> Chart-> Series. It will say series type-> select that and change it from bar to line. Right below that it says plot on: There you can ...


5

Yes, indeed it can: Square wave: try something like y = (-1)^round(x)(but with proper formatting). Something like y = (round(x+0.5) - round(x)) - 0.5 would also work. Sawtooth wave: try something like y = x mod 1 or, more elaborately, y = 2((x-0.5) mod 1) - 1. However, something like y = x - round(x) would also work. If you don't like any of these, try ...


4

Sort your data ascending based on the values in column A - the x-axis.


4

Have a look at: Ondesoft Screen Rulers for Mac Easy, powerful and accurate virtual screen rulers for your Mac Ondesoft Screen Rulers is a highly configurable measuring utility for Mac with many intuitive features, enable you to measure objects quickly and precisely on your Mac screen in Pixels, Inches, Picas, Centimeters and multiple ...


3

Yes Numbers does now supports two axes. Steps are: Select the chart, change the type to 2D 2-Axis Make sure you have more than one data series selected. The Series tab for each data series will allow you select which axis to use for each series and the type: columns, lines or areas. The chart Axis tab contains (Y1) and (Y2) tabs which you can customise. If ...


3

iconfactory's xScope Powerful on-screen rulers for precise pixel measurements that include scaling, rotation, and edge snapping. xScope’s rulers can be used to measure any on-screen element, including the distance and angles between objects. Holding down the Control key while dragging the ruler near an on-screen object causes the edges and ends of ...


2

OpenOffice and derivatives like LibreOffice and NeoOffice can connect to a MySQL DB using ODBC; and, once the connection is established, the spreadsheet component can use it as a data source.


2

Unfortunately this is a regression with the current version of Pages at the time of writing. It's not possible to move the equations in Pages 7.0. Documents created with previous versions of Pages will preserve the equation position. If you still have the previous version of Pages, you can copy-paste the graph into the older version, move the equations and ...


2

I've used Free Ruler for Mac OS X in the past. I'm amazed that still works just fine. However, it does not allow click-through.


1

The trendlines are based on the data and can't be forced thru any points. What you could do is have the app print out the equation for the trendline and plugin 0 to see what new trendline looks like. You can then adjust the coefficients so that you have a new trendline thru 0.0. This may not be a good representation for the trendline. Another possibility ...


1

To get the spreadsheet to start at 0 instead of year-0 you can do one of 2 things. Change the label "Year-0" to just "0" or add another pair of points as the very first entry. Make the x-value whatever it should be and set the label name as "0" and the y value forthis new point is whatever it is.


1

Hopefully someone knows how to source data from multiple table inputs, but I just use brute force and make one table that contains all data I need to chart. Tables can refer to data from multiple other tables, so now with your charting data in one table, charting becomes a snap.


1

It doesn't look logarithmic to me. Rounding the Steps figures, 20k peak, average 10k - the 10k line is half way up the scale, give or take. If it were logarithmic it would be significantly off-centre. I think it shows some non-colour-differentiated headroom above the high-point, which might be giving the impression it's not linear. On my own phone, my ...


1

Have a look at the following Software for visualizing X,Y,Z Data as a 3D Scatter and 3D Surface graph: IGOR Pro QtiPlot R Graphing Calculator These are for the most part scientific tools, so don't expect any friendly UI. There are some other tools for *nix and Windows, but the you have to use Wine, Crossover or some VM to use it. There is also '...


1

Have you tried the built-in Grapher app in /Application/Utilities ?


1

Some time ago I wrote small app called Lagometer which shows ping to selected host (you can set it in preferences) as a graph in menubar. It works only with one host, but should work for you.


1

Nagios does install with ports on MacOS X. Have a look at these performance graphs. I must quote here the final message of Nagions installer: But Nagios is a complex program so you should read the documentation online at http://www.nagios.org or locally at /opt/share/nagios/docs/index.html to fully understand Nagios.


1

I know this is an old topic and also I'm aware of how sensitive recommending one's own application can be (especially in case of a commercial application), however I think this does answer the OP's question exactly. If this is not allowed (I tried looking for a policy in the FAQ), please let me know and I will take this down. I've been looking for such ...


1

You can build your own transpose function using the index command: The transpose cells all contain this:


Only top voted, non community-wiki answers of a minimum length are eligible