View original (French)

Graph: evolution of y AS A FUNCTION OF x

Solved
ChatMarche! Posted messages 5 Status Member -  
ChatMarche! Posted messages 5 Status Member -
Hello,
I often encounter a problem that Excel's help has never solved regarding charts, which forces me to use Regressi.

It is simply about choosing both a range of values for the y-axis and for the x-axis. Indeed, I currently cannot select my range of values for the x-axis, and I end up with the scale 1,2,3,4,5,6...

Explanation with my example:
In a game, the loading speed of goods at a port depends on the level of the port.
If I want the speed based on the level, there’s no problem; I just need to select the column containing the range of speed values, and it plots a chart with a linear scale on the x-axis corresponding to the building level (1,2,3,4,5...).

But let’s imagine I want to plot the evolution of speed based on resources spent (to increase the port level and thus speed)?
This means I need to consider two data ranges, speed and resources, to plot one against the other...

How can I do this?

- Excel 2013.
- Chart in the form of a line or histogram.

Thank you in advance!

7 answers

  1.
    ccm81 Posted messages 11033 Status Member 2 434
     
    Hello

    Have you tried with the scatter plot type?

    Best regards
    0
  2. ChatMarche! Posted messages 5 Status Member
     
    Good evening,
    The nature of the graph doesn't change anything; I still can't find where to specify the abscissa I want.

    Thank you anyway,
    Have a good evening.
    0
  3. ccm81 Posted messages 11033 Status Member 2 434
     
    But yes, with the point cloud type, you have an x-axis with a real scale, and you can choose the data range corresponding to that x-axis

    Regards
    0
  4. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
     
    If you sent your file, we would immediately see where the anomaly is...
    Go to https://www.cjoint.com/ to create the link, which you will come back to paste here.

    --
    Retirement is great! Especially in the Antilles... :-)
    ☻ Raymond ♂
    0
  6. ChatMarche! Posted messages 5 Status Member
     
    Good evening,
    Here is the link to the document: https://www.cjoint.com/?DDyxML3V1eM

    The table lists the various evolving characteristics of the building.
    What I'm interested in is tracing the evolution of speed (this information is contained in the "Speed (mar/min)" column) in relation to the number of resources spent at each level (not cumulative) (this information is contained in the "Total" column).

    Also, I would like to know how to indicate the names of the axes (write next to it, actually).

    Thank you for your help!
    0
  7. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
     
    Select D1:D49;F1:F49
    (click on D1; hold down the [Shift] key while clicking on D49; release everything; hold down the [Ctrl] key while clicking on F1; release everything; hold down the [Shift] key while clicking on F49; release everything)
    Go to Insert/Chart/Scatter
    In 
    Chart Tools
    go to the Design tab; in the Labels group select Axis Titles ...
    You need to select the [Axis Title] button displayed by Excel and go to the formula bar to write the sign 
    =
    and click in cell D1 or F1, respectively.
    https://www.cjoint.com/?DDza1IJhR4J

    Best regards.

    Retirement is great! Especially in the Caribbean... :-)
    ☻ Raymond ♂
    0
    1. Raymond PENTIER Posted messages 58229 Registration date   Status Contributor Last intervention   17 491
       
      We end up with the same information three times 
       Speed (mar/min)
      : the title at the top, the legend on the right, and the name of the vertical axis on the left; we need to eliminate at least one!
      0
  8. ChatMarche! Posted messages 5 Status Member
     
    Chat works!
    Great, I hadn't thought of selecting both ranges at once...
    Thank you very much!
    0