+ Reply to Thread
Results 1 to 7 of 7

Simple graph with Excel 2016

  1. #1
    Registered User
    Join Date
    01-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    15

    Question Simple graph with Excel 2016

    I've been struggling for more than an hour to create a simplke graph but the axes data are all wrong and I can't change them the way I want. Excel is so unintuitive. I've managed to get the RPM data on the horizontal axis but I want the NM data on the left vertical axis and the HP on the right vertical axis and it seems impossible. HELP!

    screen.jpg

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,670

    Re: Simple graph with Excel 2016

    See attachment. Is this what you're looking for?

    If so, I'll explain how to create it.
    Attached Files Attached Files

  3. #3
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    Pro 2019
    Posts
    14,792

    Re: Simple graph with Excel 2016

    First, an image attachment has limited value. Just attach the Excel file. It's easier than taking a screenshot first and then attaching that. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

    Second, I think there is some confusion about what you want to plot, which is why you are having trouble with Excel. You seem to be using RPM as an independent variable, but your first value should be 1000. Instead you have selected cell C6 ("RPM") as your first value, which shows up as your first value on the x axis. If you want to use two y axes you have to plot two lines. Also, I don't know what's in your image but your data is not linear.

    Because your data set is small I have mocked this up for you.
    Attached Files Attached Files
    Making the world a better place one fret at a time | | |會 |會 |會 |會 | |:| | |會 |會
    Please read the rules
    If someone helped you, click on the star icon at the bottom of their post
    If your problem is solved, go to Thread Tools and select Mark This Thread Solved
    Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.

  4. #4
    Registered User
    Join Date
    01-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Simple graph with Excel 2016

    Exactly what I wa tryhing to do.

  5. #5
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,670

    Re: Simple graph with Excel 2016

    To create the chart, follow these steps:

    1) Highlight B6:D17 > Insert > Choose chart type (I think Scatter with Smooth Lines looks the best for this)
    2) Right-click on the HP line > Format data series > Change to Secondary Axis
    3) Now you can add Axis Titles through the Design tab under Add Chart Element

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

  6. #6
    Registered User
    Join Date
    01-27-2014
    Location
    Stockholm, Sweden
    MS-Off Ver
    Excel 2016
    Posts
    15

    Re: Simple graph with Excel 2016

    Thank you 63falcondude

  7. #7
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    2016
    Posts
    5,670

    Re: Simple graph with Excel 2016

    Youre welcome. Glad we could help.

+ 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