Create a mountain chart from drop down menu

**mcgowanpm** · 10-21-2009, 03:08 PM

Trying to create a mountain chart using multiple rows of data. The chart will populate via a selection from a drop down menu. Received an error message stating series can not use multiple cells, rows or columns, only single. Any suggestions on an alternative?

**teylyn** · 10-21-2009, 04:31 PM

Hi,

I'd be happy to have a look, but the file is too big for my data plan. Could you possibly create a small sample file that illustrates what you want to do?

**mcgowanpm** · 10-21-2009, 05:04 PM

Use this format to create a mountain chart.

**teylyn** · 10-21-2009, 06:04 PM

Ok. So, now, what exactly do you mean by "Mountain Chart"? can you show an example?

**mcgowanpm** · 10-22-2009, 10:59 AM

Example attached. Mountain chart meaning the graph will show the progression of a return from all points in time. For example, from December 2008 to October 2009 the chart will show every daily return number.

**teylyn** · 10-22-2009, 03:54 PM

Sorry, I won't download anything that big. Can you put together a small file or point me to somewhere that illustrates a mountain chart? Do yo mean a Histogram or a bell curve?