sponsored ads
How to Add or Remove a Secondary Axis of a Chart in Excel 2010
I have been making a complex chart in Microsoft Excel 2010. And I need to plot two data in one chart. These two series have much difference and the axes are not quite suitable for both. So I think it is necessary to add a secondary axis to this chart. But I have never used this feature, and don't know whether this idea is available. Could someone help me?
sponsored ads
Solution
- Open the Excel document with the chart you want to change.
- Then select the chart to display "Chart Tools" menu in the ribbon. Click "Layout" under it.
- Then click the arrow as follows. Select the series which you want to add a secondary axis.
- Go to "Format" and choose "Format Selection" in "Current Selection" group.
- In the "Format Data Series" window, choose "Series Options" > "Secondary Axis". Click "Close" to close this dialog box.
- Well, you can see the secondary vertical axis has been added.
- If you want to change the display of the secondary vertical axis, go to "Layout" > "Axes" > "Axes" tab.
- Then choose "Secondary Vertical Axis" and select one display in the list.
Add or Remove a Secondary Axis of a Chart in Excel 2010- - If you want to change the secondary vertical axis's options, right click on it and choose "Format Axis".
- Then "Format Axis" dialog box pops up. Click "Axis Options" and change options, such as minimum, major unit, major tick mark type and so on. Then click "Close".
- Next, I will tell you how to add a secondary horizontal axis.
- Go to "Layout" > "Axes" > "Axes" again.
- Then click "Secondary Horizontal Axis" and select one display , for example "Show Left to Right Axis".
- Well, the chart with secondary horizontal and vertical axises looks like this.
- If you want to remove the secondary vertical axis, just fix it and press "Delete" on the keyboard like this.
- OK, the axis has been removed.
- For the secondary horizontal axis, do the same step as the above.
- At last, you will see this original chart without a secondary axis.
Tips
See also
Search for Related Topics
reportviewer barchart secondary 2010excel secondary axis secondary axis oomfo powerpivot secondary axis amibroker secondary axis secondary axis qlikview cognos secondary axis
Related Unresolved Questions
- make columns on Microsoft Word (0 answer)
- How to resize taskbar if double-headed arrow doesn't appear? (1 answers)
- How can you remove the Microsoft Activation Wizard? (1 answers)
- increase font size in stardoll presentation (1 answers)
- How to Change Interval of Value Axis in an Excel Chart? (1 answers)
Authors
Tagged Add my tag
add , chart , excel 2010 , office 2010 , remove , secondary axis , excel 20120 graph secondary axis , excel macro identifying secondary axis , excel puts secondary axis left , excel powerpivot chart create secondary axis , c# excel.axis secondary
More Articles Related • Recent • Popular
- How to Add or Remove Secondary Axis for a Chart in PowerPoint
- How to Change the Scale of the Axis in a Chart in Excel 2010
- How to Add Error Bars for a Chart in Excel 2010
- How to Hide 0 Value in Excel Chart Axis
- How to Add Axis Title to Chart in PowerPoint
- How to Add Axis Titles for Chart in Word
- How to Add a legend to a chart in Excel
- How to Add a Trendline to a Chart in Excel
- How to Add chart elements in Excel
- How to Add a New Data Series to a chart in Excel
- How to Access Google Analytics in Excel
- Turn off screen updating using VBA in Excel
- Create and install an add-in from a workbook in Excel
- Copycat: A Freeware to Copy Clipboard Text from One Computer to Another
- View Docx, Pptx, Xlsx, Ppsx Online
- Efficient Ways to Reduce Excel Filesize
- How to Repeat Rows and Columns in Multipage Excel 2010 Sheet
- Sort Data in a Column Randomly in Microsoft Excel
- How to Change Product Key of Microsoft Office 2010
- How to Rotate Text to any Angle in Word
- How to Uninstall Microsoft Office 2010 Completely
- How to Extract or Recover Product Key of Microsoft Office 2010
- How to Freeze Panes to Lock Specific Rows or Columns in Excel 2010
- How to Add or Remove a Secondary Axis of a Chart in Excel 2010
- How to Convert PPT to DOC using PowerPoint
- How to Rotate Text in MS Word 2010
- How to Add the Developer Tab to the Ribbon in Word
- How to Create or Customize a Slide Master in PowerPoint 2010
sponsored ads
Recent Searches
2010 fonts messed word bollywood photos unblock address blue hustler sopcast cut kmplayer video avi convert swf avi converter online para rmvb connections portal watchers weight
Download this software from AFC
Continue to downloadPower by Afreecodec.com