两个线图和轴之间的阴影区域

I am on day #2 of searching the web and, while I have found plenty of hits that seem like they should work, none of them seem to apply to my particular situation.

我在搜索网络的第2天，虽然我发现了很多看似他们应该工作的点击，但它们似乎都不适用于我的特定情况。

I have an Excel chart with two series displayed. One is a sort of exponential decay curve, and one is a constant that intersects with the exponential curve, but does not continue past it (the final x-value of the orange line is estimated to make it look like it intersects the blue curve):

我有一个显示两个系列的Excel图表。一种是指数衰减曲线，一种是与指数曲线相交的常数，但不会继续超过它（估计橙色线的最终x值使其看起来像是与蓝色曲线相交）：

The raw data for the blue curve is as follows (leaving off data labels for confidentiality reasons, but x-values are on the left and y-values are on the right):

蓝色曲线的原始数据如下（出于保密原因，不使用数据标签，但x值在左侧，y值在右侧）：

The orange line is simply set at 24 all the way across until it intersects with the blue curve.

橙色线一直设置为24，直到它与蓝色曲线相交。

So here's the problem I need to solve: I need to fill in all of the area below the blue curve with one color, and I need to fill in the area below the orange line with another color. Everything above the blue curve needs to be blank (transparent). Here's an illustration of what I want:

所以这就是我需要解决的问题：我需要用一种颜色填充蓝色曲线下方的所有区域，我需要用另一种颜色填充橙色线下方的区域。蓝色曲线上方的所有内容都需要为空白（透明）。这是我想要的例子：

I know in order to get the coloring/shading I need to use an area chart. However, when I try to change the chart type to Area the scales of the axes change for each series and they no longer match up, and I am unable to edit the axes (can't set min, max, etc) to make them match up again. Additionally, only the area directly beneath the constant line fills in (as expected), but I am looking for a way to fill in the area between the orange line, the blue curve, and the axes:

我知道为了获得着色/阴影，我需要使用面积图。但是，当我尝试将图表类型更改为区域时，轴的比例会针对每个系列而变化，并且它们不再匹配，并且我无法编辑轴（无法设置最小值，最大值等）以使它们成为可能再次匹配。此外，只有恒定线正下方的区域填充（如预期的那样），但我正在寻找一种方法来填充橙色线，蓝色曲线和轴之间的区域：

How might one go about doing what I need to do?

怎么可能去做我需要做的事情？

If there's any other information I could provide that would be of help, please let me know and I'll be sure to add it in.

如果我能提供其他任何有用的信息，请告诉我，我一定会加入。

EDIT: I can extend the orange line to follow the blue line off to the right, which may help fill in the lower area. However, when I switch to an area chart I still get the issue with mismatched axes with scale I can't edit:

编辑：我可以延长橙色线以跟随向右的蓝线，这可能有助于填补下部区域。但是，当我切换到区域图表时，我仍然遇到带有比例不匹配的轴的问题，我无法编辑：

Notice how the "567" point (the x-value where the orange line should intersect the blue curve) is spaced evenly between "500" and "600", rather than scaling slightly to the right of center as I would have expected.

请注意“567”点（橙色线应与蓝色曲线相交的x值）如何在“500”和“600”之间均匀分布，而不是像我预期的那样略微缩放到中心的右侧。

How do I keep the spacing of one tick every 100 units on the x-axis but keep the datapoint for 567?

如何在x轴上每100个单位保持一个刻度的间距，但保持数据点为567？

2 个解决方案

#1

You could find the intersection point's coordinates (graphically or analitically), then split your data in two separate series within the same graph as follows :

您可以找到交叉点的坐标（以图形方式或分析方式），然后将数据拆分为同一图表中的两个单独的系列，如下所示：

Edit post comment section :

编辑帖子评论部分：

For some reason x-values are considered by default as text.

由于某种原因，x值默认被视为文本。

Righ click the x-axis > format > Select date on the axis

右键单击x轴>格式>在轴上选择日期

Then play with the principal and base in days/months to have the intervals you want.

然后在几天/几个月内与校长和基地一起玩，以获得你想要的间隔。

Good parameters for this data :

这些数据的好参数：

main : 100 in days
主要：100天
base : in days
基地：天

#2

I would just have two identical charts : one does the blue and the other the orange then lay the orange chart on top of the blue and make it transparent ... worked a treat in the past...

我只有两个相同的图表：一个是蓝色，另一个是橙色，然后将橙色图表放在蓝色的顶部并使其透明......过去曾做过一种享受......

#1