06-07-2014 04:10 PM
sorry,i forget.i did it now
06-08-2014 11:17 AM
06-08-2014 11:49 AM
@altenbach wrote:
- You still have not explained what kind of histogram you want from ll the columns. Explain exactly want kind of result you would expect from the default data.
- ....
^^
06-08-2014 11:55 AM - edited 06-08-2014 11:56 AM
like that one,but the green also has to appear there in E1.....,why i can't see it
i made some change on the vi
06-08-2014 12:03 PM
06-08-2014 12:57 PM - edited 06-08-2014 01:51 PM
OK, so you just want a bargraph with two bars per x value. that has nothing to do with a histogram. See my confusion? (A histogram is a statistical tool for data reduction. You are graphing all the raw data)
Your code was way too convoluted and inefficient, so here's a quick rewrite. See if it can point you in the right direction. As I said, I don't have your office toolkit, so I added a listbox to select a candidate and graph the result. You can leave that code out). All your file operations belong into the FOR loop in the upper right.
Notes on your code:
06-08-2014 01:16 PM
so this code will work with excel,a histogram is a bar graph i think
i'll try it now
06-08-2014 01:49 PM
A histogram is a very special kind of bar graph where the Y value is a count and x is an observation range.
You data has nothing to do with a histogram.
06-08-2014 03:44 PM
thanks a lot it really works,ur amazing Mr altenbach