Forum Discussion
Excel XY Scatter plot - secondary vertical axis
Click on the chart.
Click on the second series, or select it from the Chart Elements dropdown on the Format tab of the ribbon (under Chart Tools).
Click 'Format Selection' on the Format tab.
Select 'Secondary axis' on the 'Format Data Series' task pane.
That's all!
Example, before and after changing the axis:
Click on the chart.
Click on the second series, or select it from the Chart Elements dropdown on the Format tab of the ribbon (under Chart Tools).
Click 'Format Selection' on the Format tab.
Select 'Secondary axis' on the 'Format Data Series' task pane.
That's all!
Example, before and after changing the axis:
HansVogelaar is there any update to this with Office 365? I am facing the same problem, but the Secondary Axis is no longer visible in the way described in this incident.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
- I do not get XY Chart
I get I straight line from just First and last item
do not get scater chart for the entire monthPlease provide more detailed information. Could you attach a sample workbook (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar? Thanks in advance.
notice first day is the lowest and goes straight across to highest date
here is the data
- Awesome! I got it to work with your help. Thanks so much! 🙂
