Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel Charting Problem | Excel Discussion (Misc queries) | |||
Problem with Excel Charting ... Please Help | Charts and Charting in Excel | |||
CSV Charting Problem | Charts and Charting in Excel | |||
Excel Charting problem.. | Excel Discussion (Misc queries) | |||
Charting Problem VBA | Excel Programming |