+ Reply to Thread
Results 1 to 2 of 2

Bar Graph in cells

  1. #1
    Registered User
    Join Date
    03-23-2009
    Location
    usa
    MS-Off Ver
    Excel 2003, 2013
    Posts
    16

    Bar Graph in cells

    I have a table in my excel sheet.
    I am wondering if it is possible to create a bar graph in this table : http://snag.gy/zBtZd.jpg
    When my 1st task i have 1 on S and 4 on F, i would like a bar graph to be created from 1 to 4 on the dates, or highlight them at minimum if a graph is not possible.

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: Bar Graph in cells

    In cell bars or graphs are available on Excel 2010-2016 versions. This feature called Sparklines and it is locate under Insert tab.

    There are other tricks can used which would require REPT() function, the character |, and one of the fonts named Stencil or Playbill

    Row\Col
    A
    B
    1
    7
    |||||||
    2
    4
    ||||
    3
    6
    ||||||
    4
    2
    ||
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 0
    Last Post: 09-15-2014, 02:01 AM
  2. Excel 2007 : Creating a graph within Cells
    By Natalie54321 in forum Excel General
    Replies: 1
    Last Post: 02-24-2012, 10:53 AM
  3. Graph Only Cells w/ Content
    By jollywood in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-14-2010, 05:16 AM
  4. using cells as graph
    By Tortus in forum Excel General
    Replies: 2
    Last Post: 06-01-2010, 05:43 PM
  5. Graph only last 7 cells of a given range?
    By matthewdoucette in forum Excel General
    Replies: 1
    Last Post: 12-10-2008, 01:01 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. Graph with empty cells?
    By Paquet in forum Excel General
    Replies: 0
    Last Post: 07-11-2006, 04:35 PM

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