Posted to microsoft.public.excel.programming

Frank[_28_] Frank[_28_] is offline

external usenet poster

Posts: 14

Graph not plotting correctly if source not selected

Here my code:

Set Cht_level = Charts.Add
With Cht_level
.ChartType = xlLine
.SetSourceData Source:=cht_src
End With

if fails.

But if I

add cht_src.Select

before the code, it works brilliantly?

Why?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Why function generated results are not plotting correctly?	Need Help on axis problem in a chart[_2_]	Charts and Charting in Excel	1	March 8th 08 03:54 PM
Why function generated results are not plotting correctly?	Need Help on axis problem in a chart	Charts and Charting in Excel	1	March 6th 08 05:44 PM
Urgent help on plotting a X,Y graph...	Jon Peltier	Excel Programming	0	June 30th 07 08:31 PM
Plotting a Graph	Mayank	Excel Discussion (Misc queries)	2	June 9th 06 08:12 PM
Graph plotting	Dovla	Excel Programming	0	September 9th 04 02:05 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us