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

**brosef** · 10-29-2012, 10:41 AM

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!

**ChemistB** · 11-02-2012, 09:48 AM

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?

**brosef** · 11-02-2012, 11:38 AM

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"

**ChemistB** · 11-02-2012, 02:01 PM

See attached image
Capture.JPG

**brosef** · 11-02-2012, 03:58 PM

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

**ChemistB** · 11-02-2012, 04:19 PM

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.

**brosef** · 11-03-2012, 05:55 AM

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.

**ChemistB** · 11-05-2012, 09:01 AM

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.

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

LinkBack

Thread Tools

Rate This Thread

Display

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions