Spectacular Excel Secondary Axis Scatter Plot
Series 1 is on the primary vertical axis while Series 2 is on the secondary vertical axis.
Excel secondary axis scatter plot. I have a problem in plotting x-y scatter plot series using 2 horizontal axis one being a date date no and the other one a calculated person age at that date. Each one on its own vertical axis. Excel column chart.
I have an x-y scatter plot and the x-axis data is from 15 to 35. I tried to modify the Box and Whisker chart above but is doesnt allow you to add a secondary axis. Click the icon floating beside the chart click on the right-pointing triangle next to Axes check Secondary Horizontal Axis and uncheck Secondary Vertical Axis fourth chart middle of bottom row.
I want to plot the date and time on the x-axis. Drag the same selection to the chart a second time and some new data points will appear dont. Right-click two-finger tap on the series 3.
Excel adds a secondary Y axis third chart bottom left. Click on the chart. But what if you want to plot 2 y-axis variables.
A secondary axis allows you to plot two variables along two distinct vertical axes ie. Please have a check at the following Excel chart. Click Format Selection on the Format tab.
First select one of the data series and select secondary next in select secondary x axis. However excel just plot 1200 AM 7 times randomly. On your scatter chart right-click on the data series must have at least two data series that you want to put on the secondary Y axis Select Format Data Series Select the Axis tab Select the Secondary Axis option.