Menu
My problem seems simple, I just want to make a column chart with 2 y-axes. When I do this, Excel automatically puts the columns overlapping. I do not want them overlapped! How do I go about correcting this?
An image of what is happening:
240
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.
When the data values in a chart vary widely from data series to data series, or when you have mixed types of data (for example, currency and percentages), you can plot one or more data series on a secondary vertical (Y) axis.
A second Y axis is a Y axis drawn on the right-hand side of a chart. It can show the same axis scale as the primary Y axis or a different scale. You can use a second Y axis with the same scale as the primary Y axis on a wide chart to help viewers interpret the data more easily.
I believe this method is more straightforward:
109
You could achieve the chart as shown below with some rather careful manipulation:
Basically is requires spacing out your data as shown in columns A:C but also right-aligning the horizontal axis labels, adjusting the secondary axis maximum (and format of both vertical axes, if necessary) and the Gap Width for Series1 to about 10% and for Series2 to about 5%.
(PS I chose the wrong value for C5.)
29
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
