How do you graph different scales in Excel?

Table of Contents

Add or remove a secondary axis in a chart in Excel

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.

Can you have a graph with different scales?

In an Excel chart, can I have different Y-axis scales (a primary and secondary axis)? Yes, in Excel 2013 and Excel 2016 you can have two axes. Start by creating a chart with just one axis. Select the data series you wish to place on a secondary axis, by clicking on the series in the chart.

Can a graph have two different scales?

It is also possible to have different scales on each axis. For example, each interval on the y-axis could represent 2, or even 10 units, while each interval on the x-axis represents 1 unit.

How do I change the horizontal axis scale in Excel?

Change the scale of the horizontal (category) axis in a chart (Office 2010)

Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis.

Can two different scales be used for the same axis in a graph?

When you use dual scales, there is one scale to the left and one scale to the right on the Y-axis/Value axis. Each of the scales can be shared by more than one measure. For example, in the bar chart below, two columns share the scale to the left.

How do you make a mini chart?

Inserting Excel Mini Charts

Step 1: Select the chart data > Insert tab > choose your chart.
Step 2: Remove the title, axes and grid lines.
Step 3: Resize the plot area so that it extends to the outer edge of the chart area…

What is a fractional scale?

The ratio of the distance between two points on a map and the distance between those points on the ground is called fractional scale. For example, 1 : 3000 indicates that 1 unit on the map is equal to 3000 units on the earth’s surface.

How do you change the scale of the vertical value axis in a chart?

Click the chart, and then click the Chart Layout tab. Under Axes, click Axes > Vertical Axis, and then click the kind of axis label that you want.