How to keep XY scatter curve legends along with stacked column legends?Īndy, hope you will guide me to learn the tricks.Thanks and regards. As pointed out by Shameer in this answer, Alt+Enter now seems to work as well in the new Excel for Mac 2015. These combinations work both in Excel for Mac 2011 and the new Excel for Mac 2015.
#Add secondary axis excel for mac 2011 series
Right Click on it and go to Format Data Series Series Option Activate Secondary Axis. As an alternative, Control+Command+Enter can also be used to achieve the same. Select the data series for which you want to add a secondary axis.
When I change series chart type from stack to xy scatter, the legend GR disappers. The answer is to use Control+Option+Enter, which will create a line break in the cell. Also, we can use the short key first of all, we need to select all data and then press the short key (Alt+F1) to create a chart in the same sheet or Press the only F11 to create the chart in a separate new sheet. It should take secondary horizontal category axis with values of 0.5 at right end and 1 at mid-point of the stacked column.Īfter creating the stacked column, I move on creating the xy scatter curves. Insert tab on the ribbon > Section Charts > click on More Column Chart> Insert a Clustered Column Chart. Click the + button on the right side of the chart, click the arrow next to Axis Titles and then click the check box next to Primary Vertical. Then from layout>Axes> Secondary Horizontal Axis>default Axis, what I get is secondary horizontal value axis. To add a vertical axis title, execute the following steps. From Format I change the axis to secondary. In this case, these were the scaled values, which wouldn’t have been accurate labels for the axis (they would have corresponded directly to the secondary axis). By default, Excel adds the y-values of the data series. Therefore, extreme right of plot should be 0.5 and require to increse towards left. Axis labels were created by right-clicking on the series and selecting Add Data Labels. The second curve-phi (in red color) increases from right to left and is required to be placed at right side of the column. It is done using the primary horizontal category axis created for the stacked column. GR (in blue color) increases from left to right. There are two curves-GR and phi-to be placed at left and right side of the stacked column respectively.
You have seen it before and solved wherever I got stuck.ġ. Problem is that it is creating horizontal value axis where as I need category x axis.
0 kommentar(er)
