+ Reply to Thread
Results 1 to 6 of 6

Changing the slope of a chart when user change on the sliding scale

  1. #1
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,067

    Changing the slope of a chart when user change on the sliding scale

    Hello Excel Experts,

    First of all, I DON'T KNOW if it is doable.

    I'm trying to create a chart of elastic/inelastic where given a sliding scale, and when a user uses it (sliding scale), the chart changes of it's slope from elastic to inelastic or vice versa.

    Is it possible to create this chart?

    If it's doable, is there a source that you can refer me to, so that I can learn how to do it.

    Thank you!

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: Changing the slope of a chart when user change on the sliding scale

    It's hard to say, though I am generally optimistic that most things are possible with enough time, knowledge, effort, and ingenuity.

    At this point, I am having a hard time visualizing what you mean by "elastic/inelastic" and "sliding scale", and how a user will interact with these elements. It might also help to know what chart type you are using. Something that involves "slope" suggests a line or scatter chart to me. I also find that a lot of chart questions end up being spreadsheet questions, and I wonder if this is likewise going to be about what to do in the spreadsheet to get the chart to change.

    With more details about what you are trying to do, we can see how we can help.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,067

    Re: Changing the slope of a chart when user change on the sliding scale

    At this point, I am having a hard time visualizing what you mean by "elastic/inelastic"
    Basically, a chart that shows a elastic/inelastic is a DEMAND LINE CHART, where the demand slope is -m, the steeper the slope (closer to vertical line), the inelastic it is, whereas the horizontal the slope is, the elastic it is.

    sliding scale
    Think of it as a sliding scale of our volume, where when we slide it up, our volume increases, and if we slide it down, it decreases. The sliding scale can be vertically or horizontally. The purpose of this sliding scale is so that when a user slides (up/down or left/right), the chart becomes either elastic/inelastic, in other words, the chart moves to be either more vertical or more horizontal.

    Something that involves "slope" suggests a line or scatter chart to me
    At this point, since I'm making it easy, a DEMAND LINE chart is good. What this means is that the demand chart slope is a line, and not a curve. Therefore, PROBABLY a scatter chart would be the choice as a point in a chart makes up 2 data (price in Y-axis and demand in x-axis), therefore, to make a line, it needs 2 points -> 4 data

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: Changing the slope of a chart when user change on the sliding scale

    So I see a few steps to this:

    1) Enter the slope (or whatever your desired input data are) -- you mention using a slider. How much of your question is how to add a slider or similar control to a spreadsheet? https://support.office.com/en-us/art...rs=en-US&ad=US I don't use these kinds of controls, so, other than being aware they exist, I'm not sure how much I can help with using them.
    2) From the slope and the desired placement on the graph, compute the desired x and y values for the end points of the line segment in the spreadsheet. This is probably more algebra than spreadsheet. Do you recall how to generate a line based on slope?
    3) Generate the chart. (of course, this only needs to be done when first building the spreadsheet. Once the chart is in place, it should update as data are changed/calculated.)

    Does it look like I am understanding what you are trying to do? Which of those steps do you have trouble with?

  5. #5
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,067

    Re: Changing the slope of a chart when user change on the sliding scale

    so assume that you're able to do step 1 to 3 and that you have the graph.

    My question is, using the sliding scale, or similar control, how do you make the graph that you have created to be interactive and changed it's slope?

    For example, using the horizontal sliding scale, when the user slide to the extreme left, the slope of the graph now becomes a horizontal line (slope), if user slide to the extreme right, it becomes a vertical line (slope), and if user say has the sliding scale to be in the middle, the slope becomes 45 degree, if user slide to be 25% from the left, the slope becomes x degree angle etc

  6. #6
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,826

    Re: Changing the slope of a chart when user change on the sliding scale

    If I understand the question, it sounds like you are stuck on step 2 -- how to take the angle or slope (depending on your preference) that the slider control gives and calculate two x,y data points for the chart.

    You talk about having the slider give an angle in degrees. That might be the easiest way to do this -- assuming you remember your basic trig and can remember what you learned about the unit circle (I have a spreadsheet here, if it will help: https://www.excelforum.com/tips-and-...han-excel.html ).
    1) Enter 0 and 0 in two adjacent cells to represent one end of the line.
    2) Enter =COS(RADIANS(cell with slider output)) beneath the "x" 0.
    3) Enter =SIN(RADIANS(cell with slider output)) beneath the "y" 0.
    4) Create scatter chart using these 4 cells, make sure that it assigns the correct "series in rows/columns", and possible format the axes to be 0 to 1.

    If you find the trig confusing, the same thing can be done by having the slider output a "rise over run" slope and then remember your early algebra (http://www.purplemath.com/modules/graphing.htm ) about graphing and select reasonable values the x and y values for the two data points, and chart them. (I would probably use 0,0 for one point again, then use x2=1 y2=cell with slope*1 to get the second y point.). This approach would definitely require that you limit the values of the axes to something reasonable (0 to 1 again?).

    The key to tying the slider to the chart is to use the output of the slider to compute the x,y values for the data points that will be charted in the chart.

+ 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. Add a line to an excel automated sliding scale chart
    By deckyflynn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 12-20-2017, 08:02 AM
  2. Sliding Scale
    By Brad0910 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2016, 12:31 AM
  3. [SOLVED] Sliding Scale
    By jmalia in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-13-2015, 09:02 PM
  4. [SOLVED] sliding scale
    By allgeef in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2014, 12:13 PM
  5. sliding scale?
    By GardenGrow in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 03-30-2014, 08:50 PM
  6. [SOLVED] sliding scale???
    By GardenGrow in forum Excel General
    Replies: 6
    Last Post: 03-29-2014, 01:15 PM
  7. Change time scale in a chart by changing cell value
    By Niels in forum Excel General
    Replies: 1
    Last Post: 12-28-2005, 12:55 AM

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