Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's XY Plotting Question?
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel's XY Plotting Question?
Make a dynamic chart. The first link is a specific example that should help,
the second is an index to a bunch of examples: http://peltiertech.com/Excel/Charts/...umnChart1.html http://peltiertech.com/Excel/Charts/Dynamics.html - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Jo" wrote in message ups.com... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel's scroll bar | Excel Discussion (Misc queries) | |||
Excel's Backbone | Excel Programming | |||
Excel's TEMPLATE HELP | New Users to Excel | |||
VBA for plotting charts: Question re-worded | Excel Programming | |||
Excel's Hyperlinl | Excel Programming |