+ Reply to Thread
Results 1 to 8 of 8

Problem creating Line Chart from columns "date" and "money"

  1. #1
    Registered User
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    4

    Problem creating Line Chart from columns "date" and "money"

    I suspect it's a stupid problem with a simple solution but I'm lost!

    See attached file for the sheet in question.
    Untitled.png

    1) How do I make this into a nice line chart that has DATE on the horizontal axis and MONEY on the vertical axis.
    2) Can I make a "PROJECTION" or estimate line graph that estimates future MONEY for a set number of months?

    Thanks in advance!
    Attached Files Attached Files
    Last edited by brosef; 11-03-2012 at 05:56 AM. Reason: Solved!

  2. #2
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576

    Re: Problem creating Line Chart from columns "date" and "money"

    Click on the chart, then in the ribbon, Chart Tools Design Tab
    Choose "Select Data" (a window will open)
    "Edit" for the x horizontal axis
    =Sheet1!$D$7:$D$17

    "Edit" for the y vertical axis
    Name =Sheet1!$E$6
    Values =Sheet1!$E$7:$E$17
    Does that work for you?
    ChemistB
    My 2

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Registered User
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem creating Line Chart from columns "date" and "money"

    Thanks for the reply ChemistB. I tried, but I'm not seeing where to perform step 2 of your instruction: editing the vertical Y axis. This is what I'm looking at after having completed the first step ("Edit" for the x horizontal axis =Sheet1!$D$7:$D$17)

    See image:
    data_select.png

    I basically want a Scrooge McDuck like graph that tracks the increase in "money"

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576

    Re: Problem creating Line Chart from columns "date" and "money"

    See attached image
    Capture.JPG

  5. #5
    Registered User
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem creating Line Chart from columns "date" and "money"

    Okay, I see. When I do what you described, the result is this:

    money-chart-woes.png

    The format looks okay, with dates on the Y axis and money on the X axis, but there is no line, nothing appears

    I'm sorry if I'm being dense

  6. #6
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576

    Re: Problem creating Line Chart from columns "date" and "money"

    I think Excel is not seeing your data as numbers. In another cell, enter =ISNUMBER(E7) and see if it comes up True or False. I'm attaching my workbook where I followed the steps I outlined to you.
    Attached Files Attached Files
    Last edited by ChemistB; 11-02-2012 at 04:22 PM.

  7. #7
    Registered User
    Join Date
    10-29-2012
    Location
    Europe
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Problem creating Line Chart from columns "date" and "money"

    You're right! All along excel never recognized my numbers as numbers, even though they sure look like proper numbers to me

    Is there any way of converting them besides hand-typing them manually, I wonder. Oh well, now to see if I can make a prognosis / future estimate graph that charts money into the future.

    Thank you so much for you help ChemistB, you're awesome! Changing thread tag now.

  8. #8
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,576

    Re: Problem creating Line Chart from columns "date" and "money"

    Is there any way of converting them besides hand-typing them manually, I wonder.
    First step is to figure out why Excel is seeing it as a number. Maybe the cells are formatted as text;
    Reformat the cells and then use "Text to Columns" to get Excel to recognize they've been changed
    or there are spaces before or after the numbers;
    Use find/replace to remove them and use Text to Columns or use TRIM to fix them in an other column
    They might have invisible characters that are not spaces;
    Find out what they are using =CODE(MID(A1, location,1)) and then use SUBSTITUTE to remove them
    Sometimes just adding 0 to them works, sometimes it's much more complex.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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