是否有可能获得一个excel图表，有可能选择要显示的图表？ [英] Is it possible to get an excel chart with possibility to select the graphs to display?

问题描述

我在Excel表格中有几个数据，我想知道是否可能（通过宏或其他）选择数据和显示系列需要。

m不太确定如果我正确解释了情况...

但我有多个曲线，而不是绘制平均曲线或单个曲线，我想有绘制选项：曲线1，曲线2，曲线3，平均曲线...

请注意，

DNA

解决方案

我最喜欢的方法是结合几个想法。一般来说，如果Excel图表查看的是简单范围而不是复杂的命名范围，则最便于维护。鉴于此，我喜欢为图表创建一个简单的数据列，然后使用其他Excel功能修改该列数据。

请注意，以下步骤适用于一个数据块的特定情况全部在一张纸上。有很多变体，你可以做，使这项工作的其他配置。这个想法很简单：为图表创建一个新的数据列，并使用普通公式获取数据。您也可以将x轴作为选择器。

对于一个公共x轴的简单情况，y轴的变化序列都在一个块中数据，我按以下步骤操作：

开始=数据块 img src =https://i.stack.imgur.com/xedZW.pngalt =起点>

1. 添加一个列标题到驱动选择的那一边。我喜欢使这个数据验证下拉，使选择是正确的。我在 G2 中选择了 Source 。







2. 这样就可以使用那里的选择更新其下面的列中的数据。执行此操作的简单公式使用 INDEX 。



$ c> G3 ，复制到数据结尾： = INDEX（$ C $ 3：$ E $ 25，，MATCH（$ G $ 2，$ C $ 2：$ E $ 2 ，0））





此公式通过查找列标题列表中的列名称并返回该列数据来工作。由于行选择是空白的 ,, ，它依赖于单元格的工作的相对位置，因为一切都排队。






3. 完成后，您就可以使用日期和新的数据列创建图表。它将响应选择器中的工作很好的更改。如果你使用列 G 头作为系列名称，那将更新，这是一个很好的效果是免费的。下面是显示其使用范围的图表。





I have several data in excel sheet and I wonder if its possible (through macros or something else) to select the data and display the series needed.

I'm not quite sure if I explained the situation correctly...

But I have multiple curves, and instead of plot the average curve or single curves, I would like to have the option to plot: curve 1, curve 2, curve 3, average curve...

Kind regards,

DNA

解决方案

My preferred way to do this is with a combination of a couple of ideas. In general, Excel charts are easiest to maintain if they are looking at a simple range instead of complicated named ranges. Given this, I like to create a simple column of data for the chart and then use other Excel features to modify that column of data.

Note that the steps below are for a specific case of a block of data all on one sheet. There are a ton of variations that you can do to make this work for other configurations. The idea is simple: create a new column of data for the chart and use normal formulas to get the data there. You can make the x-axis a selector as well.

For the simple case of a common x-axis with varying series for the y-axis all in one block of data, I do these steps:

Start = block of data

1. Add a column header off to the side which will "drive" the selection. I like to make this a Data Validation drop down so that the selection is correct. I did this in G2, selecting the column headers as the Source.
2. With this in place, you can use the selection there to update the data in the column below it. A simple formula for doing this uses INDEX.

Formula in G3, copied down to end of data: =INDEX($C$3:$E$25,,MATCH($G$2,$C$2:$E$2,0))

This formula works by finding the column name in the list of column headers and returning that column of data. Since the row selection is blank ,,, it relies on the relative position of the cell which works since everything is lined up.

3. Once this is done, you can then create the chart simply using the date and the new column of data. It will respond to changes in the selector which works nicely. If you use the column G header as the series name, that will update too which is a good effect for free. Below is the chart showing the ranges it is using.

这篇关于是否有可能获得一个excel图表，有可能选择要显示的图表？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！