+ Reply to Thread
Results 1 to 7 of 7

Data Validation and Charting

  1. #1
    Forum Contributor
    Join Date
    04-14-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    131

    Data Validation and Charting

    I have Revenue and expenses data for years 2000 to 2010.

    1. how do I create a line chart so that when i use data validation, selecting either revenue or expenses, the Chart changes.

    2. how do I create a cell, where if i enter 2009, it will only show me a chart that goes up to 2009.

  2. #2
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Data Validation and Charting

    Hi slxiz1,

    This is achievable... Please upload an sample data for this. Thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  3. #3
    Forum Contributor
    Join Date
    04-14-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    131

    Re: Data Validation and Charting

    Hi DILIPandey,

    I have uploaded the file.

    What I am hoping to achieve is

    if i select Rabbits, and April, the chart will show rabbit data up to April only.

    What would be even better, is I could select between Feb and April.

    I managed to do this by "cheating", lots of if functions, but I really believe there is a better way.

    Looking forward to your insight.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    04-14-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    131

    Re: Data Validation and Charting

    additionally and MORE IMPORTANTLY, what if there are 10 animals? i used a simple if function to select the two, but its silly to do that if there are lots of animals.

  5. #5
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Data Validation and Charting

    Hi slxia1,

    I have used the dynamic names for animals which will accommodate the increase / decrease in the names.. also I have used the names in the chart which will show up the respective animal's data through selected month only, see the attachment and check it. To understand the names .. press Alt + I + N +D. thanks.

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    Attached Files Attached Files

  6. #6
    Forum Contributor
    Join Date
    04-14-2012
    Location
    Melbourne
    MS-Off Ver
    Excel 2007
    Posts
    131

    Re: Data Validation and Charting

    Hi Diliandey,

    That is really amazing. Thank you so much. I am studying your spreadsheet closely.

    You are very experienced.

  7. #7
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: Data Validation and Charting

    You are welcome slxia1...

    Cheers

    If you are satisfied with the solution, please mark this thread as solved, see the forum rules:-
    http://www.excelforum.com/forum-rule...rum-rules.html

    Regards,
    DILIPandey

    <click on below 'star' if this helps>

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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