How to make semi log graph in excel mac

Next, you need to create column B.

Helpful answers

To do this, click on cell B2. You can extend this formula down the line by dragging the bottom right corner of the cell and dragging it down for as many cells as you need. In this case, drag it down to cell B6.


  • Your Answer!
  • salesforce outlook edition for mac?
  • exfat mac external hard drive!
  • mac os x mavericks createinstallmedia.

Now that the data is done, we can move on to actually graphing the data. To graph the data, first select the relevant data. For the first case, select columns B and C. Now click on the chart wizard.


  • best laser printer for mac lion.
  • disk not readable by this computer mac.
  • mac wonder woman reflects pearl.
  • Subscribe to RSS.
  • Subscribe to RSS.
  • All replies.

It will be somewhere in the menu bar, with a picture that resembles several vertical bar graphs. This will bring up the chart wizard. In this case select "XY Scatter " and then choose the first of the five options that appear.

ARCHIVED: In Microsoft Excel, how can I make a log-log graph?

Click on the "Next" button, and then click on the series tab at the top of the new window. Now click "Next" again. This is the options menu. Here you can add titles, legends or other labels to your chart. I have my scatter plot with x-axis log scale like below: I want the position of y-axis moved to the left. How can I do this? I'm doing this from memory since I don't have Excel at home.

Double click on graph Double click on x-axis On the Scale tab, have the y-axis cross the x-axis at 0. I usually just use an arbitrarily small crossing values 1e-9 as then the y axis will always stay at the left. Welcome to Super User. This duplicates LDC3's answer. Ali Shawabkeh Ali Shawabkeh 1. Can you post screenshot s? That seems counter-intuitive. Can you explain how that makes sense? Sign up or log in Sign up using Google. Select the chart, and choose Paste Special from the Edit menu, and add a new series, with categories in the first column and series names in the first row.

Question Info

The new series is shown by the blue squares and lines along the Y axis of our chart, below. Now add the data labels. The following is the manual process; at the end of this page I have a macro that adds and formats the labels for you, making use of the X and Y axis label text in column C above. Even if you plan to use the macro, it's useful to understand how the procedure works, so read on.

Double click on the new series, click on the Data Labels tab, and select the Value or Category option. It doesn't matter which, because we aren't using either.

Fitting logarithmic data

The default label position for an XY Scatter series is to the right of the points. Double click on a label, click on the Alignment tab, and choose the Left option for Label Position.

Then one by one, select each single label, and type in the desired label text. This is as good a place as any to hide not delete the helper series. The sequence below illustrates how we convert our labels to exponential notation. The chart is selected in pane A.

Create a linear trend line in Excel graphs with logarithmic scale - Super User

Pane B shows the data labels for the entire series selected after a single click on any of the labels. Pane C shows a single data label selected after a second single click on the label. Pane D shows text within the label selected using the mouse. Chart selected B.


  • Put Data In Mac, Get Graph Out Of Mac?
  • outlook for mac not syncing folders.
  • Excel 2010 or 2007.
  • konica minolta 1690mf printer driver mac.
  • mac os x set keyboard shortcuts;
  • download kodak esp c315 printer software for mac?

Labels selected C. Single label selected D. Text partly selected E. Partial superscript That's a pretty simple, if tedious, process to follow, and it results in the following chart, with exponential notation in the Y axis labels.

In addition to superscripting the exponents, I increased the font size by a point, compared to the labels in pane E above. Change the font size of the individual characters while they are selected, at the same time that you add the superscript format.