Results 1 to 2 of 2

Simple plot graph within cells!

Threaded View

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Cool Simple plot graph within cells!

    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
    Attached Images Attached Images

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Simplest/fastest way to plot graph within cells?
    By QuantEdge in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-25-2018, 09:04 AM
  2. Plot two series in same graph selected by "Drop Box" graph title
    By Ochimus in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 02-06-2016, 10:11 AM
  3. Replies: 4
    Last Post: 12-24-2014, 07:24 PM
  4. Excel 2010 - X Y scatter plot will not plot empty cells as gap
    By bjeffers0306 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-12-2013, 12:56 AM
  5. Line Graph - Do plot zero, Don't plot #NA
    By Janc in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 04-01-2012, 05:45 PM
  6. plot x, y graph with cells
    By iturnrocks in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-14-2007, 12:35 PM
  7. [SOLVED] how do I create a box-plot (or whisker plot ) graph?
    By raal in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-08-2005, 04:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1