+ Reply to Thread
Results 1 to 2 of 2

Charting Time

  1. #1
    Annie
    Guest

    Charting Time

    Hi
    I have a temperature graph that I need to chart over time. From 0 to 168hrs
    but the Log chart in Custom Types gives me even spaces between the times
    which is not what I want .25mins to 168 hrs? If I was to plot the graph in
    minutes it would be too vast - huge!
    Is there any add-ins available to do this type of graph.

    Thanks
    --
    Kind regards

    Ann Shaw

  2. #2
    Jon Peltier
    Guest

    Re: Charting Time

    No add-ins necessary, just use Excel. You can put your data in decimal hours
    if you want, or enter it as hh:mm format. Don't include text labels in the
    same cell, or Excel will treat the times as categorical labels. Make an XY
    chart, not a line chart, with the times as the X values and your other
    variable as the values.

    - Jon
    -------
    Jon Peltier, Microsoft Excel MVP
    Tutorials and Custom Solutions
    http://PeltierTech.com
    _______


    "Annie" <Annie@discussions.microsoft.com> wrote in message
    news:B3B45E15-C6D6-4FE1-BC0B-C7067308239D@microsoft.com...
    > Hi
    > I have a temperature graph that I need to chart over time. From 0 to
    > 168hrs
    > but the Log chart in Custom Types gives me even spaces between the times
    > which is not what I want .25mins to 168 hrs? If I was to plot the graph
    > in
    > minutes it would be too vast - huge!
    > Is there any add-ins available to do this type of graph.
    >
    > Thanks
    > --
    > Kind regards
    >
    > Ann Shaw




+ 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