我在 Excel 中打开了一个 csv 文件。我想通过选择两行来创建两个折线图。问题是这些行在一行中。这怎么可能？一行包含许多值，需要根据同一行中的一组值绘制一组值。两组的功率相同。这两组值是通过根据其他列的值过滤行来获取的。我可以创建一组图，因为我可以应用过滤器一次。如何通过在同一列上执行独立过滤器将第二组值添加到现有绘图中？我不想将文件拆分为两个不同的文件。我对excel 2007不太熟悉。
I have a csv file open in excel. I want to create two line graphs by choosing two rows. The problem is that these rows are in one row. How is this possible? One row contains many values from which a set of values needs to be plotted against set of values in the same row. The power of the two sets are identical. These two sets of values are fetched by filtering the row according to the values of other columns. I can create the plot of one set since I can apply the filter once. How can I add the second set of values onto the existing plot by doing an independent filter on the same column? I don't want to split the file into two different files. I am not that familiar with excel 2007.
发布评论
评论（1）
如果您的数据已标记，您可能需要使用 数据透视图。单击链接查看概述
If your data is labeled, you probably want to use a pivot chart. Click the link for an overview