在 Excel 2007 中使用动态交互范围创建图表以选择系列

发布于 2024-08-26 03:45:24 字数 1219 浏览 7 评论 0原文

我想为以下问题创建一个基于非 VBA 的解决方案：

如何创建一个多系列图表，允许用户从下拉列表中进行选择以更改绘制的数据？当数据系列连续时我已经可以做到这一点；但是，我希望能够对非连续数据执行此操作。这可能吗？

我的数据看起来像这样：

  ID    Salary   Sal Min   Sal Mid   Sal Max   Division  Job Grade   Job Subgrade  Job
  XXX   10000    5000      15000     25000     North     13          1             Programmer
  XXX   12000    5000      15000     25000     North     13          1             Programmer
  XXX   14000    5000      15000     25000     South     13          1             Analyst
  XXX   11000    5000      15000     25000     South     13          1             Analyst
  XXX   20000    5000      15000     25000     North     14          1             Super Programmer
  XXX   25000    5000      15000     25000     North     14          1             Super Programmer
  XXX   22000    5000      15000     25000     North     14          1             Manager
  XXX   17000    5000      15000     25000     South     14          1             Manager
  XXX   19000    5000      15000     25000     South     14          1             Manager

我想使用折线图显示“工资”、“最低工资”、“中工资”和“最高工资”。我希望用户能够选择职位等级、部门和/或职位来确定图表中的内容。这可能吗？如果我使用数据透视表或将数据转换为数据表，我是否能够做到这一点？

谢谢。

原文

I would like to create a non-VBA based solution to the following question:

How do I create a multi-series chart that will allow a user to select from a dropdown to change the data being graphed? I can do this already when the data series is contiguous; however, I'd like to be able to do it for non-contiguous data. Is this possible?

My data look something like this:

  ID    Salary   Sal Min   Sal Mid   Sal Max   Division  Job Grade   Job Subgrade  Job
  XXX   10000    5000      15000     25000     North     13          1             Programmer
  XXX   12000    5000      15000     25000     North     13          1             Programmer
  XXX   14000    5000      15000     25000     South     13          1             Analyst
  XXX   11000    5000      15000     25000     South     13          1             Analyst
  XXX   20000    5000      15000     25000     North     14          1             Super Programmer
  XXX   25000    5000      15000     25000     North     14          1             Super Programmer
  XXX   22000    5000      15000     25000     North     14          1             Manager
  XXX   17000    5000      15000     25000     South     14          1             Manager
  XXX   19000    5000      15000     25000     South     14          1             Manager

I would like to display Salary, Sal Min, Sal Mid, and Sal Max using a line graph. I would like the user to be able to select Job Grade, Division, and/or Job to determine what is charted. Is this possible? Would I somehow be able to do this if I used a pivottable or converted my data into a datatable?

Thanks.

分享到QQ

分享到微博