View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.charting
 
Posts: n/a
Default vba charting question

Thanks Jon. I actually visited your site before posting, but I'm still
a little confused.

Here's what my data looks like:

date1 date2 date3
seriestitle1
seriestitle2 series data range A
seriestitle3
----------------------------------------------------
seriestitle4
seriestitle5 series data range B
seriestitle6

I have used VBA to identify the ranges corrseponding to A and B. I
could use the setsourcedata method to graph data range A with titles
and dates. But I can't do that for data range B.

Your website says, "You are not limited to using SetSourceData to
define the data being charted. You can add the series one-by-one,
selecting the precise data you want, not what Excel will assume you
want." It would be extremely helpful if you could give me a hint on
how to do this.