Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
Let's say I have the following
ActiveChart.SeriesCollection(1).XValues = "B2:B20" ActiveChart.SeriesCollection(1).Values = "D2:D20" How do I go about extracting the XValues and Values so that I can display "B2:B20" and "D2:D20" in VBA. I've got xval = activechart.seriescollection(1).Xvalues xval is currently defined as a string. When I run, I get a run time error '13' Type mismatch. Thanks, Barb Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
Problem adding Series XValues to Chart using VBA | Charts and Charting in Excel |