+ 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
    17

    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
    365
    Posts
    6,266

    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
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    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
    Jeff
    | | |·| |·| |·| |·| | |:| | |·| |·|
    Read the rules
    Use code tags to [code]enclose your code![/code]

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

    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
    365
    Posts
    6,266

    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
    17

    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
    365
    Posts
    6,266

    Re: Simple graph with Excel 2016

    You’re 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)

Similar Threads

  1. V. Simple Macro has slowed down with Excel 2016
    By MattPage in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-10-2018, 01:12 PM
  2. My Excel 2016 does not show Map Chart option
    By Ibrahim Hassan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-01-2018, 10:40 AM
  3. Graph with time based horizontal axis - Excel 2016
    By Carinthl in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-21-2018, 12:29 PM
  4. [SOLVED] Excel 2016 - Plotting trend lines on a graph
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 13
    Last Post: 06-27-2018, 11:10 AM
  5. Please help - Producing a plotted graph in Excel 2016 for given data
    By gautambangalore in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 06-12-2018, 08:18 AM
  6. Excel 2016 - changing graph horizontal access & slicer question
    By clairh2011 in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-03-2017, 05:12 PM
  7. Replies: 1
    Last Post: 09-18-2017, 08:27 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