Creating a Graph in Excel using drop downs [Closed]

 Trowa -
I have a file, that we are tracking leads. In the file, we have several components, but 2 specific components I'd like to graph. We have a Date Column(which includes the date as follows: 3/6/2010, 4/1/2010, 4/7/2010, 5/1/2010, etc - so different months on the same worksheet). And a Source Column. The Source Column has a drop-down list to choose where the source came from.

1) I'd like to create a comparison graph that shows as follows:
--The Vertical Access would show the # of Leads
-- The Horitzontal Access would show the Type of Lead
-- Each Lead type would have a Bar Graph of the # of leads per month (so if doing January, February, March and April, each horizontal lead type would have 4 different bars (each month) showing it's progress.

Please help!

1 reply

Hi Carolyn,

Creating a graph is basicly a step by step action guided by excel.

I'm not entirely sure if I understand what you want, but if you upload your file using a file sharing site like, things might be clear enough for me to help you.

Best regards,

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!