View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jo[_2_] Jo[_2_] is offline
external usenet poster
 
Posts: 69
Default Excel's XY Plotting Question?

On Aug 2, 12:46 pm, reklamo wrote:
Hi Jo

Due to the problem that I can't send you an attachment with this reply, I
will send you a mail to your mail address
Regards
reklamo



"Jo" wrote:
Hi everyone,


Say I have a table of x-y 5 rows. I plot them using xy option.


Now, say the # of the rows vary so sometimes I have 5 rows, another I
have 4 rows and so on. When I do the plotting for 5 rows, I get
straight line. Next, say now I have 4 rows, I have to go to each axis
and make a change to the cell number so the graph is right! If I have
3 rows, I have to re-do the cell # adjustment again!! If I don't do
so, the graph would be WRONG since it was designed for 5 points, now
for 4, and so on!


How can I automate that? I hope I did explain it clearly. If not,
please ask?


Thanks,
John- Hide quoted text -


- Show quoted text -


I got your zipped file, saved it, but I tried to open it told me it is
either corrupted or ?

Any other way?

Jo