在 Excel 中创建仪表板
我正在考虑在 Excel 中创建一个仪表板，使用几个关键绩效指标来绘制图表。数据只是从 Excel 中的另一个工作表收集。我知道您可以与宏结合起来执行此操作，但我对宏的经验有限，尽管我愿意学习。
任何帮助都会很棒！
I am looking at creating a dashboard in Excel using several key performance indicators to plot a graph. The data would just be collected from another sheet in Excel. I understand that you can do this in conjunction with macros but my experience with macros is limited, although I am willing to learn.
Any help would be great!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
您可以从不使用宏开始，仅在需要真正想要的功能时才学习 VBA。有些链接可能会帮助您入门：
You might start without macros and learn VBA only if you need a feature you really want. Some links may help you get started:
Darren，
从单个 EXCEL 工作簿（文件）中的现有工作表中绘制特定部分（这对您来说是仪表板）的图表或任何数据很容易。您只需要选择图形向导并指向该工作表中的单元格范围。
只要知道路径，您也可以从另一张纸上绘制此图。这可以通过编写一些代码来控制，使其更加动态。
Darren,
Plotting a graph or any data for certain section (which is DASHBOARD for you) from an existing sheet in a single EXCEL WorkBook (File) is easy. You jut need to select graph wizard and point to the cell ranges in that sheet.
You can also plot this from another sheet as long as know the path. This can be controlled by writting some code to make it more dynamic.