Excel 2004 for Mac v11.5 Posts 8. Two Y axis both using same data series. How can i allign the primary and secondary axis, so they would both have the same y=0. I tried with max, min values, the gap, but nothing. Two Y axis both using same data series Hi. In a chart, click the data series that you want to plot on a secondary vertical axis, or do the following to select the data series from a list of chart elements: Click the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.

If you're familiar with Excel, I can simply ask: How do you create a secondary axis in a scatter plot? More descriptively, when one works in a scatter plot, you're comparing one set of numbers to another. Let's say you have two sets of numbers (to be put on the Y-axis) that you want to compare to another set of numbers (on the x-axis), but the two sets of numbers are of greatly different scale. You'd want to put on set of data on the primary axis (usually located on the left side of the chart), and put the other set of data on the secondary axis (usually located on the right side of the chart).

Can this be done in Numbers? Create the scatter plot with your x-values and first set of y-values. Select the second group of y-values in your table, and drag the selection to the chart.

Drag the same selection to the chart a second time, and some new data points will appear (don't worry if they're not in the right location at this point). Click on one of the data points from the second group. Now go to the Chart Inspector, choose the 'Series' tab and edit the X-Data entry to reflect the same x-values range as for your first series of data.

There's no automatic way to put a secondary axis on a Scatter Chart, but that shouldn't stop you. Add a Plain Table to your Sheet and adjust its size to one column, and with a number of rows equal to the number of horizontal grid lines you are using. Set the borders and fill of this new Table to None, type in your labels and position the Table to the right side of your Chart. Adjust the Font and Row Height, tweak the position of the Table. Create a new column for the data that you want to chart on your Secondary Axis and scale that data based on the ratio of the Secondary Axis to the Primary Axis.

Assuming that you are sharing X-values as Brie suggested, you can then drag your scaled data to the Chart. That's a neat way to get around this problem. I would recommend for the left-side Y axis that you enter the min and max in the Table Inspector and not leave them as 'auto'. You don't want them adjusting by themselves later in the future. This got me thinking.

You can color-coordinate the text on the two Y axes so they are the same color as their respective lines. That makes it instantly recognizable on screen and on a color printout which axis goes with which data.

With color coordination and a multi-column right side Y-axis table, you could add additional sets of Y axis labels for additional data series. Apple Footer • This site contains user submitted content, comments and opinions and is for informational purposes only.

Apple may provide or recommend responses as a possible solution based on the information provided; every potential issue may involve several factors not detailed in the conversations captured in an electronic forum and Apple can therefore provide no guarantee as to the efficacy of any proposed solutions on the community forums. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the.

Hi Sumaia, When you get the correct version when running the java -version it means your setting is correct. # Setting default JDK to version 1.8. Export JAVA_HOME=`/usr/libexec/java_home -v 1.8` To activate this configuration right away your can run source.bash_profile. This command reads and executes the.bash_profile in the current shell. Add the following lines at the end of the file. Java version 1.8 for mac.