+ Reply to Thread
Results 1 to 2 of 2

Adding a series to a Gantt table

  1. #1
    Registered User
    Join Date
    07-14-2016
    Location
    Cardiff
    MS-Off Ver
    2007
    Posts
    16

    Adding a series to a Gantt table

    I have added a new data set to the GANTT table
    'Arrange Medical'

    I can't get the bars to update on the graph

    I suspect I am doing something silly but I cannot work it out

    Can someone talk me through how to do this

    Thank you

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,532

    Re: Adding a series to a Gantt table

    I am not sure what results are expected, however when I use the 'Select Data' feature I notice that the 'Start' series values are: =Gantt!$E$2:$E$7. When I change the series values to =Gantt!$E$2:$E$8 and select OK, the green Gantt section (Live) appears adjacent to 'Arrange Medical'.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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: 1
    Last Post: 06-24-2017, 02:25 AM
  2. [SOLVED] Adding 1 series of data in 234 charts were 3 series already exist
    By Joachimjr in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-10-2014, 01:56 AM
  3. Adding a series of cells in a Pivot Table using GetPivotData function
    By Pratik Bhatia in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-15-2013, 10:00 AM
  4. =SERIES and charts (adding two cells in a series formula)
    By benmmaddog in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-11-2013, 09:52 PM
  5. Need to have a gantt chart build automatically based on a series of questions
    By kaalbdm in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-30-2012, 05:55 PM
  6. Gantt/schedule chart with single series
    By DAVID MACKLE in forum Excel General
    Replies: 1
    Last Post: 09-23-2011, 12:59 PM
  7. Keeping a series table from updating when adding new rows.
    By Jacen Saracen in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-18-2005, 02:05 AM

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