具有主要和次要y轴的柱形图 [英] Column chart with primary and secondary y-axes

问题描述

我的问题似乎很简单，我只想用2个y轴做柱形图。当我这样做，Excel自动将列重叠。我不想让他们重叠！如何解决这个问题？

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?

正在发生的一个形象：

推荐答案

您可以通过一些相当仔细的操作来实现如下所示的图表：

You could achieve the chart as shown below with some rather careful manipulation:

基本上要求将数据间隔出来，如列A：C所示，但也可以对准水平轴标签，调整辅助轴最大值（如果需要，两个垂直轴的格式）和Series1的间隙宽度大约为10％，而Series2的间隙宽度为5％。

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我选择了C5的错误值。）

(PS I chose the wrong value for C5.)

这篇关于具有主要和次要y轴的柱形图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！