LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
y y is offline
external usenet poster
 
Posts: 60
Default Displaying XValues.

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
XValues Property and 400 Error C. Collings Charts and Charting in Excel 0 February 1st 07 05:09 PM
Displaying XValues and Values for chart using VBA Barb Reinhardt Charts and Charting in Excel 2 January 13th 06 01:34 AM
Can't Set XValues for Surface Chart Jack Charts and Charting in Excel 1 March 26th 05 07:06 AM
XValues and values. y Excel Programming 3 April 10th 04 03:13 AM
Chart Setting Xvalues Nigel[_8_] Excel Programming 1 December 24th 03 08:10 AM


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"