+ Reply to Thread
Results 1 to 3 of 3

Picking Specific Series in Graph to show

  1. #1
    Registered User
    Join Date
    10-18-2012
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2007
    Posts
    56

    Picking Specific Series in Graph to show

    Hi,

    I have data regarding how many days it takes to complete certain cases - broken up into small cases and complex cases. The raw data is in the first two files - the table at the bottom left hand corner shows first the number of cases, and the row beneath it shows the percent for that month.

    In the two graph tabs, I am looking to represent these numbers. As you can see, the first stacked bar graph looks ok - it shows the breakdown percentage of how many days it took to complete the cases in each month.

    The problem is the graph below it - the line graph. Using the same data, each series represents a particular month. As you can see, the graph is quite a "mess" in that it is hard to distinguish the lines. I was thinking a better way to represent this was to make it so you can "toggle" which months you wanted to see on the graph itself. For example, if I wanted to compare Jan vs Feb vs March, I could simply "select" those three lines to look at on the graph.

    Is this possible?
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    06-14-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Picking Specific Series in Graph to show

    ChartDateRange.xlsm

    Refer the attachment along with Instruction sheet.


    Regards,
    Mohan.Y

  3. #3
    Registered User
    Join Date
    06-14-2013
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: Picking Specific Series in Graph to show

    If you need selections randomly or more dimension selections then, use Pivot Chart.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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