+ Reply to Thread
Results 1 to 4 of 4

Chart in a Table

  1. #1
    Registered User
    Join Date
    01-07-2020
    Location
    Poland
    MS-Off Ver
    2007
    Posts
    2

    Chart in a Table

    Hi, I was recently asked to preform a task in Microsoft Excel. Last thing to do was adding a "Table with a chart in it".
    It should look like the one on a picture sdads.png I searched through the internet and couldn't find the instructions on how to do it.
    Could you help me? Thanks in advance.

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Chart in a Table

    Select the cells (e.g. B2 to B5) then click on Conditional Formatting | Data Bars, then choose your colour (pink). Do the same for the next column (green).

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    01-07-2020
    Location
    Poland
    MS-Off Ver
    2007
    Posts
    2

    Re: Chart in a Table

    Thanks for quick reply! Yes that is exactly what I was looking for! Thanks!

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    25,412

    Re: Chart in a Table

    You're welcome, and thanks for the rep.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

+ 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. displaying column chart with table below chart
    By ammartino44 in forum Excel General
    Replies: 1
    Last Post: 04-18-2015, 10:31 AM
  2. Waterfall Chart - Adding text to chart from table
    By smudgepost in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-26-2014, 08:03 AM
  3. Need help changing basic chart into a hierarchy chart/table in Excel 2010
    By attaboy000 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-04-2014, 05:26 AM
  4. Replies: 0
    Last Post: 09-01-2011, 12:07 PM
  5. Replies: 3
    Last Post: 09-11-2010, 06:55 AM
  6. Replies: 1
    Last Post: 04-14-2010, 07:38 PM
  7. How to display a series in chart table and not in the chart?
    By Mani in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-22-2006, 12:45 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