Excel line chart using macro

[smartgd]

Hi All,

I need help to draw line chart using Excel macro.

I have a table

1-Jun-2012 2-Jun-2012 3-Jun-2012
ID Description Rank Rank Rank
id1 ... 2 4 5
id2 ...... 3 5 7
id3 ........ 1 3 8


Need to add a list box , it will list id1,id2,id3. when I select id1 then i want to get a line graph with
x axis- 1-Jun-2012, 2-Jun-2012, 3-Jun-2012,...
y axis- 2, 4, 5



Thanks,
Smartgd

[npamcpp]

This can be done without a macro.

One possible approach is to use a Vlookup formula to populate the cells that feed the chart. See attached. Select an ID in the yellow cell. The chart will update.

Other approaches, without VBA, could involve using named ranges.

Let me know if this works for you or if you would like a different approach.

[smartgd]

Hi,

your attached file works fine, but i like to do with macro.



Thanks,
smartgd