+ Reply to Thread
Results 1 to 2 of 2

Graph showing daily data for two different years

  1. #1
    Registered User
    Join Date
    10-22-2013
    Location
    Ahmedabad, India
    MS-Off Ver
    Excel 2007
    Posts
    1

    Question Graph showing daily data for two different years

    Hi all,

    Need help with plotting a graph.

    I have daily data with me . i.e - Jan 2012 - 31 days of data
    Feb 2012 - 29 days of data
    March 2012 - 31 days of data ......and so on ..

    On primary X-axis i have : time/days (which i need in scatter form)
    On primary Y-axis i have : Temp. (which i need in scatter form)
    On secondary X-axis i have : power consumption. (which i need in bar form)

    How do i draw a graph in which i can include all days of a year on the X-axis ???

    I have been trying by merging the date, month & year columns into one as 1-Jan-2012, but it doesn't seem to work !!

    I know its going to be a huge graph ....but that's what my Boss has asked me to do !!

    H-E-L-P !!!

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Graph showing daily data for two different years

    Welcome to the Forum!

    I would need to see how you have organized your data. This is a very straightforward problem if the data is organized properly.

    It will be much easier to understand your problem if you provide your file. This allows us to see your data, layout, much easier than describing it in several paragraphs. To post a file:
    1. Under the text box where you type your reply click the Go Advanced button.
    2. In the next screen look above the reply box and click the "paper clip" icon. You will get a pop-up screen.
    3. In the pop-up, click Add then Select to select a file from your local drive
    4. Click the Upload button to upload the file
    5. Click Done to attach it.

    It will be displayed as an attachment underneath your post text. Alternatively as the last step you can click the Insert Inline button and a hyperlink to the file will be inserted directly into your post text in the spot where your cursor is set at the moment you click the button.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

+ 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. How do I split daily time series data into seasonality grid by years
    By Oilking in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-20-2018, 04:40 AM
  2. Replies: 3
    Last Post: 09-27-2013, 09:27 PM
  3. [SOLVED] Help in making month cumulative of years of daily data
    By ropbasuel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-11-2013, 12:12 PM
  4. Replies: 2
    Last Post: 06-07-2012, 09:20 AM
  5. [SOLVED] How do I Fill a column with dates (for 3 years of daily data)
    By Apple_pi in forum Excel General
    Replies: 1
    Last Post: 02-18-2006, 04:55 PM

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