Hi excelers,
I am here to post a problem which is beyond my excel skill level.
I need to plot a dataset within a 5x5 cell window made up of "1" (see attached screen).
Criteria: The formula should be easily copy/paste down to calculate pervious below rows of data, and be the simplest & fastest possible
Note, I already posted a thread related to drawing the chart with vertical lines, which mr kaper help out gratefully.
But to gain an overall single solution from "Normalize Range of datasets" to "Plotting the logic cell graph" I rewrite and reposted the problem here.
PS, looks easy but there is alot of tricky and optimization problems to overcome...
If you need any more information do please contact me.
Thx, stewart
Bookmarks