带有两个不同比例的折线图报告？ [英] Line Chart Report with 2 Different Scales?

问题描述

我有一个有两条线的折线图。有时，它们之间的值相差一百或更多。这使得底线看起来很平。我想这两个都保持在同一个图表，但是有一种方法，每行有不同的规模。

I have a line chart with two lines in it. Sometimes the values between them differ by a hundred or more. That leaves the bottom line looking very flat. I want both of these to remain on the same graph but is there a way to have a different scale for each line?

我被告知，有可能有一个（scale）在左边，一个在右边，但我已经google和google了，并没有发现任何有用的。

I was told that it is possible to have one (scale) on the left and one on the right, but I have googled and googled and have not found anything useful.

任何帮助将是伟大的，谢谢！ / p>

So any help would be great, thanks!

推荐答案

在图表系列的属性中将ValueAxisName更改为次要

In the properties for the chart series change the ValueAxisName to Secondary

OR

1. 右键点击图表系列


2. 转到系列属性


3. 转到轴和图表区域


4. 将轴更改为次要

1. Right-click on the chart series
2. Goto Series Properties
3. Goto Axes and Chart Areas
4. Change the value Axis to Secondary

这篇关于带有两个不同比例的折线图报告？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！