在Excel中创建模板 [英] Creating the template in excel

问题描述

大家好，

如何在Excel中为图形创建模板?

例如:我有一组点，当我在该区域中加载这些点集时，应使用这些值自动创建图形.

Hello all,

How to create a template in excel for a graph ?

Eg: I have a set of points and when I load those set of points in that area, a graph should be created automatically using those values. Is it possible to do that way and how?

推荐答案

您可以使用Macros，VBA等动态创建图表.请参考以下链接，这将对您有所帮助.您也可以从.net应用程序中使用C#和Vb.net创建图

使用VB.NET从数据库动态创建Excel图表 [ ^ ]

http://support.microsoft.com/kb/176443 [ http://excel.bigresource.com/Creating-a-graph-using-VBA --mVoBuB85.html [ ^ ]


http://msdn.microsoft.com/en-us/library/aa203725 (v = office.11​​).aspx [

You could create charts dynamically using Macros, VBA etc. Please refer the following links which will help you. You could also create graphs using C# and Vb.net from .net application

Creating Excel Charts Dynamically from Database, using VB.NET[^]

http://support.microsoft.com/kb/176443[^]

http://excel.bigresource.com/Creating-a-graph-using-VBA--mVoBuB85.html[^]


http://msdn.microsoft.com/en-us/library/aa203725(v=office.11).aspx[^]

这篇关于在Excel中创建模板的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！