Menu
Note: The following procedure applies to Office 2013 and newer versions. Looking for?.Select a chart to open Chart Tools.Select Design Change Chart Type.Select Combo Cluster Column - Line on Secondary Axis.Select Secondary Axis for the data series you want to show.Select the drop-down arrow and choose Line.Select OK.Add or remove a secondary axis in a chart in Office 2010When the values in a 2-D chart vary widely from data series to data series, or when you have mixed types of data (for example, price and volume), you can plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis reflects the values for the associated data series.After you add a secondary vertical axis to a 2-D chart, you can also add a secondary horizontal (category) axis, which may be useful in an xy (scatter) chart or bubble chart.To help distinguish the data series that are plotted on the secondary axis, you can change their chart type. For example, in a column chart, you could change the data series on the secondary axis to a line chart. You can plot data on a secondary vertical axis one data series at a time.
![]() ![]()
When the values in a chart vary widely from data series to data series, you can plot one or more data series on a secondary axis.
I want to draw a mschart with both primary and secondary Y-Axis and a common X-axis. Here are the possible duplicates but I didn't find the explanation I was looking for: Charts multi type and secondary Y axis. MS Chart Control Two Y Axis. I need some help on how to draw such a chart using MSChart. In this MS Excel tutorial from ExcelIsFun, the 304th installment in their series of digital spreadsheet magic tricks, you'll learn how to add a secondary axis to a.
![]() Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
January 2023
Categories |