使用VB.Net的Excel图表 [英] Excel Chart Using VB.Net

问题描述

你好团队，

我正在使用VB.Net开发Excel图表，但现在想将显示单位"更改为千".我有以下代码-

Hello Team,

I am developing Excel charts using VB.Net, But now want to change Display Unit to "Thousand". I have below code -

Dim chartPage As Microsoft.Office.Interop.Excel.Chart
            Dim xlCharts As Microsoft.Office.Interop.Excel.ChartObjects
            Dim myChart As Microsoft.Office.Interop.Excel.ChartObject
            Dim chartRange As Microsoft.Office.Interop.Excel.Range
            xlCharts = wks_new.ChartObjects

            myChart = xlCharts.Add(10, 30, 350, 250)
            myChart.Chart.ChartStyle = 42
            chartPage = myChart.Chart
            chartRange = wks_new.Range("A1:I20")
            chartPage.SetSourceData(Source:=chartRange, PlotBy:=XlRowCol.xlRows)
            chartPage.ChartType = Microsoft.Office.Interop.Excel.XlChartType.xlLineMarkers

我知道以下VBA中的代码-

I know below code in VBA -

myChart.Axes(xlValue).DisplayUnit = xlThousands

但是如何在VB.Net中做到这一点呢?

请帮忙！

But how to do this in VB.Net???

Please Help!!!

推荐答案

如果您使用Interop，请查找xlAxisType和xlDisplayUnit

此处 [

If you use Interop, look for xlAxisType and xlDisplayUnit

Here[^] you''ll find MS Excel constants and them values.

myChart.Axes(xlValue).DisplayUnit = xlThousands

等于

is equal to

myChart.Axes(2).DisplayUnit = -3

这篇关于使用VB.Net的Excel图表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！