+ Reply to Thread
Results 1 to 11 of 11

Creating a dynamic area chart

  1. #1
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Creating a dynamic area chart

    Hi all,

    I'm trying to create a dynamic area chart; I want the user to be able select which series of data that they want to show on the graph, but I've had no success with pivot charts and slicers as yet. I've attached an example of what I'm trying to do and included a little further information.

    Any/all help would be welcomed.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Creating a dynamic area chart

    I don't deal with charts very much, but see if this is what you are trying to achieve.
    Attached Files Attached Files
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  3. #3
    Forum Contributor
    Join Date
    05-06-2015
    Location
    Sri Lanka
    MS-Off Ver
    2016, 2007
    Posts
    135

    Re: Creating a dynamic area chart

    I have included a slicer. You can select single value, multiple (with ctrl key).
    I suggest you to read about slicers some more on web.
    I am using excel 2013, so appearance might be slightly different.

    P.S - I recommend a line chart instead area chart.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Creating a dynamic area chart

    Many thanks both...
    Dineth - many thanks for your response but Table slicers are not supported in Excel 2010, so I cannot use this functionality.
    Sktneer - I am trying to download your file but keep getting error messages. I will continue to try and acesss it.

  5. #5
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Creating a dynamic area chart

    I am uploading the file again see if you can download it this time.
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    05-06-2015
    Location
    Sri Lanka
    MS-Off Ver
    2016, 2007
    Posts
    135

    Re: Creating a dynamic area chart

    2010 has slicers. only time-line is not there

    refer
    https://support.office.com/en-us/art...a-12651785d29d

  7. #7
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Creating a dynamic area chart

    Sktneer - many thanks, I can now view the file! It's working perfectly, I want a number of grades to appear on the chart at the same time, would check boxes instead of option boxes? That way I could select a number of them at the same time.

    Dineth - thanks I have used slicers on a number of occasions with pivot tables, however I have been unable to do so with this dataset as the time-line aspect is crucial

  8. #8
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Creating a dynamic area chart

    Please find the attached workbook where on Dynamic Chart 2 sheet, you have option for selecting checkboxes.
    There are two charts on this sheet. Please change the chart type as per your requirement.
    Attached Files Attached Files
    Last edited by sktneer; 09-02-2015 at 06:45 AM.

  9. #9
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Creating a dynamic area chart

    Huge thanks Sktneer - this is exactly the functionality I was hoping for. Really appreciate your help with this.

  10. #10
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,639

    Re: Creating a dynamic area chart

    You're welcome. Glad I could help.

  11. #11
    Registered User
    Join Date
    08-02-2015
    Location
    Newcastle, England
    MS-Off Ver
    2010
    Posts
    37

    Re: Creating a dynamic area chart

    Hi again Sktneer, I'm currently refining my chart further and want to make the x axis dynamic so that the months which do not currently hold data are not shown? Is this possible using the OFFSET function?
    Also is it possible to change the legend such that only the series which are shown on the chart are shown in the legend?

+ 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. Creating a line chart with area highlighted
    By mindfire in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-28-2014, 03:59 AM
  2. Creating dynamic userform based on several file names and creating chart overlays
    By Thorn23 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-18-2014, 12:09 PM
  3. [SOLVED] dynamic chart area for rows
    By Decar in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-04-2013, 06:25 AM
  4. [SOLVED] Lock dimensions of plot area of dynamic chart
    By Stefan1983 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-28-2012, 11:32 PM
  5. Creating an area using two values on a chart
    By rgold in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 09-15-2009, 03:43 PM
  6. Creating pattern area under part of an x-y chart
    By artmorris in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 06-16-2006, 01:15 PM
  7. Creating a chart of overlaid area circles?
    By m.nutt1 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-25-2005, 09:10 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1