excel - Display simulated data in chart -


i wondering how chart following data in line chart in excel:

enter image description here

in chart below, 20 simulated data points nav mo+1 20 possible values in first month in future (mo+1). next set represents 20 simulated navs in second month (mo+2).

the chart should 1 below:

enter image description here

problem charts end looking more this:

enter image description here

thanks input!

there default structures each chart defined microsoft:

http://office.microsoft.com/en-us/excel-help/select-data-for-a-chart-ha102809318.aspx

however not sufficient. better edit data source , mapping manually. described here:

http://www.dummies.com/how-to/content/how-to-edit-a-charts-data-source-in-excel-2010.html


Comments

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

android - Keyboard hides my half of edit-text and button below it even in scroll view -

css - Make div keyboard-scrollable in jQuery Mobile? -