Results 1 to 3 of 3

Thread: How to graph daily data in to monthly excel sheet

  1. #1
    Join Date
    May 2009
    Posts
    136

    How to graph daily data in to monthly excel sheet

    I'm trying to share prices across over a five-year period and would like to graph it on a daily basis. but the problem is that when i try to chart five-years worth of daily prices, the grapg loses ts clearity. So, i would like to know that is it possible for me to run a Macro or something else which would automatically convert daily data in to monthly excel sheet? Is it possible for me to do so? Kindly provide me the correct solution for the above issue.

  2. #2
    Join Date
    May 2008
    Posts
    4,831

    Re: How to graph daily data in to monthly excel sheet

    The Historical Database Reporter software is an effective way to query time tagged field data for a specific station or point and then move the data into a powerful Microsoft Access database for analysis and reporting. This software is available in a DDE version or serial version to fit your specific needs. The DDE version allows the operator to poll a site on demand. The serial version must wait for the site to call the operator. The data is displayed in columns starting with date, time, station, point, value, and point type.

  3. #3
    Join Date
    Apr 2008
    Posts
    4,088

    Re: How to graph daily data in to monthly excel sheet

    To display the month and year at the bottom of the chart, right click the horizontal axis, choose Format Axis, and then choose the Patterns tab. Then you need to select the top-left chart sub-type. Afterwards click on Next, and again you need to click on Next. Then on the Tick Mark Labels option box, you need to choose the Low option.

Similar Threads

  1. Replies: 4
    Last Post: 04-01-2014, 10:47 AM
  2. Replies: 1
    Last Post: 25-02-2012, 11:31 AM
  3. Replies: 2
    Last Post: 17-02-2012, 02:06 PM
  4. Replies: 3
    Last Post: 13-01-2012, 04:57 PM
  5. How to create excel graph data for a month in Windows Vista
    By AK_Chopra in forum Windows Software
    Replies: 2
    Last Post: 04-06-2009, 07:58 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
  •  
Page generated in 1,713,597,196.39529 seconds with 17 queries