bluetide76
09-30-2008, 08:07 PM
I have a line chart that plots data from 4 columns. First column is data points while the other 3 are control limits which are the same value for all data points making a straight line.
My conflict is that I have the chart set to go up to 100 data point entries, but there is the possibility that it may only have 20 at first. I made if statements in those cells to give N/a in order to dodge it plotting those data points that would be blank cells. But it still counts the number of iterations which is 100 points. So I was able to get my Y value points to limit correctly based on the data input, but how do I tell the chart not to graph the X values if they are v/a?
To explain it more clear say I have this below
5 8 7 9
3 8 7 9
N/a N/a N/a N/a
The graph will plot the points 5 and 3 and the lines at 7 8 9 but wont enter any Y value for N/a. This is what I wanted. But for the X axis it would show 4 entries and the data series stops at 3. How do I make it cut off as well?
Also how can I make a sub to rescale my chart based on my data sizes?
My conflict is that I have the chart set to go up to 100 data point entries, but there is the possibility that it may only have 20 at first. I made if statements in those cells to give N/a in order to dodge it plotting those data points that would be blank cells. But it still counts the number of iterations which is 100 points. So I was able to get my Y value points to limit correctly based on the data input, but how do I tell the chart not to graph the X values if they are v/a?
To explain it more clear say I have this below
5 8 7 9
3 8 7 9
N/a N/a N/a N/a
The graph will plot the points 5 and 3 and the lines at 7 8 9 but wont enter any Y value for N/a. This is what I wanted. But for the X axis it would show 4 entries and the data series stops at 3. How do I make it cut off as well?
Also how can I make a sub to rescale my chart based on my data sizes?