+ Reply to Thread
Results 1 to 2 of 2

How to plot a graph?

  1. #1
    Registered User
    Join Date
    04-17-2011
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to plot a graph?

    Hi there!
    I'm pretty new to Excel and having a huge problem on bringing these following attached data into a graph like in the png file.
    I'm still working on getting familiar with this so it would be great if you guys can help me out. Thanks in advance
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: How to plot a graph?

    Hello,

    select A1 to B50
    Click Insert > Chart and select the Scatter (XY) chart. Follow the wizard or click Finish

    This will show the chart with one series. To add another series:

    Select C1 to C50
    Copy the selection
    Click the chart and use Edit > Paste Special > OK

    This will add the new series data to the chart, but their values are so small that they are very close to the X axis. Select the new series, open the Format dialog and on the Axis tab select "Secondary Axis"

    Select D1 to D50, copy and use Paste Special to add this data to the chart. Again, the data values are much smaller than the second series, and although this series is already plotted on the secondary axis, the values all seem to be close to zero.

    The data does not lend itself well to being represented in a single chart.

    See attached.
    Attached Files Attached Files

+ 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