+ Reply to Thread
Results 1 to 2 of 2

An easy way to make graphs?

  1. #1
    Registered User
    Join Date
    04-16-2013
    Location
    NY
    MS-Off Ver
    Excel 2003
    Posts
    1

    An easy way to make graphs?

    Hi,

    I'm trying to basically help somebody track data in Excel, and use that data to make predictions. To do this, I'm trying to find an easier way of making graphs for them. I'll have an extremely basic set of data, something like this:

    Apples Oranges Pears Lemons Limes
    2008 20 26 28 24 32
    2009 15 18 20 19 26
    2010 20 30 28 14 18
    2011 24 19 18 20 6
    2012 22 17 32 19 20


    Now, the person I'm working with has never used Excel, and hasn't used computers very often in general, so I'm trying to make this as simple as possible for him. But I haven't used Excel much myself and don't know about the more advanced functions.

    So I have two questions:

    1. I'm looking for a way to make it so he can essentially click a button for the independent variable, and a button for the dependent variable, and a scatter plot shows up with a trend line. So basically, he just clicks a little button or checks a box that says apples, a little button that says oranges, and a scatter plot shows up that plots apples vs. oranges with a trend line, with the trend line equation and the r squared value showing. Maybe even have it give apples and oranges as the axes titles. Is there a way to do something like this?

    2. Similarly to the first one, I basically want to make it so he could use the TREND function without actually needing to use the function. So instead of typing TREND([orangevalues],[applevalues],[2013 apple value]), I'm wondering if there's a way to make that simpler for him. Something like he clicks apples and oranges (as with the graph) and the following gets something like:

    Apples Oranges
    [He inputs 2013 apples] TREND([orangevalues],[applevalues],[his 2013 apple value])




    I have absolutely no idea what I'm doing, but I'm really hoping to help him out here. Are these things even remotely feasible? Thanks.


    To sum up, in case I didn't explain it well, I'm hoping to find a way that he can have clickable buttons or check boxes for his variables, and then can click two variables and have the following happen: a scatterplot is created (preferably with axes titles) along with a trend line, trend line equation, and and r2 value, and a trend function is created where he can easily input a number and get a projection for the next year.




    Thanks in advance!

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    12,838

    Re: An easy way to make graphs?

    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

+ 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