Macro to draw a Line Graph

**jmadsen** · 08-31-2010, 01:16 PM

Hi all,

I would like to draw an line graph.

In Row 4 I have = C4 : G4 = the values 2009 2008 2007 2006 2005

In Row 5 I have = C5 : G5 = the values 0,5 1,3 -2,5 3,4 6,5

I would like to draw a Line graph where (create a Macro)

the x-axis = C4 : G4
the y-axis = C5 : G5

I have tried to use some the examples in this Forum, but with no luck.

Please help.

Regards,

**Andy Pope** · 09-01-2010, 09:15 AM

I used the marco recorder to get the following.

Please Login or Register  to view this content.

If the values in C4:G4 are numeric then the chart will probably contain 2 lines and default axis labels. This is because Excel guessed the year values where actual another data series.
You can avoid this by making the cells text by entering a single quote before the value, example '2009

**jmadsen** · 09-01-2010, 04:22 PM

I have found this code.

Please Login or Register  to view this content.

This code only stacks the values vertically.

I have attached a .jpg on how I would like the result to be.

Please advice...

Regards,

**Andy Pope** · 09-02-2010, 03:52 AM

Did you try using the macro recorder?
Did you try the code example I posted?

**jmadsen** · 09-02-2010, 04:10 AM

Hi Andy,

Your example worked fine and Your advice regarding using the macro-recorder
was excellent. This is helpfull when I need to know the code for properties for
the objects.

I hope to be able to make a macro I can re-use. I would like to just
send parameters to the procedure and then it generates a graph.
The parameters would be the Range and the type of graph.

Regards,

**Andy Pope** · 09-02-2010, 04:22 AM

Please Login or Register  to view this content.

**jmadsen** · 09-02-2010, 04:47 AM

So simple

. Thanks alot Andy.

**achirag** · 10-16-2012, 12:44 PM

i have a query over here what if my data keeps increasing as in if i have a data from a1 to az5 today and then tomorrow i have data from a1 to bc5 how do i get a chat correct without grand total

**arlu1201** · 10-16-2012, 01:18 PM

Achirag,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.