+ Reply to Thread
Results 1 to 5 of 5

cannot create a graph from the data

  1. #1
    Registered User
    Join Date
    09-29-2010
    Location
    amsterdam, netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    cannot create a graph from the data

    Hello,

    I am trying to create a simple graph from simple data. However, it does not work.
    Basically I would like a line-graph of temperature values that are taken every 30 minutes.

    please see the file attached.
    Can anybody point me in the right direction?

    thanks
    Alexander
    Attached Files Attached Files

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: cannot create a graph from the data

    hi ahvroom,
    Welcome to the forum
    Does this help plotting value every 30 mins?
    Attached Files Attached Files
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Registered User
    Join Date
    09-29-2010
    Location
    amsterdam, netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: cannot create a graph from the data

    hello Pike

    thanks for looking at this.
    and yes, what you propose is indeed a work-around.
    although I had hoped to maintain the date and time values.

    best regards
    Alex

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

    Re: cannot create a graph from the data

    Just select the data in columns A and B from row 1 to 337 and select Insert - Scatter with straight lines.

    Works without a hitch at my end.

    However, it does not work.
    Can you elaborate? What are you doing and what is the outcome/error message/(unwanted) result??

    "Does not work" is never good enough a description to provide further help.

  5. #5
    Registered User
    Join Date
    09-29-2010
    Location
    amsterdam, netherlands
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: cannot create a graph from the data

    thanks
    this is what i was looking for !

    alex

+ 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