多轴线图在excel [英] Multiple axis line chart in excel

问题描述

我正在寻找一个多轴线图，类似于下面的图片（这是由amcharts制作的JavaScript图表）。

有一个选项来绘制图表线这些？注意，有3个Y轴和3个线形图，允许您比较数据。

可以获得超过3个数据点，每个在一个图表上有唯一的轴？

解决方案

通过为系列中的一个指定辅助轴，可以在图表的一侧获得主轴和辅助轴。

要使主轴在辅助轴的右侧，您需要在主轴的格式轴对话框中将轴标签选项设置为高轴为了获得主轴左侧的副轴，您需要将格式轴对话框中的轴标签选项设置为低

我知道没有办法在单个图表上获得第三组轴标签。你可以假轴标签&

更可行的路线是由zx8754建议的：创建第二个图表，关闭标题，左轴等，并将其放在第一个图表上。看看我还没有微调的非常粗糙的模型。

I'm looking for a multiple axis line chart similar to the one in the image below, (which is a javascript chart made by amcharts).

Does excel have an option to draw charts line these? Note there are 3 Y axes, and 3 line charts allowing you to compare data.

Is it possible to get more than 3 data points, each with unique axis on one chart ?

解决方案

It is possible to get both the primary and secondary axes on one side of the chart by designating the secondary axis for one of the series.

To get the primary axis on the right side with the secondary axis, you need to set to "High" the Axis Labels option in the Format Axis dialog box for the primary axis.

To get the secondary axis on the left side with the primary axis, you need to set to "Low" the Axis Labels option in the Format Axis dialog box for the secondary axis.

I know of no way to get a third set of axis labels on a single chart. You could fake in axis labels & ticks with text boxes and lines, but it would be hard to get everything aligned correctly.

The more feasible route is that suggested by zx8754: Create a second chart, turning off titles, left axes, etc. and lay it over the first chart. See my very crude mockup which hasn't been fine-tuned yet.

这篇关于多轴线图在excel的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！