次级轴Excel图表（月/总数）

发布于 2025-01-23 07:55:06 字数 891 浏览 0 评论 0原文

我有一个问题。我想显示在堆叠的Excel列图中产生的费用。此外，这些列应代表每月和年度成本类型。但是，问题在于年度值需要不同的缩放，但是不幸的是，我找不到可以看到次级轴上年度值的解决方案。在屏幕截图中可以看到错误的缩放。我知道的唯一解决方案是加入两个图表。还有其他解决方案吗？提前致谢。

	2022年3	月2021	年2022	年2021年
成本1	14.230,00€	3.233,00€	566.652,00€	€
12.131,00	322.322,00	322.322,00	€	COST2 12.131,00
欧元	23.233,00€	652.656,00 €	233.232,00€	221.243,00€
COST4	4.543,00€	21.111,00€	122.223,00€	232.113,00€

原文

I have a question. I would like to display the costs incurred in a stacked Excel column chart. In addition, the columns should represent the monthly and annual cost types. However, the problem is that the annual values need a different scaling, but unfortunately I can't find a solution to visualize the annual values on a secondary axis. The wrong scaling can be seen in the screenshot. The only solution I know of would be to concatenate two charts. Is there any other solution? Thanks in advance.

	March 2022	March 2021	Year 2022	Year 2021
Cost1	14.230,00 €	3.233,00 €	566.652,00 €	322.322,00 €
Cost2	12.131,00 €	23.233,00 €	652.656,00 €	222.258,00 €
Cost3	2.323,00 €	1.211,00 €	233.232,00 €	221.243,00 €
Cost4	4.543,00 €	21.111,00 €	122.223,00 €	232.113,00 €