+ Reply to Thread
Results 1 to 2 of 2

Plotting a Graph of the data on a date

  1. #1
    Registered User
    Join Date
    03-06-2018
    Location
    London
    MS-Off Ver
    2016
    Posts
    3

    Exclamation Plotting a Graph of the data on a date

    I want to plot a graph of the latitude of sunspots on the y-axis against the date on the x-axis. I have a table of 33000 values, and have 4 columns with the year, month, day and then one of YYYY/MM/DD, going back 20years and then a 5th column of the latitudes either a positive or negative values depending on if its above or below the equator. I've tried plotting the YYYY/MM/DD against the latitudes and the years, months and days and they're not coming out how I want. The YYYY/MM/DD against the latitude didn't work/plot anything. How can I plot it? I want a butterfly diagram

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,462

    Re: Plotting a Graph of the data on a date

    It did not plot anything??? I would have expected it to plot something.

    It is difficult to debug based solely on your description. If you can upload a sample file to the forum, we can debug a lot better. Things I would look at:

    Are you values "numbers/dates stored as text" or real numbers/dates?
    What chart type are you trying to use?

    The process I would expect to use to create a chart would be:

    1) Select the YYYY/MM/DD column and the latitude column (D1:E33000 assuming your table starts in A1 and does NOT have a header row).
    2) Insert -> Chart -> desired chart type -> desired chart subtype
    3) Check what Excel decides to use for X and Y ranges for the chart and fix if Excel gets it wrong (Select Data dialog).

    That should give you a basic chart with date on the x axis and latitude on the y axis.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ 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. plotting a graph with variable start date
    By Trebor777 in forum Excel General
    Replies: 3
    Last Post: 11-14-2016, 12:08 PM
  2. line graph not plotting correct data
    By AWITCHER in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 04-16-2015, 10:33 AM
  3. Plotting Data in a Graph
    By RotorBladeGuy in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-10-2012, 03:42 AM
  4. Replies: 1
    Last Post: 01-01-2012, 09:54 PM
  5. How do I use two different sets of data for X axis when plotting graph?
    By trinaloup in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-09-2009, 07:23 AM
  6. Excel 2007 : Plotting Date Ranges on Same Graph
    By jwig in forum Excel General
    Replies: 0
    Last Post: 04-06-2009, 08:29 PM
  7. Plotting Cummulative Data In A Line Graph
    By tkeith in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 08-10-2006, 08:40 PM

Tags for this Thread

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