ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Charting Problem (https://www.excelbanter.com/excel-programming/340971-charting-problem.html)

Bill[_30_]

Charting Problem
 
I have a chart am I trying to make. Sometimes the first cell does not have
data in it. I am trying to make a line chart. The first line does not
appear on the chart if there is not data.. It appears that Excel sees the
first cell in the second and third column as names for the cells.

0.751724 2.458138
1.8 0.751724 2.458138
0.9 0.751724 2.458138
0.8 0.751724 2.458138
0.4 0.751724 2.458138
0.9 0.751724 2.458138
0.9 0.751724 2.458138
0.4 0.751724 2.458138
0.9 0.751724 2.458138


The code I am using is:
Charts.Add
ActiveChart.ChartType = xlLineMarkers
ActiveChart.SetSourceData Source:=PlotX, PlotBy:=xlColumns
For i = 1 To ActiveChart.SeriesCollection.Count
ActiveChart.SeriesCollection(i).XValues = SN
Next i

Plot X is the data in the three columns. Sn is the X values for the chart.

Suggestions? Thanks.

Bill




All times are GMT +1. The time now is 11:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com