+ Reply to Thread
Results 1 to 5 of 5

Dynamic Series for a graph

  1. 06-30-2014, 01:58 PM #1
    exclusiveicon
    exclusiveicon is offline
    Registered User
    Join Date
    04-02-2014
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Dynamic Series for a graph

    I have a graph that auto updates but sometimes there is only 1 series and sometimes there is 2,3,4, or 5 series. Is there a way to have the graph update accordingly? and only have have the series that are valid be in the key on the graph. Currently the graph keeps all the series in the key even when there isn't any data for it.

    Please see attachment. Use sheet 2 for the graph. and use the drop down menu to select catagory. this ia very quick mock up of the concept.

    Graphseries.xlsx
    Last edited by exclusiveicon; 07-01-2014 at 08:13 AM. Reason: add attachment
    Reply With QuoteRegister To Reply
  2. 06-30-2014, 03:30 PM #2
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Dynamis Series for a graph

    Hi,

    Please post a sample template of your workbook using "Go Advanced" option.
    Reply With QuoteRegister To Reply
  3. 07-01-2014, 08:14 AM #3
    exclusiveicon
    exclusiveicon is offline
    Registered User
    Join Date
    04-02-2014
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Dynamis Series for a graph

    cbatrody, i hope this helps!
    Reply With QuoteRegister To Reply
  4. 07-01-2014, 12:27 PM #4
    exclusiveicon
    exclusiveicon is offline
    Registered User
    Join Date
    04-02-2014
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2010
    Posts
    25

    Re: Dynamis Series for a graph

    Quote Originally Posted by cbatrody View Post
    Hi,

    Please post a sample template of your workbook using "Go Advanced" option.
    sample posted
    Reply With QuoteRegister To Reply
  5. 07-02-2014, 02:33 AM #5
    cbatrody
    cbatrody is offline
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,136

    Re: Dynamic Series for a graph

    Hi,

    I could do this with the help of a Macro. Please run the Macro (CTRL+SHIFT+G) after changing the dropdown in Sheet2.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Move from one series to the next series in a graph shortcut
    By nredman in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 05-17-2014, 02:45 AM
  2. [SOLVED] Second Axis for a Graph but with the same kind of graph for the two series?
    By Marceltcm in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-18-2013, 05:37 AM
  3. varied series for graph which adjusts series
    By sput_sput in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 12-06-2010, 02:54 PM
  4. Two Series Graph-Add Line Graph To It?
    By TomBrooklyn in forum Excel General
    Replies: 1
    Last Post: 04-21-2005, 04:38 PM
  5. [SOLVED] series graph -- one series being added to another series
    By rich zielinski via OfficeKB.com in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 03-30-2005, 02:06 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1