| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
XYscatter chart source
I am trying to set the x & y source data ranges for a SYScatter chart in VBA.
I use the following code to create the chart, but the x values are not used for the x-axis (the automatic x-axis is 1,2,3...n). ActiveChart.SetSourceData Source:=ActiveSheet.Range(Y_rngStr), _ PlotBy:=xlColumns With ActiveSheet.ChartObjects(1).Chart .ChartType = xlXYScatter I have tried everything I can think of and variations of previous newsgroup questions/answers without success. Any suggestions would be appreciated! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| C#: XYScatter chart with smooth lines and no markers | Charts and Charting in Excel | |||
| charting independent XYScatter graphs | Charts and Charting in Excel | |||
| pie chart & column chart w/same source data | Charts and Charting in Excel | |||
| How do you link chart source data when you copy the chart? | Charts and Charting in Excel | |||
| Help with datapoints stack in XYScatter | Charts and Charting in Excel | |||
Threaded Mode
