If you have data range as shown as below, and you want to make two y axes in chart for more clearly viewing the data, how could you do? Here I will tell you the detail on making two y axes in a chart in Excel.
How to make two y axis in chart in Excel?
A secondary vertical axis is displayed in the chart. To change the display of the secondary vertical axis, do the following: On the Layout tab,.
Office Tab Enable Tabbed Editing and Browsing in Office, and Make Your Work Much Easier...
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Make two y axis in chartAmazing! Using Efficient Tabs in Excel Like Chrome, Firefox and Safari!Save 50% of your time, and reduce thousands of mouse clicks for you every day!
Following the below steps, you will find that making two y axes in chart is very easy.
1. Select the data range, and insert a chart first by clicking Insert and selecting a chart you need in the Chart group.
2. Right click a column in the chart, and select Format Data Series in the context menu. See screenshot:
3. Then in Format Data Series dialog, check Secondary Axis in the Plot SeriesOn section, and click the Close button. See screenshot:
4. Then right click the red column in the chart, select Change Series Chart Type. See screenshot:
5. In Change Chart Type dialog, click Line in left pane, and select the line chart type you like. See screenshot:
6. Click OK to close dialog, and you see the chart is inserted with two y axes.
Note:
In Excel 2013, you need to change the chart type by right clicking the column, and select Change Series Chart Type to open the Change Chart Type dialog, then click All Charts tab and specify series chart type and the secondary axis in Choose the chart type and axis for your data series section, then click OK.
Relative Articles:The Best Office Productivity ToolsKutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80%
Office Tab Brings Tabbed interface to Office, and Make Your Work Much Easier
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.
The Chart Title and Axis Titles commands, which appear when you click the Design tab’s Add Chart Elements command button in Excel, let you add a title to your chart titles to the vertical, horizontal, and depth axes of your chart.
In Excel 2007 and Excel 2010, you use the Chart Title and Axis Titles commands on the Layout tab to add chart and axis titles.
After you choose the Chart Title or Axis Title command, Excel displays a submenu of commands you use to select the title location. After you choose one of these location-related commands, Excel adds a placeholder box to the chart. This chart shows the placeholder added for a chart title. To replace the placeholder title text, click the placeholder and type the title you want.
If you click the chart title once you’ve replaced the placeholder, Excel opens a Format Chart Title pane along the right edge of the Excel program window. This pane provides buttons you can use to control the appearance of the title and the box the title sits in.
The Format Chart Title pane, for example, provides a set of Fill options that let you fill in the chart title box with color or a pattern. (If you do select a fill color or pattern, Excel adds buttons and boxes to the set of Fill options so you can specify what the color or pattern should be.)
The Format Chart Title pane provides buttons and boxes for you to specify how you want any lines drawn or fill for the title or its box to look in terms of thickness, color, and style. The pane provides buttons and boxes for specifying any special effects, including shadowing, glow, edge softening, and the illusion of three-dimensionality. You can also control the sizing and setting other properties of the title.
You click the little icons at the top of a pane to flip between the different settings a pane supplies. In the case of the Format Chart Title pane, for example, you click the icons that look like a paint can, a pentagon and a box with measurement marks to access the Fill & Line, the Effects and then the Size & Properties settings.
Different Excel formatting panes provide different sets of formatting options. So go ahead and experiment with your options here to get comfortable with the options you have for your pivot charts.
In Excel 2007 and Excel 2010, you use the Format Chart Title dialog box rather than the Format Chart Title pane to customize the appearance of the chart title. To display the Format Chart Title dialog box, click the Layout tab’s Chart Title command button and then choose the More Title Options command from the menu Excel displays.
Comments are closed.
|
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |