Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default 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


Reply
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
Excel Charting Problem Gemini Excel Discussion (Misc queries) 2 April 14th 08 06:55 PM
Problem with Excel Charting ... Please Help zoddiax Charts and Charting in Excel 1 October 11th 07 07:58 PM
CSV Charting Problem Quicksilver2002 Charts and Charting in Excel 1 June 6th 06 06:58 PM
Excel Charting problem.. Alex Excel Discussion (Misc queries) 1 August 5th 05 01:57 PM
Charting Problem VBA Jon Peltier[_3_] Excel Programming 0 August 24th 03 03:05 PM


All times are GMT +1. The time now is 07:25 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"