Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I tried
MsgBox myChart.SeriesCollection(1).XValues MsgBox myChart.SeriesCollection(1).XValues.Address MsgBox myChart.SeriesCollection(1).XValues.Value They don't work. Here the of code: Sub Macro4_2() Dim rArea As Range, rXValues As Range, rYValues As Range Dim c As Variant Dim i As Integer Dim iNseries As Integer Dim chtmyChart As Chart Dim sSTR As String Set rArea = Application.InputBox(prompt:="Select range:", Type:=8) Set rXValues = Application.InputBox(prompt:="Select XValues:", Type:=8) Set rYValues = Application.InputBox(prompt:="Select YValues:", Type:=8) iNseries = rArea.Rows.Count - 1 Set chtmyChart = Charts.Add With chtmyChart For i = 1 To iNseries .SeriesCollection.NewSeries Next .Name = "Pippo" i = 1 For Each c In .SeriesCollection sSTR = "=Foglio1!" & rArea.Offset(i - 1, 0).Resize(1, rArea.Columns.Count).Address(ReferenceStyle:=xlR1C 1) Rem c.Values = "=Foglio1!$C$4:$L$4" Rem c.Values = sSTR c.Name = "=Foglio1!" & rYValues(i - 1).Address(ReferenceStyle:=xlR1C1) c.XValues = rXValues.Address i = i + 1 Rem MsgBox "LABEL: " & sYValues(i).Address & "SERIE: " & sSTR & "" Next .ChartType = xlSurface End With all things go fine << MsgBox chtmyChart.SeriesCollection(1).XValues macro stops << End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XValues Property and 400 Error | Charts and Charting in Excel | |||
Displaying XValues and Values for chart using VBA | Charts and Charting in Excel | |||
Can't Set XValues for Surface Chart | Charts and Charting in Excel | |||
XValues and values. | Excel Programming | |||
Chart Setting Xvalues | Excel Programming |