• Home
 · 
• Microsoft Office Apps/VBA
 · 
• ExcelGraphAsWebpage

ExcelGraphAsWebpage

It creates an Excel graph [using Excel] and converts the graph to an WebPage.

Inputs
chartTitle As Variant, categoryAxisTitle As Variant, valueAxisTitle As Variant, seriesTitleA As Variant, categoryAxis As Variant, seriesDataA As Variant, seriesDataB As Variant, folderPathForWebPage As String, fileNameForWebPage As String

Assumes
You have a project named [WebPageCreation] and have a command button to execute the process, in that you will construct the params needed to create an excel graph and the path to store the result as WebPage. And also you have an Excel Sheet named [ExcelChart] in that you have a macro named [DrawBarChart] and a method that saves the graph as WebPage [CreateWebPage].

Returns
As Boolean

Side Effects
-

API Declarations
-

Rate ExcelGraphAsWebpage

• 1
• 2
• 3
• 4
• 5

(5(5 Vote))

Download ExcelGraphAsWebpage